Product: | PV - Partner Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PV_GE_HISTORY_LOG_VL |
SELECT B.ROWID ROW_ID
, B.ENTITY_HISTORY_LOG_ID
, B.OBJECT_VERSION_NUMBER
, B.ARC_HISTORY_FOR_ENTITY_CODE
, B.HISTORY_FOR_ENTITY_ID
, B.MESSAGE_CODE
, B.HISTORY_CATEGORY_CODE
, B.PARTNER_ID
, B.ACCESS_LEVEL_FLAG
, B.INTERACTION_LEVEL
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.COMMENTS
FROM PV_GE_HISTORY_LOG_B B
, PV_GE_HISTORY_LOG_TL T
WHERE B.ENTITY_HISTORY_LOG_ID =T.ENTITY_HISTORY_LOG_ID
AND T.LANGUAGE = USERENV('LANG')