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_LOW_LEVEL_CODES

Line 876: CST_SC_LOW_LEVEL_CODES CSLLC

872: IN
873: (SELECT CSBS1.COMPONENT_ITEM_ID,
874: CSBS1.COMPONENT_ORGANIZATION_ID
875: FROM CST_SC_BOM_STRUCTURES CSBS1,
876: CST_SC_LOW_LEVEL_CODES CSLLC
877: WHERE CSBS1.ROLLUP_ID = p_rollup_id
878: AND CSBS1.ROLLUP_ID = CSLLC.ROLLUP_ID
879: AND CSBS1.COMPONENT_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
880: AND CSBS1.COMPONENT_ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);

Line 896: CST_SC_LOW_LEVEL_CODES CSLLC

892: IN
893: (SELECT CSBE1.COMPONENT_ITEM_ID,
894: CSBE1.COMPONENT_ORGANIZATION_ID
895: FROM CST_SC_BOM_EXPLOSION CSBE1,
896: CST_SC_LOW_LEVEL_CODES CSLLC
897: WHERE CSBE1.ROLLUP_ID = p_rollup_id
898: AND CSBE1.ROLLUP_ID = CSLLC.ROLLUP_ID
899: AND CSBE1.COMPONENT_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
900: AND CSBE1.COMPONENT_ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);

Line 916: CST_SC_LOW_LEVEL_CODES CSLLC

912: IN
913: (SELECT CSSR1.INVENTORY_ITEM_ID,
914: CSSR1.ORGANIZATION_ID
915: FROM CST_SC_SOURCING_RULES CSSR1,
916: CST_SC_LOW_LEVEL_CODES CSLLC
917: WHERE CSSR1.ROLLUP_ID = p_rollup_id
918: AND CSSR1.ROLLUP_ID = CSLLC.ROLLUP_ID
919: AND CSSR1.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
920: AND CSSR1.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);

Line 924: DELETE CST_SC_LOW_LEVEL_CODES CSLLC

920: AND CSSR1.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);
921:
922: l_stmt_num := 40;
923:
924: DELETE CST_SC_LOW_LEVEL_CODES CSLLC
925: WHERE CSLLC.ROLLUP_ID IN (
926: SELECT CSRH.ROLLUP_ID
927: FROM CST_SC_ROLLUP_HISTORY CSRH
928: WHERE CSRH.ROLLUP_ID <> p_rollup_id

Line 935: FROM CST_SC_LOW_LEVEL_CODES CSLLC1

931: CSLLC.ORGANIZATION_ID)
932: IN
933: (SELECT CSLLC1.INVENTORY_ITEM_ID,
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;

Line 953: CST_SC_LOW_LEVEL_CODES CSLLC

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
957: AND CSL1.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);