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 41: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,

37: l_date_val varchar2(30) := nvl(fnd_profile.value('CSF_DEBRIEF_SERVICE_DATE'),'B');
38:
39: Cursor get_service_request_date IS
40: select nvl(incident_occurred_date,incident_date)
41: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb,
42: csf_debrief_headers cdh
43: where jta.task_assignment_id = cdh.task_assignment_id
44: and jtb.task_id = jta.task_id
45: and cia.incident_id = jtb.source_object_id

Line 193: jtf_task_assignments_v jta

189:
190: cursor c_source_object_type_code (p_task_assignment_id number) is
191: select jtv.source_object_type_code
192: from jtf_tasks_vl jtv,
193: jtf_task_assignments_v jta
194: where jta.task_assignment_id = p_task_assignment_id
195: and jta.task_id = jtv.task_id;
196:
197: cursor c_task_assgin_object_version is

Line 199: from jtf_task_assignments jta

195: and jta.task_id = jtv.task_id;
196:
197: cursor c_task_assgin_object_version is
198: select jta.object_version_number, jta.resource_type_code, jta.resource_id
199: from jtf_task_assignments jta
200: where jta.task_assignment_id = p_debrief_rec.TASK_ASSIGNMENT_ID;
201:
202: BEGIN
203:

Line 549: from jtf_task_assignments jta

545: cursor c_task_assgin_object_version is
546: select jta.object_version_number,
547: jta.resource_type_code,
548: jta.resource_id
549: from jtf_task_assignments jta
550: where jta.task_assignment_id = p_debrief_rec.TASK_ASSIGNMENT_ID;
551:
552: BEGIN
553:

Line 768: from JTF_TASK_ASSIGNMENTS

764: IS
765: l_api_name varchar2(30) := 'Create Debrief' ;
766: cursor c is
767: select 1
768: from JTF_TASK_ASSIGNMENTS
769: where TASK_ASSIGNMENT_ID=P_TASK_ASSIGNMENT_ID;
770:
771: l_dummy number;
772: BEGIN

Line 1004: jtf_task_assignments jta,

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

Line 1575: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh

1571: jta.task_id
1572: INTO l_resource_type,
1573: l_resource_id,
1574: l_task_id
1575: FROM jtf_task_Assignments jta, csf_Debrief_headers cdh
1576: WHERE jta.task_Assignment_id = cdh.task_assignment_id
1577: AND cdh.debrief_header_id = p_debrief_line_rec.DEBRIEF_HEADER_ID;
1578: EXCEPTION
1579: when no_data_found then

Line 1622: jtf_task_assignments jta,

1618: into z_resource_id,
1619: z_location
1620: from csf_debrief_lines cdl,
1621: csf_debrief_headers csf,
1622: jtf_task_assignments jta,
1623: jtf_tasks_b jtb,
1624: hz_party_sites p,
1625: hz_locations loc
1626: where csf.debrief_header_id = p_debrief_line_rec.debrief_header_id

Line 1635: from jtf_task_assignments

1631: and jtb.address_id = p.party_site_id
1632: and p.location_id = loc.location_id;
1633: select max(actual_start_date)
1634: into z_start_date
1635: from jtf_task_assignments
1636: where resource_id = z_resource_id;
1637:
1638: IF p_debrief_line_rec.labor_start_date > z_start_date then
1639: select object_version_number

Line 1690: from jtf_task_assignments jta,

1686: jta.task_id
1687: into l_task_assignment_id,
1688: l_object_version_number,
1689: l_task_id
1690: from jtf_task_assignments jta,
1691: csf_debrief_headers csf
1692: where csf.task_assignment_id = jta.task_assignment_id
1693: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
1694:

Line 1870: jtf_task_assignments jta,

1866: nvl(completed_flag,'N'),
1867: nvl(closed_flag,'N'),
1868: nvl(cancelled_flag,'N'))
1869: from jtf_task_statuses_b jtsb,
1870: jtf_task_assignments jta,
1871: csf_debrief_headers cdh
1872: where cdh.debrief_header_id = p_debrief_header_id
1873: and jta.task_assignment_id = cdh.task_assignment_id
1874: and jtsb.task_status_id = jta.assignment_status_id;

Line 2287: jtf_task_assignments jta,

2283: into z_resource_id,
2284: z_location
2285: from csf_debrief_lines cdl,
2286: csf_debrief_headers csf,
2287: jtf_task_assignments jta,
2288: jtf_tasks_b jtb,
2289: hz_party_sites p,
2290: hz_locations loc
2291: where csf.debrief_header_id = l_debrief_line_rec.debrief_header_id

Line 2301: from jtf_task_assignments

2297: and p.location_id = loc.location_id;
2298:
2299: select max(actual_start_date)
2300: into z_start_date
2301: from jtf_task_assignments
2302: where resource_id = z_resource_id;
2303:
2304: IF p_debrief_line_rec.labor_start_date > z_start_date then
2305: select object_version_number

Line 2357: from jtf_task_assignments jta,

2353: jta.task_id
2354: into l_task_assignment_id,
2355: l_object_version_number,
2356: l_task_id
2357: from jtf_task_assignments jta,
2358: csf_debrief_headers csf
2359: where csf.task_assignment_id = jta.task_assignment_id
2360: and csf.debrief_header_id = p_debrief_line_rec.debrief_header_id;
2361:

Line 2874: from jtf_task_assignments jta,

2870: into l_task_id,
2871: l_party_id,
2872: l_cust_account_id,
2873: l_resource_id
2874: from jtf_task_assignments jta,
2875: jtf_tasks_b jtb
2876: where jta.task_id = jtb.task_id
2877: and jta.task_assignment_id = P_task_assignment_id;
2878:

Line 3026: from csf_debrief_headers cdh,jtf_task_assignments jta

3022: and cdl.labor_end_date is not null;
3023:
3024: cursor c_Debrief_header_for_cleanup is
3025: select cdh.debrief_header_id
3026: from csf_debrief_headers cdh,jtf_task_assignments jta
3027: where cdh.task_assignment_id = jta.task_assignment_id
3028: and jta.task_assignment_id =p_task_assignment_id
3029: and (jta.actual_start_date is not null
3030: or jta.actual_end_date is not null

Line 3087: from jtf_task_assignments jta,

3083: nvl(p_end_date,fnd_api.g_miss_date)),
3084: jta.object_version_number,
3085: jta.resource_type_code,
3086: jta.resource_id
3087: from jtf_task_assignments jta,
3088: csf_debrief_headers cdh
3089: where debrief_header_id = p_debrief_header_id
3090: and jta.task_assignment_id = cdh.task_assignment_id
3091: and (nvl(actual_start_date,p_start_date) >=

Line 3232: jtf_task_assignments jta ,

3228: cdl.labor_end_date,
3229: jtb.task_number
3230: from csf_debrief_lines cdl,
3231: csf_debrief_headers cdh,
3232: jtf_task_assignments jta ,
3233: jtf_tasks_b jtb
3234: where cdh.debrief_header_id = cdl.debrief_header_id
3235: and jta.task_assignment_id = cdh.task_assignment_id
3236: and cdl.labor_start_date is not null

Line 3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3280: l_debrief_header_id number := null;
3281: begin
3282: x_return_status := FND_API.G_RET_STS_SUCCESS;
3283: l_task_assignment_id :=
3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

Line 3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

3282: x_return_status := FND_API.G_RET_STS_SUCCESS;
3283: l_task_assignment_id :=
3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id

Line 3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id
3291: into l_debrief_header_id,l_old_resource_type,l_old_resource_id
3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl

Line 3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl

3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id
3291: into l_debrief_header_id,l_old_resource_type,l_old_resource_id
3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl
3293: where jta.task_assignment_id = l_task_assignment_id
3294: and cdl.debrief_header_id = cdh.debrief_header_id
3295: and cdh.task_assignment_id = jta.task_assignment_id
3296: and rownum = 1;

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

3313: l_task_assignment_id number := null;
3314: l_debrief_header_id number := null;
3315: begin
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3318: select debrief_header_id
3319: into l_debrief_header_id
3320: from csf_debrief_headers
3321: where task_assignment_id = l_task_assignment_id;

Line 3396: from jtf_task_assignments_audit_b jtaab,

3392: cursor c_audit_travel(p_task_assignment_id number) is
3393: select jtsbold.travel_flag old_travel_flag,
3394: jtsbnew.travel_flag new_travel_flag,
3395: trunc(jtaab.creation_date,'MI') creation_date
3396: from jtf_task_assignments_audit_b jtaab,
3397: jtf_task_statuses_b jtsbnew,
3398: jtf_task_statuses_b jtsbold
3399: where jtsbold.task_status_id = jtaab.old_assignment_status_id
3400: and jtsbnew.task_status_id = jtaab.new_assignment_status_id

Line 3409: from jtf_task_assignments_audit_b jtaab,

3405: cursor c_audit_working(p_task_assignment_id number) is
3406: select jtsbold.working_flag old_working_flag,
3407: jtsbnew.working_flag new_working_flag,
3408: trunc(jtaab.creation_date,'MI') creation_date
3409: from jtf_task_assignments_audit_b jtaab,
3410: jtf_task_statuses_b jtsbnew,
3411: jtf_task_statuses_b jtsbold
3412: where jtsbold.task_status_id = jtaab.old_assignment_status_id
3413: and jtsbnew.task_status_id = jtaab.new_assignment_status_id

Line 3432: from jtf_task_assignments jta,

3428: and jttb.task_type_id = jtb.task_type_id;
3429:
3430: cursor c_any_working_task is
3431: select 'Y'
3432: from jtf_task_assignments jta,
3433: jtf_task_statuses_b jtsb
3434: where assignee_role = 'ASSIGNEE'
3435: and resource_type_code = l_resource_type_code
3436: and resource_id = l_resource_id

Line 3442: from jtf_task_assignments

3438: and (working_flag = 'Y' or travel_flag = 'Y');
3439:
3440: cursor c_assignee_role(p_task_assignment_id number) is
3441: select assignee_role
3442: from jtf_task_assignments
3443: where task_assignment_id = p_task_assignment_id;
3444:
3445: l_assignee_role varchar2(100);
3446:

Line 3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);

3444:
3445: l_assignee_role varchar2(100);
3446:
3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;

Line 3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);

3445: l_assignee_role varchar2(100);
3446:
3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;
3453: close c_assignee_role;

Line 3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);

3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;
3453: close c_assignee_role;
3454: log('task_assignment_post_update','l_assignee_role: '||l_assignee_role);
3455: if nvl(l_assignee_role,'OWNER') = 'ASSIGNEE' then

Line 3457: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

3453: close c_assignee_role;
3454: log('task_assignment_post_update','l_assignee_role: '||l_assignee_role);
3455: if nvl(l_assignee_role,'OWNER') = 'ASSIGNEE' then
3456: l_task_id :=
3457: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
3458: log('task_assignment_post_update','l_task_id: '||l_task_id);
3459: open c_task_type_rule;
3460: fetch c_task_type_rule into l_task_type_rule;
3461: log('task_assignment_post_update','l_task_type_rule: '||l_task_type_rule);

Line 3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3461: log('task_assignment_post_update','l_task_type_rule: '||l_task_type_rule);
3462: close c_task_type_rule;
3463: if l_task_type_rule = 'DISPATCH' then
3464: l_task_assignment_id :=
3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3466: log('task_assignment_post_update','l_task_assignment_id: '||l_task_assignment_id);
3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);

Line 3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

3464: l_task_assignment_id :=
3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3466: log('task_assignment_post_update','l_task_assignment_id: '||l_task_assignment_id);
3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);
3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);

Line 3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);
3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);
3473: l_assignment_status_id :=
3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
3475: log('task_assignment_post_update','l_assignment_status_id: '||l_assignment_status_id);

Line 3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;

3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);
3473: l_assignment_status_id :=
3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
3475: log('task_assignment_post_update','l_assignment_status_id: '||l_assignment_status_id);
3476:
3477: open c_working_flag;
3478: fetch c_working_flag into l_working_flag,l_travel_flag;

Line 3489: jtf_task_assignments jta

3485: set hz_location_id =
3486: (select hps.location_id
3487: from hz_party_sites hps,
3488: jtf_tasks_b jtb,
3489: jtf_task_assignments jta
3490: where hps.party_site_id = jtb.address_id
3491: and jta.task_id = jtb.task_id
3492: and jta.task_assignment_id = l_task_assignment_id)
3493: where cpp.stocking_site_type = 'TECHNICIAN'

Line 3675: from jtf_task_assignments_audit_b jtaab,

3671:
3672: cursor c_labor_auto_create is
3673: select decode(fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'),
3674: 'STATUS',jtsb.working_flag,'N')
3675: from jtf_task_assignments_audit_b jtaab,
3676: jtf_task_statuses_b jtsb
3677: where jtsb.task_status_id = jtaab.new_assignment_status_id
3678: and jtaab.assignment_id = p_task_assignment_id
3679: and jtsb.working_flag = 'Y';

Line 3749: from jtf_task_assignments jta,

3745:
3746: cursor c_task_assgin_object_version is
3747: select task_id, jta.task_assignment_id, jta.object_version_number,
3748: jta.resource_type_code, jta.resource_id
3749: from jtf_task_assignments jta,
3750: csf_debrief_headers cdh
3751: where jta.task_assignment_id = cdh.task_assignment_id
3752: and cdh.debrief_header_id = p_debrief_header_id;
3753:

Line 3792: jtf_task_assignments jta,

3788: max(labor_end_date),
3789: min(debrief_line_id)
3790: from csf_debrief_lines cdl,
3791: csf_debrief_headers cdh,
3792: jtf_task_assignments jta,
3793: cs_transaction_types ctt
3794: where jta.task_id = l_task_id
3795: and jta.task_assignment_id = cdh.task_assignment_id
3796: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3806: jtf_task_assignments jta,

3802: max(labor_end_date),
3803: min(debrief_line_id)
3804: from csf_debrief_lines cdl,
3805: csf_debrief_headers cdh,
3806: jtf_task_assignments jta,
3807: cs_transaction_types ctt
3808: where jta.task_id = l_task_id
3809: and jta.task_assignment_id = cdh.task_assignment_id
3810: and cdh.debrief_header_id = cdl.debrief_header_id

Line 3821: jtf_task_assignments jta,

3817: select min(labor_start_date),
3818: max(labor_end_date)
3819: from csf_debrief_lines cdl,
3820: csf_debrief_headers cdh,
3821: jtf_task_assignments jta,
3822: jtf_tasks_b jtb,
3823: cs_transaction_types ctt
3824: where jtb.parent_task_id = l_parent_task_id
3825: and jta.task_id = jtb.task_id

Line 3836: jtf_task_assignments jta,

3832: select min(labor_start_date),
3833: max(labor_end_date)
3834: from csf_debrief_lines cdl,
3835: csf_debrief_headers cdh,
3836: jtf_task_assignments jta,
3837: jtf_tasks_b jtb,
3838: cs_transaction_types ctt
3839: where jtb.parent_task_id = l_parent_task_id
3840: and jta.task_id = jtb.task_id

Line 3855: from jtf_task_assignments jta,

3851: -- bug # 6960521
3852: -- substract RETURN type line's duration from total
3853: cursor c_task_assignment_dur is
3854: select uom_code, quantity
3855: from jtf_task_assignments jta,
3856: csf_debrief_headers cdh,
3857: csf_debrief_lines cdl,
3858: cs_transaction_types ctt
3859: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3874: from jtf_task_assignments jta,

3870: or
3871: cdl.inventory_item_id is null)
3872: union all
3873: select uom_code, (quantity * -1)
3874: from jtf_task_assignments jta,
3875: csf_debrief_headers cdh,
3876: csf_debrief_lines cdl,
3877: cs_transaction_types ctt
3878: where cdh.debrief_header_id = cdl.debrief_header_id

Line 3896: jtf_task_assignments jta,

3892: cursor c_task_dur is
3893: select uom_code, quantity
3894: from csf_debrief_lines cdl,
3895: csf_debrief_headers cdh,
3896: jtf_task_assignments jta,
3897: jtf_tasks_b jtb,
3898: cs_transaction_types ctt
3899: where cdh.debrief_header_id = cdl.debrief_header_id
3900: and jta.task_assignment_id = cdh.task_assignment_id

Line 3917: jtf_task_assignments jta,

3913: union all
3914: select uom_code, (quantity * -1)
3915: from csf_debrief_lines cdl,
3916: csf_debrief_headers cdh,
3917: jtf_task_assignments jta,
3918: jtf_tasks_b jtb,
3919: cs_transaction_types ctt
3920: where cdh.debrief_header_id = cdl.debrief_header_id
3921: and jta.task_assignment_id = cdh.task_assignment_id

Line 3939: jtf_task_assignments jta,

3935: cursor c_parent_task_dur is
3936: select uom_code, quantity
3937: from csf_debrief_lines cdl,
3938: csf_debrief_headers cdh,
3939: jtf_task_assignments jta,
3940: jtf_tasks_b jtb,
3941: cs_transaction_types ctt
3942: where cdh.debrief_header_id = cdl.debrief_header_id
3943: and jta.task_assignment_id = cdh.task_assignment_id

Line 3960: jtf_task_assignments jta,

3956: union all
3957: select uom_code, (quantity * -1)
3958: from csf_debrief_lines cdl,
3959: csf_debrief_headers cdh,
3960: jtf_task_assignments jta,
3961: jtf_tasks_b jtb,
3962: cs_transaction_types ctt
3963: where cdh.debrief_header_id = cdl.debrief_header_id
3964: and jta.task_assignment_id = cdh.task_assignment_id

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

4253: l_service_request_date date;
4254:
4255: Cursor get_service_request_date IS
4256: select nvl(incident_occurred_date,incident_date)
4257: from jtf_task_assignments jta , cs_incidents_all cia, jtf_tasks_b jtb
4258: where jta.task_assignment_id = p_task_assignment_id
4259: and jtb.task_id = jta.task_id
4260: and cia.incident_id = jtb.source_object_id
4261: and jtb.source_object_type_code = 'SR';