[Home] [Help]
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
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
1577: and debrief_line_id = l_debrief_line_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
2225: and debrief_line_id = l_debrief_line_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:
2811: -- Virendra Singh 03/21/2000
3030: nvl(p_start_date,fnd_api.g_miss_date)),
3031: greatest(nvl(actual_end_date,p_end_date),
3032: nvl(p_end_date,fnd_api.g_miss_date)),
3033: object_version_number
3034: from jtf_tasks_b
3035: where task_id = l_task_id
3036: and (nvl(actual_start_date,p_start_date) >=
3037: nvl(p_start_date,actual_start_date)
3038: or nvl(actual_end_date,p_end_date) <=
3102: from cs_incidents_all_b ci_all,
3103: cs_counter_groups cs_grp,
3104: cs_counters cs_ctr,
3105: cs_counter_values cs_ctr_v,
3106: jtf_tasks_b jt_b
3107: where ci_all.incident_id = p_incident_id
3108: and ci_all.customer_product_id = cs_grp.source_object_id
3109: and cs_grp.source_object_code = 'CP'
3110: and cs_ctr.type = 'REGULAR'
3118: cs_incidents_all_b ci_all,
3119: cs_counter_groups cs_grp,
3120: cs_counters cs_ctr,
3121: cs_counter_values cs_ctr_v,
3122: jtf_tasks_b jt_b
3123: where ci_all.incident_id = p_incident_id
3124: and ci_all.customer_product_id = cs_grp.source_object_id
3125: and cs_grp.source_object_code = 'CP'
3126: and cs_ctr.type = 'REGULAR'
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
3188: and ((p_debrief_line_id is not null
3308: and cdh.debrief_header_id = p_debrief_header_id;
3309:
3310: cursor c_task_object_version is
3311: select parent_task_id,object_version_number
3312: from jtf_tasks_b
3313: where task_id = l_task_id ;
3314:
3315: cursor c_parent_task_object_version is
3316: select object_version_number
3313: where task_id = l_task_id ;
3314:
3315: cursor c_parent_task_object_version is
3316: select object_version_number
3317: from jtf_tasks_b
3318: where task_id = l_parent_task_id ;
3319:
3320: cursor c_task_assignment is
3321: 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
3382: and jta.task_assignment_id = cdh.task_assignment_id
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
3397: and jta.task_assignment_id = cdh.task_assignment_id
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
3457: and cdl.transaction_type_id = ctt.transaction_type_id
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
3478: and cdl.transaction_type_id = ctt.transaction_type_id
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
3500: and cdl.transaction_type_id = ctt.transaction_type_id
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
3521: and cdl.transaction_type_id = ctt.transaction_type_id
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';