DBA Data[Home] [Help]

APPS.CSTPSCEX dependencies on BOM_BILL_OF_MATERIALS

Line 550: bom_bill_of_materials BOM,

546: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
547: i_prog_id, -- PROGRAM_ID
548: sysdate -- PROGRAM_UPDATE_DATE
549: from
550: bom_bill_of_materials BOM,
551: bom_inventory_components BIC
552: where
553: BOM.common_bill_sequence_id = BIC.bill_sequence_id and
554: BOM.assembly_item_id = CSBE.component_item_id and

Line 582: FROM BOM_BILL_OF_MATERIALS BOM2

578: BOM.ALTERNATE_BOM_DESIGNATOR IS NULL AND
579: NOT EXISTS
580: (
581: SELECT 'X'
582: FROM BOM_BILL_OF_MATERIALS BOM2
583: WHERE BOM2.ORGANIZATION_ID = BOM.ORGANIZATION_ID AND
584: BOM2.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID AND
585: BOM2.ALTERNATE_BOM_DESIGNATOR = i_alt_bom_desg AND
586: BOM2.assembly_type =