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

Line 32: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,

28: l_service_request_date date;
29:
30: Cursor get_service_request_date IS
31: select nvl(incident_occurred_date,incident_date)
32: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
33: csf_debrief_headers cdh
34: where jta.task_assignment_id = cdh.task_assignment_id
35: and jtb.task_id = jta.task_id
36: and cia.incident_id = jtb.source_object_id

Line 180: jtf_task_assignments_v jta

176:
177: cursor c_source_object_type_code (p_task_assignment_id number) is
178: select jtv.source_object_type_code
179: from jtf_tasks_vl jtv,
180: jtf_task_assignments_v jta
181: where jta.task_assignment_id = p_task_assignment_id
182: and jta.task_id = jtv.task_id;
183:
184: cursor c_task_assgin_object_version is

Line 186: from jtf_task_assignments jta

182: and jta.task_id = jtv.task_id;
183:
184: cursor c_task_assgin_object_version is
185: select jta.object_version_number, jta.resource_type_code, jta.resource_id
186: from jtf_task_assignments jta
187: where jta.task_assignment_id = p_debrief_rec.TASK_ASSIGNMENT_ID;
188:
189: BEGIN
190:

Line 536: from jtf_task_assignments jta

532: cursor c_task_assgin_object_version is
533: select jta.object_version_number,
534: jta.resource_type_code,
535: jta.resource_id
536: from jtf_task_assignments jta
537: where jta.task_assignment_id = p_debrief_rec.TASK_ASSIGNMENT_ID;
538:
539: BEGIN
540:

Line 755: from JTF_TASK_ASSIGNMENTS

751: IS
752: l_api_name varchar2(30) := 'Create Debrief' ;
753: cursor c is
754: select 1
755: from JTF_TASK_ASSIGNMENTS
756: where TASK_ASSIGNMENT_ID=P_TASK_ASSIGNMENT_ID;
757:
758: l_dummy number;
759: BEGIN

Line 1002: jtf_task_assignments jta,

998: nvl(completed_flag,'N'),
999: nvl(closed_flag,'N'),
1000: nvl(cancelled_flag,'N'))
1001: from jtf_task_statuses_b jtsb,
1002: jtf_task_assignments jta,
1003: csf_debrief_headers cdh
1004: where cdh.debrief_header_id = p_debrief_header_id
1005: and jta.task_assignment_id = cdh.task_assignment_id
1006: and jtsb.task_status_id = jta.assignment_status_id;

Line 1527: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh

1523: SELECT jta.resource_type_code,
1524: jta.resource_id
1525: INTO l_resource_type,
1526: l_resource_id
1527: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh
1528: WHERE jta.task_Assignment_id = cdh.task_assignment_id
1529: AND cdh.debrief_header_id = p_debrief_line_rec.DEBRIEF_HEADER_ID;
1530: EXCEPTION
1531: when no_data_found then

Line 1572: jtf_task_assignments jta,

1568: into z_resource_id,
1569: z_location
1570: from csf_debrief_lines cdl,
1571: csf_debrief_headers csf,
1572: jtf_task_assignments jta,
1573: jtf_tasks_b jtb,
1574: hz_party_sites p,
1575: hz_locations loc
1576: where csf.debrief_header_id = p_debrief_line_rec.debrief_header_id

Line 1585: from jtf_task_assignments

1581: and jtb.address_id = p.party_site_id
1582: and p.location_id = loc.location_id;
1583: select max(actual_start_date)
1584: into z_start_date
1585: from jtf_task_assignments
1586: where resource_id = z_resource_id;
1587:
1588: IF p_debrief_line_rec.labor_start_date > z_start_date then
1589: select object_version_number

Line 1640: from jtf_task_assignments jta,

1636: jta.task_id
1637: into l_task_assignment_id,
1638: l_object_version_number,
1639: l_task_id
1640: from jtf_task_assignments jta,
1641: csf_debrief_headers csf
1642: where csf.task_assignment_id = jta.task_assignment_id
1643: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
1644:

Line 1817: jtf_task_assignments jta,

1813: nvl(completed_flag,'N'),
1814: nvl(closed_flag,'N'),
1815: nvl(cancelled_flag,'N'))
1816: from jtf_task_statuses_b jtsb,
1817: jtf_task_assignments jta,
1818: csf_debrief_headers cdh
1819: where cdh.debrief_header_id = p_debrief_header_id
1820: and jta.task_assignment_id = cdh.task_assignment_id
1821: and jtsb.task_status_id = jta.assignment_status_id;

