APPS.CSP_PARTS_REQUIREMENT dependencies on CS_INCIDENTS_ALL_B

Line 1173: from jtf_party_locations_v jpl, cs_incidents_all_b cia

1169:
1170:
1171: cursor get_party_details( c_incident_id number,c_location_id number) is
1172: select jpl.party_site_id, cia.customer_id, cia.account_id, cia.org_id
1173: from jtf_party_locations_v jpl, cs_incidents_all_b cia
1174: where jpl.party_id = cia.customer_id
1175: and cia.incident_id = c_incident_id
1176: and jpl.location_id = c_location_id;
1177:

Line 1583: from jtf_party_locations_v jpl, cs_incidents_all_b cia

1579: l_org_id number;
1580:
1581: cursor get_party_details( c_incident_id number,c_location_id number) is
1582: select jpl.party_site_id, cia.customer_id, cia.account_id, cia.org_id
1583: from jtf_party_locations_v jpl, cs_incidents_all_b cia
1584: where jpl.party_id = cia.customer_id
1585: and cia.incident_id = c_incident_id
1586: and jpl.location_id = c_location_id;
1587:

Line 2765: cs_incidents_all_b cs,

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
2769: AND csp.resource_id = jta.resource_id

Line 4182: cs_incidents_all_b cia,

4178: hcas.cust_account_id as custAccountId,
4179: jpl.party_id as customerId,
4180: cia.org_id
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,

Line 4212: cs_incidents_all_b cia,

4208: hcas.cust_account_id as custAccountId,
4209: jpl.party_id as customerId,
4210: cia.org_id
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,

Line 4237: cs_incidents_all_b cs,

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
4241: AND csp.resource_id = jta.resource_id