APPS.CSTPSCEX dependencies on BOM_INVENTORY_COMPONENTS

Line 550: bom_inventory_components BIC

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

Line 608: FROM BOM_INVENTORY_COMPONENTS BIC2

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

Line 779: bom_inventory_components BIC,

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

Line 815: bom_inventory_components BIC,

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