eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPSCCM dependencies on CST_SC_LISTS

Line 938: -- SCAPI: need to delete CST_SC_LISTS also

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 (

Line 941: DELETE CST_SC_LISTS CSL

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

Line 952: FROM CST_SC_LISTS CSL1,

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