Product: | PV - Partner Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PV_PG_INVITE_HEADERS_VL |
SELECT B.ROWID ROW_ID
, B.INVITE_HEADER_ID
, B.OBJECT_VERSION_NUMBER
, B.QP_LIST_HEADER_ID
, B.INVITE_TYPE_CODE
, B.INVITE_FOR_PROGRAM_ID
, B.INVITED_BY_PARTNER_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.EMAIL_CONTENT
, B.TRXN_EXTENSION_ID
FROM PV_PG_INVITE_HEADERS_B B
, PV_PG_INVITE_HEADERS_TL T
WHERE B.INVITE_HEADER_ID =T.INVITE_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')