APPS.CSTPSCEX dependencies on CST_ITEM_COSTS

Line 736: cst_item_costs CIC

732: decode( CIC.inventory_asset_flag, 2, 2,
733: decode( CIC.based_on_rollup_flag, 2, 2, 1 ) ) new_ext_cost_flag
734: from
735: cst_sc_bom_structures CSBS,
736: cst_item_costs CIC
737: where
738: CSBS.rollup_id = i_rollup_id and
739: CSBS.assembly_item_id = -1 and
740: CIC.inventory_item_id = CSBS.component_item_id and

Line 777: cst_item_costs CIC,

773: 6, 1, 2 ) phantom_flag,
774: decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),nvl(bp.bom_delete_status_code,' '),2,1) active_flag
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

Line 813: cst_item_costs CIC,

809: 6, 1, 2 ) phantom_flag,
810: decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),nvl(bp.bom_delete_status_code,' '),2,1) active_flag
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

Line 899: from cst_item_costs cic1,

895: l_stmt_num := 35;
896:
897: select ext_qty_stack(comp.bom_level)* (cic1.lot_size/cic2.lot_size)
898: into ext_qty_stack( comp.bom_level )
899: from cst_item_costs cic1,
900: cst_item_costs cic2,
901: cst_sc_bom_structures csbs
902: where csbs.rowid = comp.rowid
903: and CIC1.inventory_item_id (+) = CSBS.assembly_item_id

Line 900: cst_item_costs cic2,

896:
897: select ext_qty_stack(comp.bom_level)* (cic1.lot_size/cic2.lot_size)
898: into ext_qty_stack( comp.bom_level )
899: from cst_item_costs cic1,
900: cst_item_costs cic2,
901: cst_sc_bom_structures csbs
902: where csbs.rowid = comp.rowid
903: and CIC1.inventory_item_id (+) = CSBS.assembly_item_id
904: and CIC1.organization_id (+) = CSBS.assembly_organization_id