APPS.CSTPSCEX dependencies on CST_SC_BOM_STRUCTURES

Line 737: cst_sc_bom_structures CSBS,

733: CSBS.rowid,
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

Line 778: cst_sc_bom_structures CSBS,

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: 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 */

Line 814: cst_sc_bom_structures CSBS,

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: 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 */

Line 865: update cst_sc_bom_structures CSBS

861: -- set up the top level extend_cost_flag
862: l_stmt_num := 10;
863:
864: FOR assm in assm_cursor LOOP
865: update cst_sc_bom_structures CSBS
866: set CSBS.extend_cost_flag = assm.new_ext_cost_flag
867: where CSBS.rowid = assm.rowid;
868: END LOOP;
869:

Line 917: cst_sc_bom_structures csbs

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
921: and CIC.cost_type_id (+) = i_cost_type_id;

Line 933: update cst_sc_bom_structures CSBS

929: END IF;
930:
931: l_stmt_num := 50;
932:
933: update cst_sc_bom_structures CSBS
934: set
935: CSBS.component_quantity = comp.component_quantity,
936: CSBS.extended_quantity = ext_qty_stack(comp.bom_level),
937: CSBS.include_in_cost_rollup = comp.include_in_cost_rollup,

Line 1002: delete cst_sc_bom_structures

998: END IF;
999:
1000:
1001: -- SCAPI: delete previous data;
1002: delete cst_sc_bom_structures
1003: where rollup_id in (i_rollup_id, -1*i_rollup_id);
1004:
1005:
1006: l_stmt_num := 10;

Line 1012: insert into cst_sc_bom_structures

1008: BEGIN
1009:
1010: l_stmt_num := 20;
1011:
1012: insert into cst_sc_bom_structures
1013: (
1014: ROLLUP_ID,
1015: TOP_INVENTORY_ITEM_ID,
1016: TOP_ORGANIZATION_ID,

Line 1086: insert into cst_sc_bom_structures

1082:
1083: l_err_code := SQLCODE;
1084: l_err_mesg := substrb( SQLERRM, 1, 100 );
1085:
1086: insert into cst_sc_bom_structures
1087: (
1088: ROLLUP_ID,
1089: TOP_INVENTORY_ITEM_ID,
1090: TOP_ORGANIZATION_ID,

Line 1155: update cst_sc_bom_structures CSBS

1151:
1152: l_stmt_num := 30;
1153:
1154: -- update the item revision column
1155: update cst_sc_bom_structures CSBS
1156: set CSBS.component_revision =
1157: (
1158: select
1159: substr( max( to_char( MIR.effectivity_date, 'YYYY/MM/DD HH24:MI:SS' ) ||

Line 1190: insert into cst_sc_bom_structures

1186:
1187: -- SCAPI: insert data for consolidated report using negative rollup_id
1188: l_stmt_num := 50;
1189: IF i_report_type_type = 2 THEN
1190: insert into cst_sc_bom_structures
1191: (
1192: ROLLUP_ID,
1193: TOP_INVENTORY_ITEM_ID,
1194: TOP_ORGANIZATION_ID,

Line 1247: cst_sc_bom_structures CSBS

1243: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
1244: i_prog_id, -- PROGRAM_ID
1245: sysdate -- PROGRAM_UPDATE_DATE
1246: from
1247: cst_sc_bom_structures CSBS
1248: where
1249: rollup_id = i_rollup_id
1250: group by
1251: CSBS.top_inventory_item_id,