[Home] [Help]
View: PA_RP_TYPES_VL
Product: | PA - Projects |
Description: | This view shows Types of Reporting Pack |
Implementation/DBA Data: |
APPS.PA_RP_TYPES_VL
|
View Text
SELECT B.RP_TYPE_ID
, T.RP_TYPE_NAME
, B.CONC_PROG_SHORT_NAME
, B.SEEDED_DT_CODE
, B.DATA_ENGINE_CLASS_NAME
, B.RP_WORKER_CLASS_NAME
, B.RP_MAIN_CLASS_NAME
, B.OBJECT_VERSION_NUMBER
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
FROM PA_RP_TYPES_B B
, PA_RP_TYPES_TL T
WHERE T.RP_TYPE_ID = B.RP_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
RP_TYPE_ID |
RP_TYPE_NAME |
CONC_PROG_SHORT_NAME |
SEEDED_DT_CODE |
DATA_ENGINE_CLASS_NAME |
RP_WORKER_CLASS_NAME |
RP_MAIN_CLASS_NAME |
OBJECT_VERSION_NUMBER |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
LAST_UPDATE_LOGIN |