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_PARTS_ORDER dependencies on HZ_CUST_SITE_USES_ALL

Line 1164: HZ_CUST_SITE_USES_ALL site_use

1160: CURSOR cust_site_cur IS
1161: SELECT pol.customer_id, pol.site_use_id, cust_acct.cust_account_id
1162: FROM PO_LOCATION_ASSOCIATIONS_ALL pol,
1163: HZ_CUST_ACCT_SITES_ALL cust_acct,
1164: HZ_CUST_SITE_USES_ALL site_use
1165: WHERE pol.location_id = l_header_rec.ship_to_location_id
1166: AND site_use.site_use_id = pol.site_use_id
1167: AND cust_acct.cust_acct_site_id = site_use.cust_acct_site_id;
1168:

Line 1219: HZ_CUST_SITE_USES_ALL site_use,

1215: -- bug # 6471559
1216: cursor get_bill_to_for_sr (p_rqmt_header_id NUMBER) IS
1217: SELECT site_use.site_use_id
1218: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1219: HZ_CUST_SITE_USES_ALL site_use,
1220: hz_party_site_uses hpsu,
1221: cs_incidents_all cia,
1222: csp_requirement_headers_v req
1223: WHERE req.requirement_header_id = p_rqmt_header_id