[Home] [Help]
View: OKC_DEL_RESP_PARTIES_V
Product: | OKC - Contracts Core |
Description: | View based on OKC_DEL_RESP_PARTIES_B and OKC_DEL_RESP_PARTIES_TL |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT REPB.ROWID ROW_ID
, REPB.RESP_PARTY_CODE RESP_PARTY_CODE
, REPB.INTENT INTENT
, REPB.INTERNAL_EXTERNAL_FLAG INTERNAL_EXTERNAL_FLAG
, REPTL.NAME NAME
, REPB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REPTL.DESCRIPTION DESCRIPTION
, REPB.CREATED_BY CREATED_BY
, REPB.CREATION_DATE CREATION_DATE
, REPB.LAST_UPDATED_BY LAST_UPDATED_BY
, REPB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, REPB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_DEL_RESP_PARTIES_TL REPTL
, OKC_DEL_RESP_PARTIES_B REPB
WHERE REPB.RESP_PARTY_CODE = REPTL.RESP_PARTY_CODE
AND REPTL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
RESP_PARTY_CODE |
INTENT |
INTERNAL_EXTERNAL_FLAG |
NAME |
OBJECT_VERSION_NUMBER |
DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |