[Home] [Help]
| Product: | WSH - Shipping Execution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT WFTH.TRANSACTION_ID
, FLV3.MEANING
, FLV2.MEANING
, WFTH.SEND_RECEIVE_DATE
, FLV1.MEANING
, FLV4.MEANING
, WFTH.TRANSACTION_SEQUENCE
, WFTH.LAST_SEND_DATE
, WFTH.PROCESSED_DATE
, WFTH.ECX_MESSAGE_ID
, WFTH.ECX_TP_ID
, WFTH.FTE_JOB_ID
, WFTH.DELIVERY_ID
, WFTH.ATTRIBUTE_CATEGORY
, WFTH.ATTRIBUTE1
, WFTH.ATTRIBUTE2
, WFTH.ATTRIBUTE3
, WFTH.ATTRIBUTE4
, WFTH.ATTRIBUTE5
, WFTH.ATTRIBUTE6
, WFTH.ATTRIBUTE7
, WFTH.ATTRIBUTE8
, WFTH.ATTRIBUTE9
, WFTH.ATTRIBUTE10
, WFTH.ATTRIBUTE11
, WFTH.ATTRIBUTE12
, WFTH.ATTRIBUTE13
, WFTH.ATTRIBUTE14
, WFTH.ATTRIBUTE15
, WFTH.TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE_LKUP
, WFTH. TRANSACTION_STATUS TRANSACTION_STATUS_LKUP
, WFTH.ACTION_TYPE ACTION_TYPE_LKUP
, WFTH.TRANSACTION_DIRECTION TRANSACTION_DIRECTION_LKUP
, WFTH.CORRELATION_ID
FROM WSH_FTE_TRANSACTION_HISTORY WFTH
, FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, FND_LOOKUP_VALUES_VL FLV3
, FND_LOOKUP_VALUES_VL FLV4
WHERE FLV1.LOOKUP_TYPE = 'WSH_FTE_TXN_ACTION_TYPE'
AND FLV1.LOOKUP_CODE = WFTH.ACTION_TYPE
AND FLV2.LOOKUP_TYPE = 'WSH_FTE_TXN_STATUS'
AND FLV2.LOOKUP_CODE = WFTH. TRANSACTION_STATUS
AND FLV3.LOOKUP_TYPE(+) = 'WSH_FTE_TXN_TYPE'
AND FLV3.LOOKUP_CODE(+) = WFTH.TRANSACTION_SUBTYPE
AND FLV4.LOOKUP_TYPE = 'WSH_FTE_TXN_DIRECTION'
AND FLV4.LOOKUP_CODE = WFTH.TRANSACTION_DIRECTION