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_ALL_V

Line 1244: FROM CSP_RS_SHIP_TO_ADDRESSES_ALL_V

1240: AND DEFAULT_CODE = 'IN' ;
1241:
1242: CURSOR csp_ship_to_location(c_resource_id number, c_resource_type varchar2) IS
1243: SELECT SHIP_TO_LOCATION_ID
1244: FROM CSP_RS_SHIP_TO_ADDRESSES_ALL_V
1245: WHERE RESOURCE_ID = c_resource_id
1246: AND RESOURCE_TYPE = c_resource_type
1247: AND PRIMARY_FLAG = 'Y'
1248: AND status = 'A'

Line 3631: from csp_rs_ship_to_addresses_all_v

3627:
3628: cursor c_ship_to(p_resource_type varchar2,p_resource_id number) is
3629: select inv_loc_id,
3630: site_loc_id
3631: from csp_rs_ship_to_addresses_all_v
3632: where resource_type = p_resource_type
3633: and resource_id = p_resource_id
3634: and primary_flag = 'Y';
3635:

Line 3821: from csp_rs_ship_to_addresses_all_v crstaav,

3817: p_resource_id number) is
3818: select crstaav.ship_to_location_id,
3819: crstaav.site_loc_id,
3820: hcasa.org_id
3821: from csp_rs_ship_to_addresses_all_v crstaav,
3822: hz_cust_acct_sites_all hcasa
3823: where crstaav.resource_type = p_resource_type
3824: and crstaav.resource_id = p_resource_id
3825: and crstaav.primary_flag = 'Y'