[Home] [Help]
26: ** Delete process org/item combinations, if any
27: */
28: l_stmt_num := 5;
29:
30: delete cst_sc_lists csl
31: where exists (select 'process org'
32: from mtl_parameters mp
33: where mp.organization_id = csl.organization_id
34: and NVL(mp.process_enabled_flag, 'N') = 'Y')
79: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
80: i_prog_id, -- PROGRAM_ID
81: sysdate -- PROGRAM_UPDATE_DATE
82: from
83: cst_sc_lists CSL
84: where
85: CSL.rollup_id = i_rollup_id;
86:
87:
1344:
1345: l_low_level_code := LOWEST_LEVEL_CODE;
1346:
1347: /* Supply chain enhancement: if not a full rollup, only assign low level codes
1348: for items that exist in cst_sc_lists */
1349:
1350: IF i_explosion_levels is not null THEN
1351:
1352: l_stmt_num := 5;
1356: where
1357: CSBE.rollup_id = i_rollup_id and
1358: CSBE.deleted_flag = 'N' and
1359: not exists ( select 'Item in List'
1360: from cst_sc_lists CSL
1361: where CSL.rollup_id = i_rollup_id
1362: and CSL.inventory_item_id = CSBE.component_item_id
1363: and CSL.organization_id = CSBE.component_organization_id );
1364: