Oracle Apps Techno Functional................

Some important Tables Joins in Oracle apps WIP, BOM, INV 1) BOM : BOM_RESOURCES (BR) BOM_BILL_OF_MATERIALS (BBOM) BOM_DEPARTMENTS (BD) BOM_OPERATIONAL_ROUTINGS (BOR) BOM_OPERATION_SEQUENCES (BOS) BOM_OPERATION_SEQUENCES (BOS) BOM_INVENTORY_COMPONENTS (BIC) BOM_STANDARD_OPERATIONS (BSO) 2) INV :  MTL_PARAMETERS (MP) MTL_SYSTEM_ITEMS_B (MSIB) MTL_MATERIAL_TRANSACTION (MTT) MTL_SERIAL_NUMBERS (MSN) MTL_ITEM_REVISIONS (MIR) MTL_ITEM_CATEGORIES (MIC) MTL_DEMAND (MD) MTL_TRANSACTION_TYPES (MTTY) MTL_CATEGORIES (MC) CST_ITEM_COSTS (CIC) CST_COST_ELEMENTS (CCE) 3) WIP : WIP_PARAMETERS (WP) WIP_DISCRETE_JOBS (WDJ) WIP_ENTITIES (WE) WIP_OPERATIONS (WO) WIP_REQUIREMENT_OPERATIONS (WRO) WIP_OPERATION_RESOURCES (WOR) WIP_TRANSACTIONS (WT) WIP_TRANSACTION_ACCOUNTS (WTA) WIP_LINES (WL) WIP_EAM_WORK_REQUESTS (WEWR) WIP_EAM_PARAMETERS (WEP) 1) JOINS IN BOM and BOM-INV BOM_B...

How to find item cost Another  common issue when  writing  queries is getting an item cost. Here are the  APIs  to use in queries: For discrete manufacturing: cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) here is a sample query: select segment1 item, cst _cost_ api .get_item_cost(1,inventory_item_id, organization_id,NULL,NULL) cost from  mtl _system_items_b If you are in an  OPM  organization the above won't work and instead you need to call select  msi .segment1 item, GMF _ CMCOMMON .get_ cmpt _cost( inventory_item_id, organization_id,  sysdate ,  cmm .cost_type_id ,0) cost from  mtl _system_items_b  msi , CM_ MTHD _MST  cmm where  cmm .cost_ mthd _ desc ='Standard Cost'

This blog provide basic understanding about Oracle Inventory Transactions and Cost processing procedure. SCOPE & APPLICATION ------------------- Oracle manufacturing customers, support, and consulting.    Transactions - Unprocessed Transactions/Closing INV Accounting Period (TRXN-STK) This document will be used to explain the flow of transactions from the MTL_TRANSACTIONS_INTERFACE to the GL_INTERFACE. The aim of this document is to help and assist in resolution of Interface related issues. CONTENTS -------- Q1.  What is the MTL_TRANSACTIONS_INTERFACE table used for? Q2.  What is the MTL_MATERIAL_TRANSACTIONS_TEMP table used for? Q3.  What type of issues will you see with the MTL__TRANSACTIONS_INTERFACE and      MTL_MATERIAL_TRANSACTIONS_TEMP tables? Q4.  What type of issues will you see with the MTL_MATERIAL_TRANSACTIONS table? Q5.  What type of issues will you see with the MTL_TRANSACTION_ACCOU...