VIEW: APPS.WSHFV_TRIPS

Source

View Text - Preformatted

SELECT WST1.TRIP_ID , WST1.NAME , WST1.ARRIVE_AFTER_TRIP_ID , WST2.NAME ARRIVE_AFTER_TRIP_NAME, '_LA:WST1.STATUS_CODE:WSH_LOOKUPS:TRIP_STATUS:MEANING' ,WST1.VEHICLE_ITEM_ID ,'_KF:INV:MSTK:MSI' ,MSI.DESCRIPTION VEHICLE_DESCRIPTION ,WST1.VEHICLE_NUMBER , '_LA:WST1.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING' , WST1.ROUTING_INSTRUCTIONS , WST1.CREATION_DATE , WST1.CREATED_BY , WST1.LAST_UPDATE_DATE , WST1.LAST_UPDATED_BY , WST1.LAST_UPDATE_LOGIN , '_LA:WST1.PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WST1.CARRIER_ID ,WST1.ROUTE_ID ,WST1.VEHICLE_ORGANIZATION_ID ,MPA.ORGANIZATION_CODE ,ORG.NAME ,'_DF:WSH:WSH_TRIPS:WST1' ,WST1.VEHICLE_NUM_PREFIX , WST1.SHIPMENTS_TYPE_FLAG FROM WSH_TRIPS WST1, WSH_TRIPS WST2,MTL_SYSTEM_ITEMS MSI ,HR_ALL_ORGANIZATION_UNITS ORG,MTL_PARAMETERS MPA WHERE WST1.ARRIVE_AFTER_TRIP_ID = WST2.TRIP_ID(+) AND WST1.VEHICLE_ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) AND WST1.VEHICLE_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WST1.VEHICLE_ORGANIZATION_ID = MPA.ORGANIZATION_ID(+) AND WST1.VEHICLE_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) AND '_SEC:WST1.VEHICLE_ORGANIZATION_ID' IS NOT NULL AND NVL(WST1.SHIPMENTS_TYPE_FLAG, 'O') IN ('O', 'M') AND NVL(WST2.SHIPMENTS_TYPE_FLAG, 'O') IN ('O', 'M') WITH READ ONLY

View Text - HTML Formatted

SELECT WST1.TRIP_ID
, WST1.NAME
, WST1.ARRIVE_AFTER_TRIP_ID
, WST2.NAME ARRIVE_AFTER_TRIP_NAME
, '_LA:WST1.STATUS_CODE:WSH_LOOKUPS:TRIP_STATUS:MEANING'
, WST1.VEHICLE_ITEM_ID
, '_KF:INV:MSTK:MSI'
, MSI.DESCRIPTION VEHICLE_DESCRIPTION
, WST1.VEHICLE_NUMBER
, '_LA:WST1.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WST1.ROUTING_INSTRUCTIONS
, WST1.CREATION_DATE
, WST1.CREATED_BY
, WST1.LAST_UPDATE_DATE
, WST1.LAST_UPDATED_BY
, WST1.LAST_UPDATE_LOGIN
, '_LA:WST1.PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WST1.CARRIER_ID
, WST1.ROUTE_ID
, WST1.VEHICLE_ORGANIZATION_ID
, MPA.ORGANIZATION_CODE
, ORG.NAME
, '_DF:WSH:WSH_TRIPS:WST1'
, WST1.VEHICLE_NUM_PREFIX
, WST1.SHIPMENTS_TYPE_FLAG
FROM WSH_TRIPS WST1
, WSH_TRIPS WST2
, MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS MPA
WHERE WST1.ARRIVE_AFTER_TRIP_ID = WST2.TRIP_ID(+)
AND WST1.VEHICLE_ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WST1.VEHICLE_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WST1.VEHICLE_ORGANIZATION_ID = MPA.ORGANIZATION_ID(+)
AND WST1.VEHICLE_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND '_SEC:WST1.VEHICLE_ORGANIZATION_ID' IS NOT NULL
AND NVL(WST1.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
AND NVL(WST2.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M') WITH READ ONLY