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_REQUIREMENT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2764: hz_cust_acct_sites_All hz,

2760:
2761: CURSOR get_resource_location IS
2762: SELECT csp.ship_to_location_id
2763: FROM csp_rs_ship_to_addresses_all_v csp,
2764: hz_cust_acct_sites_All hz,
2765: cs_incidents_all_b cs,
2766: jtf_tasks_b jtb,
2767: jtf_task_assignments jta
2768: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id

Line 4185: hz_cust_acct_sites_all hcas,

4181: FROM jtf_party_locations_v jpl,
4182: cs_incidents_all_b cia,
4183: jtf_tasks_b jtb,
4184: hz_cust_site_uses_all hcsu,
4185: hz_cust_acct_sites_all hcas,
4186: po_location_associations_all pa,
4187: jtf_task_assignments jta
4188: WHERE jta.task_assignment_id = l_Task_Assignment_id
4189: AND jtb.task_id = jta.task_id

Line 4215: hz_cust_acct_sites_all hcas,

4211: FROM jtf_party_locations_v jpl,
4212: cs_incidents_all_b cia,
4213: jtf_tasks_b jtb,
4214: hz_cust_site_uses_all hcsu,
4215: hz_cust_acct_sites_all hcas,
4216: po_location_associations_all pa,
4217: jtf_task_assignments jta
4218: WHERE jta.task_assignment_id = l_Task_Assignment_id
4219: AND jtb.task_id = jta.task_id

Line 4236: hz_cust_acct_sites_All hz,

4232:
4233: CURSOR get_resource_location IS
4234: SELECT csp.ship_to_location_id
4235: FROM csp_rs_ship_to_addresses_all_v csp,
4236: hz_cust_acct_sites_All hz,
4237: cs_incidents_all_b cs,
4238: jtf_tasks_b jtb,
4239: jtf_task_assignments jta
4240: WHERE csp.cust_acct_site_id = hz.cust_acct_site_id