View: FTE_ORDER_HISTORY_V

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