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.EAM_WORKORDERREP_PVT dependencies on FND_DATE

Line 93: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.FIRST_UNIT_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSSHEDULEDSTART",

89:
90:
91: cursor operation_cursor(p_wip_id number) is
92: SELECT XMLELEMENT("OPERATION", XMLFOREST(WO.OPERATION_SEQ_NUM as "OPSEQNUM",
93: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.FIRST_UNIT_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSSHEDULEDSTART",
94: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.LAST_UNIT_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSCHEDULEDCOMPLETION",
95: to_char((WO.LAST_UNIT_COMPLETION_DATE-WO.FIRST_UNIT_START_DATE),'99.99') as "OPDURATION",
96: LU2.meaning as "OPSHUTDOWNTYPE",
97: LU1.meaning as "OPCOMPLETED",

Line 94: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.LAST_UNIT_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSCHEDULEDCOMPLETION",

90:
91: cursor operation_cursor(p_wip_id number) is
92: SELECT XMLELEMENT("OPERATION", XMLFOREST(WO.OPERATION_SEQ_NUM as "OPSEQNUM",
93: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.FIRST_UNIT_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSSHEDULEDSTART",
94: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WO.LAST_UNIT_COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "OPSCHEDULEDCOMPLETION",
95: to_char((WO.LAST_UNIT_COMPLETION_DATE-WO.FIRST_UNIT_START_DATE),'99.99') as "OPDURATION",
96: LU2.meaning as "OPSHUTDOWNTYPE",
97: LU1.meaning as "OPCOMPLETED",
98: BS.OPERATION_CODE as "OPCODE",

Line 102: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_start_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALSTARTDATE",

98: BS.OPERATION_CODE as "OPCODE",
99: BD.DEPARTMENT_CODE as "OPDEPT",
100: WO.DESCRIPTION as "OPDESC",
101: WO.LONG_DESCRIPTION as "OPLONGDESC",
102: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_start_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALSTARTDATE",
103: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_end_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALENDDATE")) Operation
104: FROM
105: eam_op_completion_txns_v eoctv,
106: FND_COMMON_LOOKUPS LU1,

Line 103: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_end_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALENDDATE")) Operation

99: BD.DEPARTMENT_CODE as "OPDEPT",
100: WO.DESCRIPTION as "OPDESC",
101: WO.LONG_DESCRIPTION as "OPLONGDESC",
102: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_start_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALSTARTDATE",
103: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eoctv.actual_end_date),calendar_aware => FND_DATE.calendar_aware_alt) as "OPACTUALENDDATE")) Operation
104: FROM
105: eam_op_completion_txns_v eoctv,
106: FND_COMMON_LOOKUPS LU1,
107: MFG_LOOKUPS LU2,

Line 132: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WRO.DATE_REQUIRED), calendar_aware => FND_DATE.calendar_aware_alt) as "REQDATEREQUIRED",

128: milk.concatenated_segments as "REQLOCATORNAME",
129: --M.DESCRIPTION as "REQCOMPDESC",
130: LU.MEANING as "REQTYPE",
131: WRO.SUPPLY_SUBINVENTORY as "REQSUBINVENTORY",
132: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WRO.DATE_REQUIRED), calendar_aware => FND_DATE.calendar_aware_alt) as "REQDATEREQUIRED",
133: M.PRIMARY_UOM_CODE as "REQUOM",
134: WRO.REQUIRED_QUANTITY as "REQREQUIREDQUANTITY",
135: msikfv.concatenated_segments as "REQITEMNAME",
136: msikfv.description as "REQITEMDESCRIPTION",

Line 180: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESSTARTDATE",

176: LU.MEANING as "RESBASIS",
177: WOR.APPLIED_RESOURCE_UNITS as "ACTUALHRCHARGED",
178: WOR.ASSIGNED_UNITS as "RESCAPACITY",
179: CA.ACTIVITY as "RESACTIVITY",
180: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESSTARTDATE",
181: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESCOMPLETIONDATE")) Resources
182: FROM
183: BOM_RESOURCES BR,
184: CST_ACTIVITIES CA,

Line 181: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESCOMPLETIONDATE")) Resources

177: WOR.APPLIED_RESOURCE_UNITS as "ACTUALHRCHARGED",
178: WOR.ASSIGNED_UNITS as "RESCAPACITY",
179: CA.ACTIVITY as "RESACTIVITY",
180: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESSTARTDATE",
181: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(WOR.COMPLETION_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "RESCOMPLETIONDATE")) Resources
182: FROM
183: BOM_RESOURCES BR,
184: CST_ACTIVITIES CA,
185: MFG_LOOKUPS LU,

Line 205: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPSTARTDATE",

