934: CSLLC1.ORGANIZATION_ID
935: FROM CST_SC_LOW_LEVEL_CODES CSLLC1
936: WHERE CSLLC1.ROLLUP_ID = p_rollup_id);
937:
938: -- SCAPI: need to delete CST_SC_LISTS also
939: l_stmt_num := 50;
940:
941: DELETE CST_SC_LISTS CSL
942: WHERE CSL.ROLLUP_ID IN (
937:
938: -- SCAPI: need to delete CST_SC_LISTS also
939: l_stmt_num := 50;
940:
941: DELETE CST_SC_LISTS CSL
942: WHERE CSL.ROLLUP_ID IN (
943: SELECT CSRH.ROLLUP_ID
944: FROM CST_SC_ROLLUP_HISTORY CSRH
945: WHERE CSRH.ROLLUP_ID <> p_rollup_id
948: CSL.ORGANIZATION_ID)
949: IN
950: (SELECT CSL1.INVENTORY_ITEM_ID,
951: CSL1.ORGANIZATION_ID
952: FROM CST_SC_LISTS CSL1,
953: CST_SC_LOW_LEVEL_CODES CSLLC
954: WHERE CSL1.ROLLUP_ID = p_rollup_id
955: AND CSL1.ROLLUP_ID = CSLLC.ROLLUP_ID
956: AND CSL1.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID