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_PARTY_SITE_USES

Line 1489: hz_party_site_uses hpsu,

1485: cursor get_bill_to_for_sr (p_rqmt_header_id NUMBER) IS
1486: SELECT site_use.site_use_id, cia.ship_to_contact_id, cia.bill_to_contact_id
1487: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1488: HZ_CUST_SITE_USES_ALL site_use,
1489: hz_party_site_uses hpsu,
1490: cs_incidents_all cia,
1491: csp_requirement_headers_v req
1492: WHERE req.requirement_header_id = p_rqmt_header_id
1493: and cia.incident_id = req.incident_id

Line 1525: hz_party_site_uses hpsu,

1521: cursor c_sr_src_bill_to (v_rqmt_header_id NUMBER, v_src_org_id number) is
1522: SELECT site_use.site_use_id
1523: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1524: HZ_CUST_SITE_USES_ALL site_use,
1525: hz_party_site_uses hpsu,
1526: cs_incidents_all cia,
1527: csp_requirement_headers_v req
1528: WHERE req.requirement_header_id = v_rqmt_header_id
1529: and req.address_type in ('C', 'T') -- bug # 14743823