1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| SELECT
to_char(EAM.SCHEDULED_START_DATE,'dd/mm/yyyy') as dd,
to_char (EAM.SCHEDULED_COMPLETION_DATE,'dd/mm/yyyy') as df,
EAM.PRIORITY_DISP as pr,
EAM.CAUSE_CODE as cauz,
EAM.WIP_ENTITY_NAME as val,
EAM.INSTANCE_NUMBER as cd_eqp,
EAM.OWNING_DEPARTMENT_CODE as cd_sec,
round((wdj.SCHEDULED_COMPLETION_DATE - wdj.SCHEDULED_START_DATE) * 24, 3) AS duration,
MTLEAR.ASSET_GROUP_DESCRIPTION AS ASGD,
MTLEAR.EAM_LOCATION AS EAMLOC,
fu.user_name as us_na,
ECOV.DESCRIPTION AS DESO,
ECOV.OPERATION_CODE AS OPER_COD,
WIPV.REQUIRED_QUANTITY AS REQ_QUANT ,
WIPV.ITEM_DESCRIPTION AS ITDES,
to_char (WIPV.DATE_REQUIRED,'dd/mm/yyyy') AS DATE_REQ,
WIPV.CONCATENATED_SEGMENTS AS CONSEG,
A1.RESOURCE_CODE as ressource,
A1.DEPARTMENT_CODE as section,
A2.DESCRIPTION as de_en,
A3.UNIT_PRICE as prix ,
A3.UOM as ut,
A4.ACTUAL_MATERIAL_COST as cr,
A4.ESTIMATED_MATERIAL_COST as ce,
A4.ACTUAL_LABOR_COST as mo,
A4.ACTUAL_EQUIPMENT_COST as peq,
A4.ESTIMATED_TOTAL_COST as pt,
A5.RESOURCE_RATE as cress,
A6.INSTANCE_NAME as nom
from
EAM_WORK_ORDERS_V EAM,
WIP_DISCRETE_JOBS wdj,
MTL_EAM_ASSET_REBUILDS_DTLS_V MTLEAR,
FND_USER fu,
EAM_CFR_OPERATIONS_V ECOV,
EAM_CFR_MATERIALS_V WIPV,
WIP_OPERATION_RESOURCES_V A1,
WIP_ENTITIES A2,
WIP_EAM_DIRECT_ITEMS A3,
WIP_EAM_COST_DETAILS_V A4,
EAM_RESOURCES_V A5,
WIP_OP_RESOURCE_INSTANCES_V A6
where
EAM.WIP_ENTITY_ID= wdj.WIP_ENTITY_ID AND
EAM.INSTANCE_NUMBER=MTLEAR.INSTANCE_NUMBER AND
fu.user_id=wdj.created_by AND
EAM.WIP_ENTITY_ID= ECOV.WIP_ENTITY_ID AND
EAM.WIP_ENTITY_ID=A1.WIP_ENTITY_ID and
ECOV.WIP_ENTITY_ID=WIPV.WIP_ENTITY_ID and
A2.WIP_ENTITY_ID=EAM.WIP_ENTITY_ID and
A3.WIP_ENTITY_ID=EAM.WIP_ENTITY_ID and
A4.WIP_ENTITY_ID=EAM.WIP_ENTITY_ID and
A5.WIP_ENTITY_ID=EAM.WIP_ENTITY_ID and
A6.WIP_ENTITY_ID=EAM.WIP_ENTITY_ID and
EAM.WIP_ENTITY_NAME='18103'; |
Partager