APPS.CSTPSCEX dependencies on CST_SC_BOM_STRUCTURES

Line 735: cst_sc_bom_structures CSBS,

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

Line 776: cst_sc_bom_structures CSBS,

772: decode( nvl( BIC.wip_supply_type, nvl( MSI.wip_supply_type, 1 ) ),
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 */

Line 812: cst_sc_bom_structures CSBS,

808: decode( nvl( BIC.wip_supply_type, nvl( MSI.wip_supply_type, 1 ) ),
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 */

Line 866: update cst_sc_bom_structures CSBS

862: l_stmt_num := 10;
863:
864: FOR assm in assm_cursor LOOP
865:
866: update cst_sc_bom_structures CSBS
867: set CSBS.extend_cost_flag
868: = assm.new_ext_cost_flag
869: where CSBS.rowid = assm.rowid;
870:

Line 901: cst_sc_bom_structures csbs

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
905: and CIC1.cost_type_id (+) = i_cost_type_id

Line 940: update cst_sc_bom_structures CSBS

936:
937:
938: l_stmt_num := 50;
939:
940: update cst_sc_bom_structures CSBS
941: set
942: CSBS.component_quantity = comp.component_quantity,
943: CSBS.extended_quantity = ext_qty_stack( comp.bom_level ),
944: CSBS.include_in_cost_rollup = comp.include_in_cost_rollup,

Line 1011: delete cst_sc_bom_structures

1007: END IF;
1008:
1009:
1010: -- SCAPI: delete previous data;
1011: delete cst_sc_bom_structures
1012: where rollup_id in (i_rollup_id, -1*i_rollup_id);
1013:
1014:
1015: l_stmt_num := 10;

Line 1021: insert into cst_sc_bom_structures

1017: BEGIN
1018:
1019: l_stmt_num := 20;
1020:
1021: insert into cst_sc_bom_structures
1022: (
1023: ROLLUP_ID,
1024: TOP_INVENTORY_ITEM_ID,
1025: TOP_ORGANIZATION_ID,

Line 1095: insert into cst_sc_bom_structures

1091:
1092: l_err_code := SQLCODE;
1093: l_err_mesg := substrb( SQLERRM, 1, 100 );
1094:
1095: insert into cst_sc_bom_structures
1096: (
1097: ROLLUP_ID,
1098: TOP_INVENTORY_ITEM_ID,
1099: TOP_ORGANIZATION_ID,

Line 1164: update cst_sc_bom_structures CSBS

1160:
1161: l_stmt_num := 30;
1162:
1163: -- update the item revision column
1164: update cst_sc_bom_structures CSBS
1165: set CSBS.component_revision =
1166: (
1167: select
1168: substr( max( to_char( MIR.effectivity_date, 'YYYY/MM/DD HH24:MI:SS' ) ||

Line 1199: insert into cst_sc_bom_structures

1195:
1196: -- SCAPI: insert data for consolidated report using negative rollup_id
1197: l_stmt_num := 50;
1198: IF i_report_type_type = 2 THEN
1199: insert into cst_sc_bom_structures
1200: (
1201: ROLLUP_ID,
1202: TOP_INVENTORY_ITEM_ID,
1203: TOP_ORGANIZATION_ID,

Line 1256: cst_sc_bom_structures CSBS

1252: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
1253: i_prog_id, -- PROGRAM_ID
1254: sysdate -- PROGRAM_UPDATE_DATE
1255: from
1256: cst_sc_bom_structures CSBS
1257: where
1258: rollup_id = i_rollup_id
1259: group by
1260: CSBS.top_inventory_item_id,