View: PA_RP_DEFINITIONS_VL

Product:	PA - Projects
Description:	This view provides definitions of Reporting Pack
Implementation/DBA Data:	APPS.PA_RP_DEFINITIONS_VL

View Text

SELECT B.ROWID ROW_ID
, B.RP_ID
, B.RP_TYPE_ID
, B.DT_PROCESS_DATE
, B.RP_FILE_ID
, T.RP_NAME
, T.EMAIL_TITLE
, T.EMAIL_BODY
, T.DESCRIPTIONS
, B.OBJECT_VERSION_NUMBER
, B.TEMPLATE_START_DATE
, B.TEMPLATE_END_DATE
, B.OBSOLETE_FLAG
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
FROM PA_RP_DEFINITIONS_B B
, PA_RP_DEFINITIONS_TL T
WHERE T.RP_ID = B.RP_ID
AND T.LANGUAGE = USERENV('LANG')

Columns