DBA Data[Home] [Help]

APPS.BOMPCCLT dependencies on BOM_BILL_OF_MATERIALS

Line 20: BOM_BILL_OF_MATERIALS

16: mtl_system_items with cumulative lead time values.
17: Required Tables :
18: BOM_PARAMETERS
19: BOM_INVENTORY_COMPONENTS
20: BOM_BILL_OF_MATERIALS
21: BOM_LOW_LEVEL_CODES
22: MTL_SYSTEM_ITEMS
23: History
24: 20-Feb-1996 Manu Chadha

Line 66: BOM_BILL_OF_MATERIALS BOM

62: SELECT COM.COMPONENT_ITEM_ID
63: FROM MTL_SYSTEM_ITEMS MTL2,
64: BOM_INVENTORY_COMPONENTS COM,
65: MTL_SYSTEM_ITEMS MTL1,
66: BOM_BILL_OF_MATERIALS BOM
67: WHERE NVL(BOM.ALTERNATE_BOM_DESIGNATOR,'XXXXXXXXXXX') =
68: NVL(p_alternate_bom_code,'XXXXXXXXXXX')
69: AND COM.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
70: AND BOM.ORGANIZATION_ID = p_org_id

Line 366: BOM_BILL_OF_MATERIALS BOM

362: COM.OPERATION_SEQ_NUM
363: FROM MTL_SYSTEM_ITEMS MTL2,
364: BOM_INVENTORY_COMPONENTS COM,
365: MTL_SYSTEM_ITEMS MTL1,
366: BOM_BILL_OF_MATERIALS BOM
367: WHERE BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
368: AND COM.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
369: AND BOM.ORGANIZATION_ID = p_org_id
370: AND BOM.ASSEMBLY_ITEM_ID = p_item_id