[Home] [Help]
View: OKC_REP_CONTACT_ROLES_VL
Product: | OKC - Contracts Core |
Description: | VL view on OKC_REP_CONTACT_ROLES_B and OKC_REP_CONTACT_ROLES_TL tables. |
Implementation/DBA Data: |
APPS.OKC_REP_CONTACT_ROLES_VL
|
View Text
SELECT RCRB.ROWID
, RCRB.CONTACT_ROLE_ID
, RCRTL.NAME
, RCRTL.DESCRIPTION
, RCRB.START_DATE
, RCRB.END_DATE
, RCRB.OBJECT_VERSION_NUMBER
, RCRB.CREATED_BY
, RCRB.CREATION_DATE
, RCRB.LAST_UPDATED_BY
, RCRB.LAST_UPDATE_DATE
, RCRB.LAST_UPDATE_LOGIN
FROM OKC_REP_CONTACT_ROLES_B RCRB
, OKC_REP_CONTACT_ROLES_TL RCRTL
WHERE RCRB.CONTACT_ROLE_ID = RCRTL.CONTACT_ROLE_ID
AND RCRTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
CONTACT_ROLE_ID |
NAME |
DESCRIPTION |
START_DATE |
END_DATE |
OBJECT_VERSION_NUMBER |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |