VIEW: APPS.OKC_RESP_PARTIES_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')