Product: | OKC - Contracts Core |
---|---|
Description: | View based on OKC_RESP_PARTIES_B and OKC_RESP_PARTIES_TL |
Implementation/DBA Data: | APPS.OKC_RESP_PARTIES_VL |
SELECT REPB.ROWID ROW_ID
, REPB.DOCUMENT_TYPE_CLASS DOCUMENT_TYPE_CLASS
, REPB.RESP_PARTY_CODE RESP_PARTY_CODE
, REPB.INTENT INTENT
, REPB.INTERNAL_EXTERNAL_FLAG INTERNAL_EXTERNAL_FLAG
, REPTL.NAME NAME
, REPTL.ALTERNATE_NAME ALTERNATE_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_RESP_PARTIES_B REPB
, OKC_RESP_PARTIES_TL REPTL
WHERE REPB.DOCUMENT_TYPE_CLASS = REPTL.DOCUMENT_TYPE_CLASS
AND REPB.RESP_PARTY_CODE = REPTL.RESP_PARTY_CODE
AND NVL(REPB.INTENT
, 'XXX') = NVL(REPTL.INTENT
, 'XXX')
AND REPTL.LANGUAGE = USERENV('LANG')