[Home] [Help]
View: FTE_ORDER_HISTORY_V
Product: | FTE - Transportation Execution |
Description: | Internal view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT POH.OBJECT_ID
, POH.OBJECT_ID2
, POH.OBJECT_TYPE_CODE
, POH.SEQUENCE_NUM
, POH.ACTION_TYPE
, LK1.MEANING
, POH.ACTION_DATE
, POH.ACTION_USER_ID
, POH.ACTION_NOTE
, HZP.PARTY_NAME
, USR.EMAIL_ADDRESS
FROM POM_ACTION_HISTORY POH
, HZ_PARTIES HZP
, FND_USER USR
, FND_LOOKUP_VALUES LK1
, POM_ORDER_HEADERS PO
WHERE POH.ACTION_USER_ID = HZP.PARTY_ID(+)
AND POH.OBJECT_TYPE_CODE = 'LOGISTICS'
AND POH.ACTION_TYPE = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE = 'FTE_ORDER_ACTION'
AND LK1.LANGUAGE = NVL(PO.BUYER_LANG_CODE
, 'US')
AND POH.OBJECT_ID = PO.ORDER_NUMBER
AND POH.ACTION_USER_ID = USR.CUSTOMER_ID(+) ORDER BY POH.SEQUENCE_NUM
Columns
Name |
OBJECT_ID |
OBJECT_ID2 |
OBJECT_TYPE_CODE |
SEQUENCE_NUM |
ACTION_TYPE |
MEANING |
ACTION_DATE |
ACTION_USER_ID |
ACTION_NOTE |
PARTY_NAME |
EMAIL_ADDRESS |