APPS.CSTPSCEX dependencies on BOM_INVENTORY_COMPONENTS

Line 551: bom_inventory_components BIC

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
555: BOM.organization_id = CSBE.component_organization_id and

Line 609: FROM BOM_INVENTORY_COMPONENTS BIC2

605: i_inc_unimpl_ecn = 1 AND
606: BIC.EFFECTIVITY_DATE =
607: (
608: SELECT MAX(EFFECTIVITY_DATE)
609: FROM BOM_INVENTORY_COMPONENTS BIC2
610: WHERE
611: BIC2.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID AND
612: BIC2.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID AND
613: (

Line 781: bom_inventory_components BIC,

777: from
778: cst_sc_bom_structures CSBS,
779: cst_item_costs CIC,
780: mtl_system_items MSI,
781: bom_inventory_components BIC,
782: bom_parameters bp /* Bug 4547027 */
783: where
784: CSBS.rollup_id = i_rollup_id and
785: CSBS.assembly_item_id = -1 and

Line 817: bom_inventory_components BIC,

813: from
814: cst_sc_bom_structures CSBS,
815: cst_item_costs CIC,
816: mtl_system_items MSI,
817: bom_inventory_components BIC,
818: bom_parameters bp /* Bug 4547027 */
819: where
820: CSBS.rollup_id = i_rollup_id and
821: CSBS.assembly_item_id <> -1 and