Line 2220: jtf_task_assignments jta,

2216: into z_resource_id,
2217: z_location
2218: from csf_debrief_lines cdl,
2219: csf_debrief_headers csf,
2220: jtf_task_assignments jta,
2221: jtf_tasks_b jtb,
2222: hz_party_sites p,
2223: hz_locations loc
2224: where csf.debrief_header_id = l_debrief_line_rec.debrief_header_id

Line 2234: from jtf_task_assignments

2230: and p.location_id = loc.location_id;
2231:
2232: select max(actual_start_date)
2233: into z_start_date
2234: from jtf_task_assignments
2235: where resource_id = z_resource_id;
2236:
2237: IF p_debrief_line_rec.labor_start_date > z_start_date then
2238: select object_version_number

Line 2290: from jtf_task_assignments jta,

2286: jta.task_id
2287: into l_task_assignment_id,
2288: l_object_version_number,
2289: l_task_id
2290: from jtf_task_assignments jta,
2291: csf_debrief_headers csf
2292: where csf.task_assignment_id = jta.task_assignment_id
2293: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
2294:

Line 2806: from jtf_task_assignments jta,

2802: into l_task_id,
2803: l_party_id,
2804: l_cust_account_id,
2805: l_resource_id
2806: from jtf_task_assignments jta,
2807: jtf_tasks_b jtb
2808: where jta.task_id = jtb.task_id
2809: and jta.task_assignment_id = P_task_assignment_id;
2810:

Line 2958: from csf_debrief_headers cdh,jtf_task_assignments jta

2954: and cdl.labor_end_date is not null;
2955:
2956: cursor c_Debrief_header_for_cleanup is
2957: select cdh.debrief_header_id
2958: from csf_debrief_headers cdh,jtf_task_assignments jta
2959: where cdh.task_assignment_id = jta.task_assignment_id
2960: and jta.task_assignment_id =p_task_assignment_id
2961: and (jta.actual_start_date is not null
2962: or jta.actual_end_date is not null

Line 3019: from jtf_task_assignments jta,

3015: nvl(p_end_date,fnd_api.g_miss_date)),
3016: jta.object_version_number,
3017: jta.resource_type_code,
3018: jta.resource_id
3019: from jtf_task_assignments jta,
3020: csf_debrief_headers cdh
3021: where debrief_header_id = p_debrief_header_id
3022: and jta.task_assignment_id = cdh.task_assignment_id
3023: and (nvl(actual_start_date,p_start_date) >=

Line 3183: jtf_task_assignments jta ,

3179: cdl.labor_end_date,
3180: jtb.task_number
3181: from csf_debrief_lines cdl,
3182: csf_debrief_headers cdh,
3183: jtf_task_assignments jta ,
3184: jtf_tasks_b jtb
3185: where cdh.debrief_header_id = cdl.debrief_header_id
3186: and jta.task_assignment_id = cdh.task_assignment_id
3187: and cdl.labor_start_date is not null

Line 3229: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3225: l_task_assignment_id number := null;
3226: l_debrief_header_id number := null;
3227: begin
3228: x_return_status := FND_API.G_RET_STS_SUCCESS;
3229: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3230: select debrief_header_id
3231: into l_debrief_header_id
3232: from csf_debrief_headers
3233: where task_assignment_id = l_task_assignment_id;

Line 3305: from jtf_task_assignments jta,

3301:
3302: cursor c_task_assgin_object_version is
3303: select task_id, jta.task_assignment_id, jta.object_version_number,
3304: jta.resource_type_code, jta.resource_id
3305: from jtf_task_assignments jta,
3306: csf_debrief_headers cdh
3307: where jta.task_assignment_id = cdh.task_assignment_id
3308: and cdh.debrief_header_id = p_debrief_header_id;
3309:

Line 3348: jtf_task_assignments jta,

3344: max(labor_end_date),
3345: min(debrief_line_id)
3346: from csf_debrief_lab_lines_v cdl,
3347: csf_debrief_headers cdh,
3348: jtf_task_assignments jta,
3349: cs_transaction_types ctt
3350: where jta.task_id = l_task_id
3351: and jta.task_assignment_id = cdh.task_assignment_id
3352: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3362: jtf_task_assignments jta,

3358: max(labor_end_date),
3359: min(debrief_line_id)
3360: from csf_debrief_lab_lines_v cdl,
3361: csf_debrief_headers cdh,
3362: jtf_task_assignments jta,
3363: cs_transaction_types ctt
3364: where jta.task_id = l_task_id
3365: and jta.task_assignment_id = cdh.task_assignment_id
3366: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3377: jtf_task_assignments jta,

3373: select min(labor_start_date),
3374: max(labor_end_date)
3375: from csf_debrief_lines cdl,
3376: csf_debrief_headers cdh,
3377: jtf_task_assignments jta,
3378: jtf_tasks_b jtb,
3379: cs_transaction_types ctt
3380: where jtb.parent_task_id = l_parent_task_id
3381: and jta.task_id = jtb.task_id

Line 3392: jtf_task_assignments jta,

3388: select min(labor_start_date),
3389: max(labor_end_date)
3390: from csf_debrief_lines cdl,
3391: csf_debrief_headers cdh,
3392: jtf_task_assignments jta,
3393: jtf_tasks_b jtb,
3394: cs_transaction_types ctt
3395: where jtb.parent_task_id = l_parent_task_id
3396: and jta.task_id = jtb.task_id

Line 3411: from jtf_task_assignments jta,

3407: -- bug # 6960521
3408: -- substract RETURN type line's duration from total
3409: cursor c_task_assignment_dur is
3410: select uom_code, quantity
3411: from jtf_task_assignments jta,
3412: csf_debrief_headers cdh,
3413: csf_debrief_lines cdl,
3414: cs_transaction_types ctt
3415: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3430: from jtf_task_assignments jta,

3426: or
3427: cdl.inventory_item_id is null)
3428: union all
3429: select uom_code, (quantity * -1)
3430: from jtf_task_assignments jta,
3431: csf_debrief_headers cdh,
3432: csf_debrief_lines cdl,
3433: cs_transaction_types ctt
3434: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3452: jtf_task_assignments jta,

