OKC_RESP_PARTIES_VL

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
ROW_ID DOCUMENT_TYPE_CLASS RESP_PARTY_CODE INTENT INTERNAL_EXTERNAL_FLAG NAME ALTERNATE_NAME OBJECT_VERSION_NUMBER DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

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