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.

[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on FND_TIMEZONE_PUB

Line 561: , to_char(fnd_timezone_pub.adjust_datetime(l_ext_attr_table(j).ATTR_VALUE_DATE, l_source_tz_code,l_dest_tz_code),l_date_format) -- Bug 11830349

557: ( topattrn
558: , Make_Node
559: ( indomdoc
560: , 'ATTR_VALUE_DISPLAY'
561: , to_char(fnd_timezone_pub.adjust_datetime(l_ext_attr_table(j).ATTR_VALUE_DATE, l_source_tz_code,l_dest_tz_code),l_date_format) -- Bug 11830349
562: -- , to_char(hz_timezone_pub.convert_datetime(l_server_timezone_id,l_client_timezone_id,l_ext_attr_table(j).ATTR_VALUE_DATE),l_date_format)
563: )
564: );
565:

Line 722: , DECODE(JNB.entered_date,'','',to_char(fnd_timezone_pub.adjust_datetime(JNB.ENTERED_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) Note_Creation_Date -- Bug 11830349

718:
719: CURSOR Get_Notes IS
720: SELECT CAST(MULTISET
721: (SELECT nvl2(ext_usert.resource_name, ext_usert.resource_name, fnd1.user_name) as Note_Created_By
722: , DECODE(JNB.entered_date,'','',to_char(fnd_timezone_pub.adjust_datetime(JNB.ENTERED_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) Note_Creation_Date -- Bug 11830349
723: -- , DECODE(JNB.entered_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,JNB.ENTERED_DATE),l_date_format)) Note_Creation_Date
724: , FLS.MEANING Note_Type
725: , FLP.MEANING Note_Visibility
726: , JNT.NOTES Note_Description

Line 789: DECODE(jtf1B.creation_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.creation_date, l_source_tz_code,l_dest_tz_code),l_date_format)) Task_Creation_Date -- Bug 11830349

785: CURSOR Get_Tasks IS
786: SELECT CAST(MULTISET
787: (SELECT
788: -- DECODE(jtf1B.creation_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.creation_date),l_date_format)) Task_Creation_Date
789: DECODE(jtf1B.creation_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.creation_date, l_source_tz_code,l_dest_tz_code),l_date_format)) Task_Creation_Date -- Bug 11830349
790: , jtf1B.task_number Task_Number
791: , type.name Task_Type
792: , jtf1T.TASK_NAME Task_Name
793: , jtf1T.DESCRIPTION Task_Description

Line 821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date

817: , DECODE(jtf1B.actual_start_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_START_DATE),l_date_format)) task_actual_start_date
818: , DECODE(jtf1B.actual_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_END_DATE),l_date_format)) task_actual_end_date
819: */
820: -- Bug 11830349
821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date
822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date

Line 822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date

818: , DECODE(jtf1B.actual_end_date,'','',to_char(hz_timezone_pub.convert_datetime(l_source_timezone_id,l_desc_timezone_id,jtf1B.ACTUAL_END_DATE),l_date_format)) task_actual_end_date
819: */
820: -- Bug 11830349
821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date
822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date

Line 823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date

819: */
820: -- Bug 11830349
821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date
822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B

Line 824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date

820: -- Bug 11830349
821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date
822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
828: , jtf_tasks_b jtf2

Line 825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date

821: , DECODE(jtf1B.planned_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_start_date
822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
828: , jtf_tasks_b jtf2
829: , jtf_task_types_tl type

Line 826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date

822: , DECODE(jtf1B.planned_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.planned_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_planned_end_date
823: , DECODE(jtf1B.scheduled_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_start_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_start_date
824: , DECODE(jtf1B.scheduled_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.scheduled_end_date, l_source_tz_code,l_dest_tz_code),l_date_format)) task_scheduled_end_date
825: , DECODE(jtf1B.actual_start_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_START_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_start_date
826: , DECODE(jtf1B.actual_end_date,'','',to_char(fnd_timezone_pub.adjust_datetime(jtf1B.ACTUAL_END_DATE, l_source_tz_code,l_dest_tz_code),l_date_format)) task_actual_end_date
827: FROM JTF_TASKS_TL jtf1T, JTF_TASKS_B jtf1B
828: , jtf_tasks_b jtf2
829: , jtf_task_types_tl type
830: , jtf_task_priorities_tl priority

Line 930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date

926: ,sr.customer_id Customer_Id
927: ,sr.account_id Account_Id
928: ,sr.inventory_item_id Inventory_Item_Id
929: -- Bug 11830349
930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date
931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date

Line 931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date

927: ,sr.account_id Account_Id
928: ,sr.inventory_item_id Inventory_Item_Id
929: -- Bug 11830349
930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date
931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date

Line 932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date

928: ,sr.inventory_item_id Inventory_Item_Id
929: -- Bug 11830349
930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date
931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date

Line 933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date

929: -- Bug 11830349
930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date
931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date

Line 934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date

930: ,nvl2(sr.incident_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) reported_date
931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date
938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date

Line 935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date

931: ,nvl2(sr.incident_last_modified_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_last_modified_date, l_source_tz_code,l_dest_tz_code),v_date_format),null)Last_Update_Date
932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date
938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date
939: /* ,nvl2(sr.incident_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id, sr.incident_date),v_date_format),null) reported_date

Line 936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date

932: ,nvl2(sr.incident_occurred_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_occurred_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Incident_Date
933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date
938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date
939: /* ,nvl2(sr.incident_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id, sr.incident_date),v_date_format),null) reported_date
940: ,nvl2(sr.incident_last_modified_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.incident_last_modified_date),v_date_format),null)Last_Update_Date

Line 937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date

933: ,nvl2(sr.close_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.close_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Close_Date
934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date
938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date
939: /* ,nvl2(sr.incident_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id, sr.incident_date),v_date_format),null) reported_date
940: ,nvl2(sr.incident_last_modified_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.incident_last_modified_date),v_date_format),null)Last_Update_Date
941: ,nvl2(sr.incident_occurred_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.incident_occurred_date),v_date_format),null) Incident_Date

Line 938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date

934: ,nvl2(sr.incident_resolved_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.incident_resolved_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) incident_resolved_date
935: ,nvl2(sr.obligation_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.obligation_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) respond_by_date
936: ,nvl2(sr.expected_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.expected_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) resolve_by_date
937: ,nvl2(sr.inc_responded_by_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.inc_responded_by_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) inc_responded_by_date
938: ,nvl2(sr.actual_resolution_date,TO_CHAR(fnd_timezone_pub.adjust_datetime(sr.actual_resolution_date, l_source_tz_code,l_dest_tz_code),v_date_format),null) Actual_Resolution_Date
939: /* ,nvl2(sr.incident_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id, sr.incident_date),v_date_format),null) reported_date
940: ,nvl2(sr.incident_last_modified_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.incident_last_modified_date),v_date_format),null)Last_Update_Date
941: ,nvl2(sr.incident_occurred_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.incident_occurred_date),v_date_format),null) Incident_Date
942: ,nvl2(sr.close_date,TO_CHAR(hz_timezone_pub.convert_datetime(v_source_timezone_id,v_desc_timezone_id,sr.close_date),v_date_format),null) Close_Date