DBA Data[Home] [Help]

APPS.BOMPCCLT dependencies on BOM_INVENTORY_COMPONENTS

Line 19: BOM_INVENTORY_COMPONENTS

15: times for a given bom level. Procedure update_lt updates
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

Line 64: BOM_INVENTORY_COMPONENTS COM,

60: Cursor l_comps_csr (p_org_id number, p_item_id number, p_unit_number varchar2,
61: p_eff_date date) is
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')

Line 364: BOM_INVENTORY_COMPONENTS COM,

360: SELECT NVL(MTL2.CUMULATIVE_TOTAL_LEAD_TIME, 0) CUMULATIVE_TOTAL_LEAD_TIME,
361: NVL(MTL2.CUM_MANUFACTURING_LEAD_TIME, 0) CUM_MANUFACTURING_LEAD_TIME,
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