VIEW: APPS.EAM_WORK_ASSET_ROUTE_V

Source

View Text - Preformatted

SELECT wdj.wip_entity_id , mena.start_date_active , mena.end_date_active , cii.instance_number , cii.inventory_item_id , msik.concatenated_segments , wdj.maintenance_object_id , wdj.organization_id from wip_discrete_jobs wdj , mtl_eam_network_assets mena, csi_item_instances cii, eam_work_order_route ewor, mtl_system_items_kfv msik WHERE wdj.wip_entity_id = ewor.wip_entity_id and cii.instance_id = ewor.instance_id and mena.network_object_id = wdj.maintenance_object_id and mena.maintenance_object_id = cii.instance_id and msik.inventory_item_id = cii.inventory_item_id and msik.organization_id = cii.last_vld_organization_id union select null, mena.start_date_active , mena.end_date_active , cii.instance_number , cii.inventory_item_id , msik.concatenated_segments , mena.network_object_id , mp.maint_organization_id from MTL_EAM_NETWORK_ASSETS mena, mtl_system_items_kfv msik, csi_item_instances cii, mtl_parameters mp where mena.maintenance_object_id = cii.instance_id and msik.inventory_item_id = cii.inventory_item_id and msik.organization_id = cii.last_vld_organization_id and mp.organization_id = cii.last_vld_organization_id and nvl(mena.start_date_active, sysdate) <= sysdate AND nvl(mena.end_date_active, sysdate) >= sysdate

View Text - HTML Formatted

SELECT WDJ.WIP_ENTITY_ID
, MENA.START_DATE_ACTIVE
, MENA.END_DATE_ACTIVE
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, WDJ.MAINTENANCE_OBJECT_ID
, WDJ.ORGANIZATION_ID
FROM WIP_DISCRETE_JOBS WDJ
, MTL_EAM_NETWORK_ASSETS MENA
, CSI_ITEM_INSTANCES CII
, EAM_WORK_ORDER_ROUTE EWOR
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE WDJ.WIP_ENTITY_ID = EWOR.WIP_ENTITY_ID
AND CII.INSTANCE_ID = EWOR.INSTANCE_ID
AND MENA.NETWORK_OBJECT_ID = WDJ.MAINTENANCE_OBJECT_ID
AND MENA.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID UNION SELECT NULL
, MENA.START_DATE_ACTIVE
, MENA.END_DATE_ACTIVE
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MENA.NETWORK_OBJECT_ID
, MP.MAINT_ORGANIZATION_ID
FROM MTL_EAM_NETWORK_ASSETS MENA
, MTL_SYSTEM_ITEMS_KFV MSIK
, CSI_ITEM_INSTANCES CII
, MTL_PARAMETERS MP
WHERE MENA.MAINTENANCE_OBJECT_ID = CII.INSTANCE_ID
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND NVL(MENA.START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(MENA.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE