[Home] [Help]
View: PV_PARTNER_PROGRAM_TYPE_VL
View Text
SELECT PPTB.ROWID ROW_ID
, PPTB.PROGRAM_TYPE_ID
, PPTB.ACTIVE_FLAG
, PPTB.ENABLED_FLAG
, PPTB.OBJECT_VERSION_NUMBER
, PPTB.CREATION_DATE
, PPTB.CREATED_BY
, PPTB.LAST_UPDATE_DATE
, PPTB.LAST_UPDATED_BY
, PPTB.LAST_UPDATE_LOGIN
, PPTTL.PROGRAM_TYPE_NAME
, PPTTL.PROGRAM_TYPE_DESCRIPTION
FROM PV_PARTNER_PROGRAM_TYPE_B PPTB
, PV_PARTNER_PROGRAM_TYPE_TL PPTTL
WHERE PPTB.PROGRAM_TYPE_ID = PPTTL.PROGRAM_TYPE_ID
AND PPTTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PROGRAM_TYPE_ID |
ACTIVE_FLAG |
ENABLED_FLAG |
OBJECT_VERSION_NUMBER |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
PROGRAM_TYPE_NAME |
PROGRAM_TYPE_DESCRIPTION |