201: br.resource_code as "EMPRESCODE",
202: br.resource_type as "EMPRESTYPE",
203: ppf.employee_number as "EMPNO",
204: ppf.full_name as "EMPFULLNAME",
205: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPSTARTDATE",
206: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPENDDATE",
207: bd.department_code as "EMPDEPTCODE")) Employees
208: FROM wip_op_resource_instances wori,
209: wip_operation_resources wor,

Line 206: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPENDDATE",

202: br.resource_type as "EMPRESTYPE",
203: ppf.employee_number as "EMPNO",
204: ppf.full_name as "EMPFULLNAME",
205: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPSTARTDATE",
206: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wori.completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "EMPENDDATE",
207: bd.department_code as "EMPDEPTCODE")) Employees
208: FROM wip_op_resource_instances wori,
209: wip_operation_resources wor,
210: bom_resources br,

Line 239: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(edrv.date_required), calendar_aware => FND_DATE.calendar_aware_alt) as "DATEREQUIRED")) DirectMaterial

235: DECODE(edrv.order_type_lookup_code,'FIXED PRICE',NVL(edrv.rql_amount_ordered,0),NVL(edrv.rql_quantity_ordered,0)) as "REQQUANTITYORDERED",
236: DECODE(edrv.order_type_lookup_code,'FIXED PRICE',NVL(edrv.po_amount_ordered,0),NVL(edrv.po_quantity_ordered,0)) as "POQUANTITYORDERED",
237: DECODE(edrv.order_type_lookup_code,'FIXED PRICE',NVL(edrv.amount_delivered,0),NVL(edrv.quantity_received, 0)) as "QUANTITYRECEIVED",
238: edrv.uom_code as "UOM",
239: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(edrv.date_required), calendar_aware => FND_DATE.calendar_aware_alt) as "DATEREQUIRED")) DirectMaterial
240: FROM EAM_DIRECT_ITEM_RECS_V edrv
241: WHERE edrv.wip_entity_id = p_wip_id;
242:
243:

Line 371: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewr.expected_resolution_date), calendar_aware => FND_DATE.calendar_aware_alt) as "WREXPECTEDRESOLUTIONDATE",

367: wewr.description as "WRDESCRIPTION",
368: ml1.meaning as "WRSTATUS" ,
369: ml2.meaning as "WRPRIORITY",
370: bd.department_code as "WROWNINGDEPT",
371: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewr.expected_resolution_date), calendar_aware => FND_DATE.calendar_aware_alt) as "WREXPECTEDRESOLUTIONDATE",
372: fu.user_name as "WRORIGINATOR")) WorkRequest
373: from
374: wip_eam_work_requests wewr,
375: fnd_user fu,

Line 398: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(NVL(CCR2.VALUE_TIMESTAMP,CCR1.VALUE_TIMESTAMP)), calendar_aware => FND_DATE.calendar_aware_alt) as "LASTVALUETIMESTAMP",

394: CTL.NAME as "COUNTERNAME",
395: NVL(CTL2.NAME,CTL.NAME) as "SOURCECOUNTERNAME",
396: NVL(CBS.COUNTER_TYPE,CB.COUNTER_TYPE) as "COUNTERTYPE",
397: NVL(CCR2.COUNTER_READING,CCR1.COUNTER_READING) as "LASTREADING",
398: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(NVL(CCR2.VALUE_TIMESTAMP,CCR1.VALUE_TIMESTAMP)), calendar_aware => FND_DATE.calendar_aware_alt) as "LASTVALUETIMESTAMP",
399: CB.uom_code as "METERUOM",
400: TO_NUMBER(NULL) as "NEWREADING",
401: EAM_METERS_UTIL.IS_METER_READING_MANDATORY_V(p_wip_id, nvl(CBS.COUNTER_ID,CB.COUNTER_ID)) as "MANDATORY" )) Meter
402: FROM csi_counters_b CB,

Line 621: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt)AS permit_valid_from,

617: EWP.PERMIT_NAME,
618: ml.meaning AS permit_type,
619: EWP.DESCRIPTION,
620: EPSV.PERMIT_STATUS,
621: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt)AS permit_valid_from,
622: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permit_valid_to
623: from
624: EAM_WORK_PERMITS EWP,
625: EAM_SAFETY_ASSOCIATIONS ESA,

Line 622: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permit_valid_to

618: ml.meaning AS permit_type,
619: EWP.DESCRIPTION,
620: EPSV.PERMIT_STATUS,
621: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt)AS permit_valid_from,
622: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permit_valid_to
623: from
624: EAM_WORK_PERMITS EWP,
625: EAM_SAFETY_ASSOCIATIONS ESA,
626: EAM_PERMIT_STATUSES_VL EPSV,

Line 641: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidFrom,

637: SELECT DISTINCT EWP1.PERMIT_NAME ,
638: ml1.meaning ,
639: EWP1.DESCRIPTION ,
640: EPSV1.PERMIT_STATUS ,
641: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidFrom,
642: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidTo
643:
644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,

Line 642: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidTo

638: ml1.meaning ,
639: EWP1.DESCRIPTION ,
640: EPSV1.PERMIT_STATUS ,
641: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_FROM), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidFrom,
642: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP1.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permitValidTo
643:
644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,
646: eam_safety_associations esa2,

Line 683: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabStDate,

679: SELECT XMLELEMENT("WORKCLEARANCE",
680: XMLFOREST(
681: QRSLT.WORK_CLEARANCE_NAME as workClearanceName ,
682: QRSLT.DESCRIPTION as description ,
683: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabStDate,
684: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabEndDate,
685: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabStDate,
686: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabEndDate,
687: QRSLT.user_status AS userStatus,

Line 684: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabEndDate,

680: XMLFOREST(
681: QRSLT.WORK_CLEARANCE_NAME as workClearanceName ,
682: QRSLT.DESCRIPTION as description ,
683: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabStDate,
684: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabEndDate,
685: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabStDate,
686: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabEndDate,
687: QRSLT.user_status AS userStatus,
688: QRSLT.isolation_type AS isolationType )) workclearance

Line 685: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabStDate,

681: QRSLT.WORK_CLEARANCE_NAME as workClearanceName ,
682: QRSLT.DESCRIPTION as description ,
683: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabStDate,
684: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabEndDate,
685: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabStDate,
686: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabEndDate,
687: QRSLT.user_status AS userStatus,
688: QRSLT.isolation_type AS isolationType )) workclearance
689: FROM

Line 686: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabEndDate,

682: QRSLT.DESCRIPTION as description ,
683: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabStDate,
684: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_ESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedEstabEndDate,
685: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabStDate,
686: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(QRSLT.SCHEDULED_REESTAB_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) AS schedReEstabEndDate,
687: QRSLT.user_status AS userStatus,
688: QRSLT.isolation_type AS isolationType )) workclearance
689: FROM
690: (

Line 1109: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eaf.failure_date), calendar_aware => FND_DATE.calendar_aware_alt) as "FAILUREDATE",

1105:
1106: --Adding Failure Data
1107: begin
1108: select XMLELEMENT("FAILUREDATA",XMLFOREST(ewod.failure_code_required as "CODEREQUIRED",
1109: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eaf.failure_date), calendar_aware => FND_DATE.calendar_aware_alt) as "FAILUREDATE",
1110: eafc.failure_code as "FAILURECODE",
1111: eafc.cause_code as "CAUSECODE",
1112: eafc.resolution_code as "RESOLUTIONCODE",
1113: efs.set_name as "SETNAME",

Line 1149: select XMLConcat(XMLELEMENT("WARRANTYEXPDATE",fnd_date.date_to_displayDT(dateval => Convert_to_client_time(csi.SUPPLIER_WARRANTY_EXP_DATE), calendar_aware => FND_DATE.calendar_aware_alt)),l_xmlTemp3) into l_xmlTemp3

1145: end;
1146:
1147: --Adding Warranty Expiration Date
1148: begin
1149: select XMLConcat(XMLELEMENT("WARRANTYEXPDATE",fnd_date.date_to_displayDT(dateval => Convert_to_client_time(csi.SUPPLIER_WARRANTY_EXP_DATE), calendar_aware => FND_DATE.calendar_aware_alt)),l_xmlTemp3) into l_xmlTemp3
1150: from csi_item_instances csi, wip_discrete_jobs wdj
1151: where wdj.maintenance_object_id=csi.instance_id
1152: and wdj.maintenance_object_type=3
1153: and wdj.wip_entity_id=p_wip_entity_id(i);

