[Home] [Help]
View: WSHFV_DELIVERY_ASSIGNMENTS
View Text
SELECT WDA.DELIVERY_ASSIGNMENT_ID
, WDA.DELIVERY_ID
, WND1.NAME DELIVERY_NAME
, WDA.DELIVERY_DETAIL_ID
, WDA.PARENT_DELIVERY_DETAIL_ID
, WDA.CREATION_DATE
, WDA.CREATED_BY
, WDA.LAST_UPDATE_DATE
, WDA.LAST_UPDATED_BY
, '_LA:WDA.ACTIVE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
FROM WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_NEW_DELIVERIES WND1
, WSH_DELIVERY_DETAILS WDD
WHERE WDA.DELIVERY_ID=WND1.DELIVERY_ID(+)
AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY
Columns
Name |
DELIVERY_ASSIGNMENT_ID |
DELIVERY_ID |
DELIVERY_NAME |
DELIVERY_DETAIL_ID |
PARENT_DELIVERY_DETAIL_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
"_LA:ACTIVE_FLAG" |