1) JOINS IN BOM and BOM-INV
|
BOM_BILL_OF_MATERIALS (BBOM) MTL_SYSTEM_ITEMS_B (MSIB)
|
organization_id organization_id
|
assembly_item_id inventory_item_id
|
MTL_SYSTEM_ITEMS_B (MSIB) BOM_OPERATIONAL_ROUTINGS (BOR)
|
inventory_item_id assembly_item_id
|
organization_id organization_id
|
BOM_BILL_OF_MATERIALS (BBOM) BOM_INVENTORY_COMPONENTS (BIC)
|
bill_sequence_id bill_sequence_id
|
BOM_INVENTORY_COMPONENTS (BIC) MTL_SYSTEM_ITEMS_B (MSIB)
|
component_item_id inventory_item_id
|
BOM_OPERATIONAL_ROUTINGS(BOR) BOM_OPERATION_SEQUENCES(B0S)
|
routing_sequence_id routing_sequence_id
|
BOM_OPERATION_SEQUENCES (BOS) BOM_STANDARD_OPERATIONS (BSO)
|
standard_operation_id standard_operation_id
|
BOM_OPEARATION_SEQUENCES(BOS) BOM_DEPARTMENTS (BD)
|
department_id department_id
|
BOM_DEPARTMENTS (BD) BOM_DEPARTMENT_CLASSES
|
department_id department_id
|
operation_sequence_id operation_sequence_id
|
BOM_OPERATION_RESOURCE (BORE) BOM_RESOURCES (BR)
|
resource_id resource_id
|
BOM_DEPARMTENTS (BD) BOM_RESOURCES (BR)
|
organization_id organization_id
|
2) JOINS IN INV :
|
MTL_SYSTEM_ITEMS_B (MSIB) MTL_PARAMETERS (MP)
|
organization_id organization_id
|
MTL_MATERIAL_TRANSACTION (MMT) MTL_TRANSACTION_TYPES (MTT)
|
transaction_type_id transaction_type_id
|
MTL_MATERIAL_TRANSACTION (MMT) MTL_ITEM_CATEGORIES (MIC)
|
organization_id organization_id
|
inventory_item_id inventory_item_id
|
MTL_MATERIAL_TRANSACTION (MMT) MTL_SYSTEM_ITEMS_B(MSIB)
|
inventory_item_id inventory_item_id
|
MTL_TRANSACTION_TYPES (MTT) MTL_SYSTEM_ITEMS_B(MSIB)
|
inventory_item_id inventory_item_id
|
MTL_ITEM_REVISIONS(MIR) MTL_SYSTEM_ITEMS_B(MSIB)
|
inventory_item_id inventory_item_id
|
organization_id organization_id
|
CST_ITEM_COSTS(CIC) MTL_SYSTEM_ITEMS_B(MSIB)
|
inventory_item_id inventory_item_id
|
organization_id organization_id
|
MTL_ITEM_CATEGORIES (MIC) MTL_CATEGORIES (MC)
|
category_id category_id
|
JOINS IN INV WITH OTHER MODULES :
|
MTL_SYSTEM_ITEMS_B (MSIB) RCV_TRANSACTIONS
|
organization_id organization_id
|
MTL_SYSTEM_ITEMS_B (MSIB) HR_EMPLOYEES
|
buyer_id employee_id
|
3) JOINS IN WIP :
|
WIP_ENTITIES (WE) WIP_TRANSACTIONS (WT)
|
organization_id organization_id
|
wip_entity_id wip_entity_id
|
WIP_TRANSACTION_ACCOUNTS (WTA) WIP_TRANSACTIONS (WT)
|
transaction_id transaction_id
|
WIP_LINES (WL) WIP_TRANSACTIONS(WT)
|
line_id line_id
|
WIP_DISCRETE_JOBS (WDJ) WIP_ENTITIES (WE)
|
wip_entity_id wip_entity_id
|
WIP_ENTITIES (WE) WIP_OPERATION_RESOURCES (WOR)
|
wip_entity_id wip_entity_id
|
WIP_ENTITITES (WE) WIP_REQUIREMENT_OPERATIONS
|
organization_id organization_id
|
WIP_ENTITIES WIP_OPERATIONS
|
wip_entity_id wip_entity_id
|
organization_id organization_id
|
JOINS IN WIP WITH OTHER MODULES
|
WIP_TRANSACTION_ACCOUNTS (WTA) PO_HEADERS_ALL (POH)
|
po_header_id po_header_id
|
CST_COST_ELEMENTS (CSE) WIP_TRANSACTION (WT)
|
cst_element_id cst_element_id
|
WIP_OPERATIONS (WO) BOM_DEPARTMENTS (BD)
|
department_id department_id
|
WIP_ENTITIES (WE) MTL_SYSTEM_ITEMS_B (MSIB)
|
organization_id organization_id
|
primary_item_id inventory_item_id
|
WIP_OPERATION_RESOURCES (WOR) BOM_RESOURCES (BR)
|
resource_id resource_id
|
Thursday, 22 May 2014
Oracle Inventory,WIP,BOM Tables and Links
Subscribe to:
Post Comments (Atom)
http://oracleebspro.blogspot.in/2013/07/some-important-tables-joins-in-oracle.html
ReplyDeleteHi all, Oracle technical and fusion cloud SCM online classes, if you are interested whatsapp to this number 7382582893, thank you.
ReplyDeleteRajasthan Board of Secondary Education( RBSE) conducts final board examinations for the students of Rajasthan. It is a school level exam that examines the students who have completed a prescribed course of study Rajasthan 10th Model Paper 2021 and awards certificates to the qualifying students. The board exams. RBSE 10th model paper is available on this website in PDF format for the students to download.
ReplyDeleteHinduja Global Solutions (HGS) then this is the perfect guide for you as we will discuss more, how you can access your HRMS platform and see how you can check your employee payslip details as well. HGS salary slip Hinduja Global Solutions (HGS) as we all know is a big corporation and they have created their HRMS platform, which a HGS Employee Self service portal provides the login to employees to access different features.
ReplyDelete