APPS.CSP_PARTS_REQUIREMENT dependencies on JTF_TASKS_B

Line 1221: FROM jtf_Tasks_b

1217: IF (l_header_rec.incident_id IS NULL AND l_header_rec.task_id IS NOT NULL) THEN
1218: BEGIN
1219: SELECT source_object_id
1220: INTO l_header_rec.incident_id
1221: FROM jtf_Tasks_b
1222: where task_id = l_header_rec.task_id;
1223: EXCEPTION
1224: when no_data_found then
1225: null;

Line 1692: FROM jtf_tasks_b

1688: IF (l_header_rec.task_id IS NOT NULL) THEN
1689: BEGIN
1690: SELECT source_object_id
1691: INTO l_header_rec.incident_id
1692: FROM jtf_tasks_b
1693: WHERE task_id = l_header_rec.task_id;
1694: EXCEPTION
1695: WHEN NO_DATA_FOUND THEN
1696:

Line 2766: jtf_tasks_b jtb,

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
2770: AND csp.resource_type = jta.resource_type_code

Line 4183: jtf_tasks_b jtb,

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,
4187: jtf_task_assignments jta

Line 4213: jtf_tasks_b jtb,

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,
4217: jtf_task_assignments jta

Line 4238: jtf_tasks_b jtb,

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
4242: AND csp.resource_type = jta.resource_type_code