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.CSF_GANTT_DATA_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 365: FROM csp_requirement_headers

361: WHERE uom_code = p_code;
362:
363: CURSOR c_parts(b_task_id NUMBER) IS
364: SELECT 'Y' required
365: FROM csp_requirement_headers
366: WHERE task_id = b_task_id;
367:
368: CURSOR c_ib(b_customer_product_id NUMBER) IS
369: SELECT serial_number

Line 1504: FROM csp_requirement_headers

1500: WHERE uom_code = p_code;
1501:
1502: CURSOR c_parts(b_task_id NUMBER) IS
1503: SELECT 'Y' required
1504: FROM csp_requirement_headers
1505: WHERE task_id = b_task_id;
1506:
1507: CURSOR c_ib(b_customer_product_id NUMBER) IS
1508: SELECT serial_number

Line 2474: FROM csp_requirement_headers

2470: WHERE uom_code = p_code;
2471:
2472: CURSOR c_parts(b_task_id NUMBER) IS
2473: SELECT 'Y' required
2474: FROM csp_requirement_headers
2475: WHERE task_id = b_task_id;
2476:
2477: CURSOR c_ib(b_customer_product_id NUMBER) IS
2478: SELECT serial_number

Line 3201: FROM csp_requirement_headers

3197: WHERE uom_code = p_code;
3198:
3199: CURSOR c_parts(b_task_id NUMBER) IS
3200: SELECT 'Y' required
3201: FROM csp_requirement_headers
3202: WHERE task_id = b_task_id;
3203:
3204: CURSOR c_ib(b_customer_product_id NUMBER) IS
3205: SELECT serial_number

Line 5337: , csp_requirement_headers cr

5333: , hz_parties pi
5334: , hz_party_sites ps
5335: , hz_locations l
5336: , csf_access_hours_b ca
5337: , csp_requirement_headers cr
5338: WHERE t.task_id = a.task_id
5339: AND tl.task_id =t.task_id
5340: AND tl.language=userenv('LANG')
5341: AND t.source_object_type_code in( 'SR','TASK')

Line 5433: , csp_requirement_headers cr

5429: , hz_locations l
5430: , csf_access_hours_b ca
5431: , jtf_task_depends jd
5432: , jtf_task_depends jdd
5433: , csp_requirement_headers cr
5434: WHERE t.task_id = a.task_id
5435: AND t.source_object_type_code in( 'SR','TASK')
5436: AND NVL(t.deleted_flag, 'N') <> 'Y'
5437: AND t.task_type_id NOT IN (20,21)

Line 5513: , csp_requirement_headers cr

5509: , jtf_task_types_b tt
5510: , jtf_task_statuses_b tsb
5511: , jtf_task_statuses_b tsa
5512: , csf_access_hours_b ca
5513: , csp_requirement_headers cr
5514: WHERE t.task_id = a.task_id
5515: AND t.source_object_type_code in( 'SR','TASK')
5516: AND NVL(t.deleted_flag, 'N') <> 'Y'
5517: AND t.task_type_id NOT IN (20,21)

Line 5588: , csp_requirement_headers cr

5584: , jtf_task_statuses_b tsa
5585: , csf_access_hours_b ca
5586: , jtf_task_depends jd
5587: , jtf_task_depends jdd
5588: , csp_requirement_headers cr
5589: WHERE t.task_id = a.task_id
5590: AND t.source_object_type_code in( 'SR','TASK')
5591: AND NVL(t.deleted_flag, 'N') <> 'Y'
5592: AND t.task_type_id NOT IN (20,21)

Line 6786: , csp_requirement_headers cr

6782: , hz_parties pi
6783: , hz_party_sites ps
6784: , hz_locations l
6785: , csf_access_hours_b ca
6786: , csp_requirement_headers cr
6787: , jtf_task_statuses_b tsa
6788: , jtf_task_statuses_b tsb
6789: WHERE cpv.sched_request_id = p_req_id
6790: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 6866: , csp_requirement_headers cr

6862: , hz_parties pi
6863: , hz_party_sites ps
6864: , hz_locations l
6865: , csf_access_hours_b ca
6866: , csp_requirement_headers cr
6867: , jtf_task_depends jd
6868: , jtf_task_depends jdd
6869: , jtf_task_statuses_b tsa
6870: , jtf_task_statuses_b tsb

Line 6938: , csp_requirement_headers cr

6934: FROM csf_plan_options_v cpv
6935: , jtf_task_assignments a
6936: , jtf_tasks_b t
6937: , csf_access_hours_b ca
6938: , csp_requirement_headers cr
6939: , jtf_task_statuses_b tsa
6940: , jtf_task_statuses_b tsb
6941: WHERE cpv.sched_request_id = p_req_id
6942: AND NVL(cpv.task_type_id, 0) NOT IN(20, 21)

Line 6993: , csp_requirement_headers cr

6989: FROM csf_plan_options_v cpv
6990: , jtf_task_assignments a
6991: , jtf_tasks_b t
6992: , csf_access_hours_b ca
6993: , csp_requirement_headers cr
6994: , jtf_task_depends jd
6995: , jtf_task_depends jdd
6996: , jtf_task_statuses_b tsa
6997: , jtf_task_statuses_b tsb

Line 7107: , csp_requirement_headers cr

7103: , hz_parties pi
7104: , hz_party_sites ps
7105: , hz_locations l
7106: , csf_access_hours_b ca
7107: , csp_requirement_headers cr
7108: WHERE t.task_id = a.task_id
7109: AND t.source_object_type_code in( 'SR','TASK')
7110: AND NVL(t.deleted_flag, 'N') <> 'Y'
7111: AND t.task_type_id NOT IN (20,21)

Line 7208: , csp_requirement_headers cr

7204: , hz_locations l
7205: , csf_access_hours_b ca
7206: , jtf_task_depends jd
7207: , jtf_task_depends jdd
7208: , csp_requirement_headers cr
7209: WHERE t.task_id = a.task_id
7210: AND t.source_object_type_code in( 'SR','TASK')
7211: AND NVL(t.deleted_flag, 'N') <> 'Y'
7212: AND t.task_type_id NOT IN (20,21)

Line 7294: , csp_requirement_headers cr

7290: , jtf_task_types_b tt
7291: , jtf_task_statuses_b tsb
7292: , jtf_task_statuses_b tsa
7293: , csf_access_hours_b ca
7294: , csp_requirement_headers cr
7295: WHERE t.task_id = a.task_id
7296: AND t.source_object_type_code in( 'SR','TASK')
7297: AND NVL(t.deleted_flag, 'N') <> 'Y'
7298: AND t.task_type_id NOT IN (20,21)

Line 7374: , csp_requirement_headers cr

7370: , jtf_task_statuses_b tsa
7371: , csf_access_hours_b ca
7372: , jtf_task_depends jd
7373: , jtf_task_depends jdd
7374: , csp_requirement_headers cr
7375: WHERE t.task_id = a.task_id
7376: AND t.source_object_type_code in( 'SR','TASK')
7377: AND NVL(t.deleted_flag, 'N') <> 'Y'
7378: AND t.task_type_id NOT IN (20,21)