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 1240: FROM CSP_RS_SHIP_TO_ADDRESSES_V

1236: AND DEFAULT_CODE = 'IN' ;
1237:
1238: CURSOR csp_ship_to_location(c_resource_id number, c_resource_type varchar2) IS
1239: SELECT SHIP_TO_LOCATION_ID
1240: FROM CSP_RS_SHIP_TO_ADDRESSES_V
1241: WHERE RESOURCE_ID = c_resource_id
1242: AND RESOURCE_TYPE = c_resource_type
1243: AND PRIMARY_FLAG = 'Y';
1244:

Line 2888: FROM CSP_RS_SHIP_TO_ADDRESSES_V

2884:
2885: CURSOR C2(c_resource_type varchar2, c_resource_id NUMBER)
2886: IS
2887: SELECT TIMEZONE_ID
2888: FROM CSP_RS_SHIP_TO_ADDRESSES_V
2889: WHERE PRIMARY_FLAG ='Y'
2890: AND resource_id = c_resource_id
2891: AND resource_type = c_resource_type;
2892:

Line 3717: FROM CSP_RS_SHIP_TO_ADDRESSES_V

3713:
3714: CURSOR C1(c_resource_type varchar2, c_resource_id NUMBER)
3715: IS
3716: /*SELECT TIMEZONE_ID
3717: FROM CSP_RS_SHIP_TO_ADDRESSES_V
3718: WHERE PRIMARY_FLAG ='Y'
3719: AND resource_id = c_resource_id
3720: AND resource_type = c_resource_type;*/
3721: SELECT hzl.time_zone TIMEZONE_ID