3448: cursor c_task_dur is
3449: select uom_code, quantity
3450: from csf_debrief_lines cdl,
3451: csf_debrief_headers cdh,
3452: jtf_task_assignments jta,
3453: jtf_tasks_b jtb,
3454: cs_transaction_types ctt
3455: where cdh.debrief_header_id = cdl.debrief_header_id
3456: and jta.task_assignment_id = cdh.task_assignment_id

Line 3473: jtf_task_assignments jta,

3469: union all
3470: select uom_code, (quantity * -1)
3471: from csf_debrief_lines cdl,
3472: csf_debrief_headers cdh,
3473: jtf_task_assignments jta,
3474: jtf_tasks_b jtb,
3475: cs_transaction_types ctt
3476: where cdh.debrief_header_id = cdl.debrief_header_id
3477: and jta.task_assignment_id = cdh.task_assignment_id

Line 3495: jtf_task_assignments jta,

3491: cursor c_parent_task_dur is
3492: select uom_code, quantity
3493: from csf_debrief_lines cdl,
3494: csf_debrief_headers cdh,
3495: jtf_task_assignments jta,
3496: jtf_tasks_b jtb,
3497: cs_transaction_types ctt
3498: where cdh.debrief_header_id = cdl.debrief_header_id
3499: and jta.task_assignment_id = cdh.task_assignment_id

Line 3516: jtf_task_assignments jta,

3512: union all
3513: select uom_code, (quantity * -1)
3514: from csf_debrief_lines cdl,
3515: csf_debrief_headers cdh,
3516: jtf_task_assignments jta,
3517: jtf_tasks_b jtb,
3518: cs_transaction_types ctt
3519: where cdh.debrief_header_id = cdl.debrief_header_id
3520: and jta.task_assignment_id = cdh.task_assignment_id

Line 3813: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb

3809: l_service_request_date date;
3810:
3811: Cursor get_service_request_date IS
3812: select nvl(incident_occurred_date,incident_date)
3813: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb
3814: where jta.task_assignment_id = p_task_assignment_id
3815: and jtb.task_id = jta.task_id
3816: and cia.incident_id = jtb.source_object_id
3817: and jtb.source_object_type_code = 'SR';