Line 1161: SELECT XMLConcat(XMLFOREST(fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALSTARTDATE",

1157: end;
1158:
1159: --Adding Actual Start Date and Actual End Date
1160: begin
1161: SELECT XMLConcat(XMLFOREST(fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALSTARTDATE",
1162: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALENDDATE",
1163: round((ACTUAL_END_DATE-ACTUAL_START_DATE)*24,2) as "ACTUALDURATION"),l_xmlTemp3) into l_xmlTemp3
1164: FROM EAM_JOB_COMPLETION_TXNS
1165: WHERE TRANSACTION_TYPE=1

Line 1162: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALENDDATE",

1158:
1159: --Adding Actual Start Date and Actual End Date
1160: begin
1161: SELECT XMLConcat(XMLFOREST(fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_START_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALSTARTDATE",
1162: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(ACTUAL_END_DATE), calendar_aware => FND_DATE.calendar_aware_alt) as "ACTUALENDDATE",
1163: round((ACTUAL_END_DATE-ACTUAL_START_DATE)*24,2) as "ACTUALDURATION"),l_xmlTemp3) into l_xmlTemp3
1164: FROM EAM_JOB_COMPLETION_TXNS
1165: WHERE TRANSACTION_TYPE=1
1166: AND TRANSACTION_ID=

Line 1232: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMSTARTDATE",

1228: flm5.meaning as "PLANNED",
1229: wewdv.planner_maintenance_meaning as "PLANNERTYPE",
1230: wewdv.project_name as "PROJECTNAME",
1231: wewdv.task_name as "TASKNAME",
1232: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMSTARTDATE",
1233: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_end_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMENDDATE",
1234: flm2.meaning as "MATISSUEREQUEST",
1235: lu1.meaning as "FIRM",
1236: lu2.meaning as "MATSHORTAGE",

Line 1233: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_end_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMENDDATE",

1229: wewdv.planner_maintenance_meaning as "PLANNERTYPE",
1230: wewdv.project_name as "PROJECTNAME",
1231: wewdv.task_name as "TASKNAME",
1232: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMSTARTDATE",
1233: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_end_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMENDDATE",
1234: flm2.meaning as "MATISSUEREQUEST",
1235: lu1.meaning as "FIRM",
1236: lu2.meaning as "MATSHORTAGE",
1237: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.material_shortage_check_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ASOFDATE",

Line 1237: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.material_shortage_check_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ASOFDATE",

1233: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.pm_suggested_end_date), calendar_aware => FND_DATE.calendar_aware_alt) as "PMENDDATE",
1234: flm2.meaning as "MATISSUEREQUEST",
1235: lu1.meaning as "FIRM",
1236: lu2.meaning as "MATSHORTAGE",
1237: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.material_shortage_check_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ASOFDATE",
1238: wewdv.owning_department_code as "DEPARTMENT",
1239: wewdv.work_order_type_disp as "WOTYPE",
1240: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "STARTDATE",
1241: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ENDDATE",

Line 1240: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "STARTDATE",

1236: lu2.meaning as "MATSHORTAGE",
1237: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.material_shortage_check_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ASOFDATE",
1238: wewdv.owning_department_code as "DEPARTMENT",
1239: wewdv.work_order_type_disp as "WOTYPE",
1240: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "STARTDATE",
1241: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ENDDATE",
1242: round((wewdv.scheduled_completion_date-wewdv.scheduled_start_date)*24,2) as "SCHEDULEDDURATION",
1243: eps.name as "PMNAME",
1244: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eps.base_date), calendar_aware => FND_DATE.calendar_aware_alt) as "BASEDATE",

Line 1241: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ENDDATE",

1237: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.material_shortage_check_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ASOFDATE",
1238: wewdv.owning_department_code as "DEPARTMENT",
1239: wewdv.work_order_type_disp as "WOTYPE",
1240: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "STARTDATE",
1241: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ENDDATE",
1242: round((wewdv.scheduled_completion_date-wewdv.scheduled_start_date)*24,2) as "SCHEDULEDDURATION",
1243: eps.name as "PMNAME",
1244: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eps.base_date), calendar_aware => FND_DATE.calendar_aware_alt) as "BASEDATE",
1245: bd.description as "DEPTDESCRIPTION"),

Line 1244: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eps.base_date), calendar_aware => FND_DATE.calendar_aware_alt) as "BASEDATE",

1240: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_start_date), calendar_aware => FND_DATE.calendar_aware_alt) as "STARTDATE",
1241: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(wewdv.scheduled_completion_date), calendar_aware => FND_DATE.calendar_aware_alt) as "ENDDATE",
1242: round((wewdv.scheduled_completion_date-wewdv.scheduled_start_date)*24,2) as "SCHEDULEDDURATION",
1243: eps.name as "PMNAME",
1244: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(eps.base_date), calendar_aware => FND_DATE.calendar_aware_alt) as "BASEDATE",
1245: bd.description as "DEPTDESCRIPTION"),
1246: XMLConcat(l_xmlTemp3,l_xmlTypeFailureData,l_xmlType1,l_xmlTypeOperation,l_xmlTypeMaterial,l_xmlTypeResource,l_xmlTypeDirectMaterial,l_xmlTypeShortAttachment,
1247: l_xmlTypeLongAttachment,l_xmlTypefileattachment,l_xmlTypeWorkRequest,l_xmlTypeMeter,l_xmlTypeQualityPlan,l_xmlTypeAssetBom,l_xmlTypeAssetroutecomp,l_xmlTypePermits,l_xmlTypeClearances,l_xmlTypeParamList))) AS "RESULT" into l_xmlType
1248: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2