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.CSP_SCH_INT_PVT dependencies on CSP_RS_SHIP_TO_ADDRESSES_V

Line 2927: FROM CSP_RS_SHIP_TO_ADDRESSES_V

2923: AND DEFAULT_CODE = 'IN' ;
2924:
2925: CURSOR csp_ship_to_location(c_resource_id number, c_resource_type varchar2) IS
2926: SELECT SHIP_TO_LOCATION_ID
2927: FROM CSP_RS_SHIP_TO_ADDRESSES_V
2928: WHERE RESOURCE_ID = c_resource_id
2929: AND RESOURCE_TYPE = c_resource_type
2930: AND PRIMARY_FLAG = 'Y';
2931:

Line 5319: FROM CSP_RS_SHIP_TO_ADDRESSES_V

5315:
5316: CURSOR C2(c_resource_type varchar2, c_resource_id NUMBER)
5317: IS
5318: SELECT TIMEZONE_ID
5319: FROM CSP_RS_SHIP_TO_ADDRESSES_V
5320: WHERE PRIMARY_FLAG ='Y'
5321: AND resource_id = c_resource_id
5322: AND resource_type = c_resource_type;
5323:

Line 6150: FROM CSP_RS_SHIP_TO_ADDRESSES_V

6146:
6147: CURSOR C1(c_resource_type VARCHAR2, c_resource_id NUMBER)
6148: IS
6149: /*SELECT TIMEZONE_ID
6150: FROM CSP_RS_SHIP_TO_ADDRESSES_V
6151: WHERE PRIMARY_FLAG ='Y'
6152: AND resource_id = c_resource_id
6153: AND resource_type = c_resource_type;*/
6154: SELECT hzl.time_zone TIMEZONE_ID