DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_RS_SHIP_TO_ADDRESSES_ALL_V

Line 2763: FROM csp_rs_ship_to_addresses_all_v csp,

2759: WHERE task_assignment_id = l_Task_Assignment_id;
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

Line 4235: FROM csp_rs_ship_to_addresses_all_v csp,

4231: AND jpl.primary_flag = 'Y';
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