DBA Data[Home] [Help]

APPS.CSTPSCEX dependencies on BOM_BILL_OF_MATERIALS

Line 549: bom_bill_of_materials BOM,

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

Line 581: FROM BOM_BILL_OF_MATERIALS BOM2

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