[Home] [Help]
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
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
1627: and debrief_line_id = l_debrief_line_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
2292: and debrief_line_id = l_debrief_line_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:
2879: -- Virendra Singh 03/21/2000
3098: nvl(p_start_date,fnd_api.g_miss_date)),
3099: greatest(nvl(actual_end_date,p_end_date),
3100: nvl(p_end_date,fnd_api.g_miss_date)),
3101: object_version_number
3102: from jtf_tasks_b
3103: where task_id = l_task_id
3104: and (nvl(actual_start_date,p_start_date) >=
3105: nvl(p_start_date,actual_start_date)
3106: or nvl(actual_end_date,p_end_date) <=
3176: select max(ccv.value_timestamp),
3177: max(jtb.creation_date)
3178: from csi_counter_associations cca,
3179: cs_counter_values ccv,
3180: jtf_tasks_b jtb
3181: where cca.source_object_id = l_customer_product_id
3182: and cca.source_object_code = 'CP'
3183: and ccv.counter_id(+)= cca.counter_id
3184: and jtb.task_id = p_task_id;
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
3237: and ((p_debrief_line_id is not null
3422:
3423: cursor c_task_type_rule is
3424: select jttb.rule
3425: from jtf_task_types_b jttb,
3426: jtf_tasks_b jtb
3427: where jtb.task_id = l_task_id
3428: and jttb.task_type_id = jtb.task_type_id;
3429:
3430: cursor c_any_working_task is
3484: update csp_planning_parameters cpp
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)
3752: and cdh.debrief_header_id = p_debrief_header_id;
3753:
3754: cursor c_task_object_version is
3755: select parent_task_id,object_version_number
3756: from jtf_tasks_b
3757: where task_id = l_task_id ;
3758:
3759: cursor c_parent_task_object_version is
3760: select object_version_number
3757: where task_id = l_task_id ;
3758:
3759: cursor c_parent_task_object_version is
3760: select object_version_number
3761: from jtf_tasks_b
3762: where task_id = l_parent_task_id ;
3763:
3764: cursor c_task_assignment is
3765: 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
3826: and jta.task_assignment_id = cdh.task_assignment_id
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
3841: and jta.task_assignment_id = cdh.task_assignment_id
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
3901: and cdl.transaction_type_id = ctt.transaction_type_id
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
3922: and cdl.transaction_type_id = ctt.transaction_type_id
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
3944: and cdl.transaction_type_id = ctt.transaction_type_id
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
3965: and cdl.transaction_type_id = ctt.transaction_type_id
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';