|
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, July 16, 2015
Oracle Applications INV, BOM and WIP Table Joins
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment