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_SCH_INT_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 258: from jtf_task_assignments

254: and crl.requirement_header_id = crh.requirement_header_id;
255:
256: cursor get_asgn_id is
257: select task_assignment_id
258: from jtf_task_assignments
259: where task_id = p_task_id;
260:
261: l_partial_line number;
262: l_fl_rcvd_multi_source number;

Line 1231: jtf_task_assignments jta

1227:
1228: cursor c_accepted_flag is
1229: select nvl(jtsv.accepted_flag,'N')
1230: from jtf_task_statuses_vl jtsv,
1231: jtf_task_assignments jta
1232: where jta.task_assignment_id = p_task_assignment_id
1233: and jtsv.task_status_id = jta.assignment_status_id;
1234:
1235: CURSOR csp_resource_org(c_resource_id number, c_resource_type varchar2) IS

Line 1335: from jtf_task_assignments

1331: l_need_by_date date := null;
1332:
1333: cursor get_asgn_id is
1334: select task_assignment_id
1335: from jtf_task_assignments
1336: where task_id = p_task_id;
1337:
1338: l_task_asgn_id number;
1339: l_fl_rcvd_lines number;

Line 2915: FROM JTF_TASK_ASSIGNMENTS

2911:
2912:
2913: CURSOR get_resource(c_task_assignment_id NUMBER) IS
2914: SELECT RESOURCE_ID,RESOURCE_TYPE_CODE
2915: FROM JTF_TASK_ASSIGNMENTS
2916: WHERE TASK_ASSIGNMENT_ID=c_task_assignment_id;
2917:
2918: CURSOR csp_resource_org(c_resource_id number, c_resource_type varchar2) IS
2919: SELECT ORGANIZATION_ID, SUBINVENTORY_CODE