APPS.CSTPSCEX dependencies on CST_ITEM_COSTS

Line 738: cst_item_costs CIC

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

Line 779: cst_item_costs CIC,

775: 0 shrinkage_rate,
776: decode(CIC.lot_size, 0, 1, NULL, 1, CIC.lot_size) lot_size
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

Line 815: cst_item_costs CIC,

811: decode(CSBS.assembly_organization_id, CSBS.component_organization_id, nvl(CIC.shrinkage_rate, 0), 0) shrinkage_rate,
812: decode(CIC.lot_size, 0, 1, NULL, 1, CIC.lot_size) lot_size
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

Line 916: from cst_item_costs cic,

912: l_stmt_num := 40;
913: IF comp.phantom_flag = 1 THEN
914: select cic.lot_size / (comp.lot_size * comp.component_quantity)
915: into phtm_factor_stack(comp.bom_level)
916: from cst_item_costs cic,
917: cst_sc_bom_structures csbs
918: where csbs.rowid = comp.rowid
919: and CIC.inventory_item_id (+) = CSBS.component_item_id
920: and CIC.organization_id (+) = CSBS.component_organization_id