VIEW: APPS.PV_PG_INVITE_HEADERS_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')