VIEW: APPS.OKL_EBIZ_KHEADERS_V

Source

View Text - Preformatted

SELECT CHRB.ROWID ROW_ID, CHRB.ID CONTRACT_ID, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STS.MEANING STATUS_MEANING, CHRB.SCS_CODE SUBCLASS_CODE, SC.MEANING subclass_meaning, CHRB.QCL_ID QCL_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, PDT.NAME OKL_PRODUCT, VPUV.PROGRAM_NAME PROGRAM_AGREEMENT, ( SELECT hp.party_name FROM okc_k_party_roles_b okcrole, okc_k_headers_b khr, hz_parties hp WHERE okcrole.dnz_chr_id = khr.id AND okcrole.rle_code = 'PRIVATE_LABEL' AND okcrole.object1_id1 = hp.party_id AND okcrole.object1_id2 = '#' AND kHR.id = chrb.id ) PRIVATE_LABEL, KHR.SYNDICATABLE_YN SYNDICATABLE_YN, KHR.ACCEPTED_DATE ACCEPTED_DATE, FND.MEANING BOOK_CLASS, CHRB.CURRENCY_CODE CURRENCY_CODE, CHRB.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN, CHRB.PRE_PAY_REQ_YN PRE_PAY_REQ_YN, CHRB.CUST_PO_NUMBER CUST_PO_NUMBER, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION, CHRB.DPAS_RATING DPAS_RATING, CHRT.COGNOMEN KNOWN_AS, CHRB.TEMPLATE_YN TEMPLATE_YN, CHRB.TEMPLATE_USED TEMPLATE_USED, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS, CHRB.DATE_SIGNED DATE_SIGNED, CHRB.DATE_TERMINATED DATE_TERMINATED, CHRB.TRN_CODE TRN_CODE, CHRB.START_DATE START_DATE, CHRB.END_DATE END_DATE, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID, OKL_CS_LC_CONTRACT_PVT.get_k_access_level(chrb.id, chrb.scs_code) user_access_level, chrb.application_id application_id, khr.securitized_code, CHRB.CREATED_BY CREATED_BY, CHRB.CREATION_DATE CREATION_DATE, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, iex_lkup.meaning delinquency_status, iex.collections_action FROM OKL_K_HEADERS KHR,OKL_K_VENDOR_PROGRAMS_UV VPUV,OKL_PRODUCTS PDT,FND_LOOKUPS FND,OKC_STATUSES_TL STS,OKC_SUBCLASSES_TL SC,OKC_K_HEADERS_B CHRB,OKC_K_HEADERS_TL CHRT,IEX_CASE_OBJECTS IEX,IEX_LOOKUPS_V IEX_LKUP WHERE CHRB.ID = CHRT.ID AND CHRT.LANGUAGE = USERENV('LANG') AND KHR.id = CHRB.id AND sts.code = chrb.sts_code AND sts.language = USERENV('LANG') AND sts.code !='ABANDONED' AND fnd.lookup_type = 'OKL_BOOK_CLASS' AND fnd.lookup_code = khr.deal_type AND sc.code = chrb.scs_code AND sc.language = USERENV('LANG') AND khr.pdt_id (+) = pdt.id AND chrb.id = vpuv.contract_id (+) AND chrb.scs_code = 'LEASE' and chrb.cust_acct_id is not null AND iex.object_id(+) = chrb.ID AND iex_lkup.lookup_type(+) = 'IEX_DELINQUENCY_STATE' AND iex_lkup.enabled_flag(+) = 'Y' AND iex_lkup.lookup_code(+) = iex.delinquency_status

View Text - HTML Formatted

SELECT CHRB.ROWID ROW_ID
, CHRB.ID CONTRACT_ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STS.MEANING STATUS_MEANING
, CHRB.SCS_CODE SUBCLASS_CODE
, SC.MEANING SUBCLASS_MEANING
, CHRB.QCL_ID QCL_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, PDT.NAME OKL_PRODUCT
, VPUV.PROGRAM_NAME PROGRAM_AGREEMENT
, ( SELECT HP.PARTY_NAME
FROM OKC_K_PARTY_ROLES_B OKCROLE
, OKC_K_HEADERS_B KHR
, HZ_PARTIES HP
WHERE OKCROLE.DNZ_CHR_ID = KHR.ID
AND OKCROLE.RLE_CODE = 'PRIVATE_LABEL'
AND OKCROLE.OBJECT1_ID1 = HP.PARTY_ID
AND OKCROLE.OBJECT1_ID2 = '#'
AND KHR.ID = CHRB.ID ) PRIVATE_LABEL
, KHR.SYNDICATABLE_YN SYNDICATABLE_YN
, KHR.ACCEPTED_DATE ACCEPTED_DATE
, FND.MEANING BOOK_CLASS
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, CHRB.PRE_PAY_REQ_YN PRE_PAY_REQ_YN
, CHRB.CUST_PO_NUMBER CUST_PO_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRB.DPAS_RATING DPAS_RATING
, CHRT.COGNOMEN KNOWN_AS
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.TEMPLATE_USED TEMPLATE_USED
, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.TRN_CODE TRN_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, OKL_CS_LC_CONTRACT_PVT.GET_K_ACCESS_LEVEL(CHRB.ID
, CHRB.SCS_CODE) USER_ACCESS_LEVEL
, CHRB.APPLICATION_ID APPLICATION_ID
, KHR.SECURITIZED_CODE
, CHRB.CREATED_BY CREATED_BY
, CHRB.CREATION_DATE CREATION_DATE
, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY
, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IEX_LKUP.MEANING DELINQUENCY_STATUS
, IEX.COLLECTIONS_ACTION
FROM OKL_K_HEADERS KHR
, OKL_K_VENDOR_PROGRAMS_UV VPUV
, OKL_PRODUCTS PDT
, FND_LOOKUPS FND
, OKC_STATUSES_TL STS
, OKC_SUBCLASSES_TL SC
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, IEX_CASE_OBJECTS IEX
, IEX_LOOKUPS_V IEX_LKUP
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND KHR.ID = CHRB.ID
AND STS.CODE = CHRB.STS_CODE
AND STS.LANGUAGE = USERENV('LANG')
AND STS.CODE !='ABANDONED'
AND FND.LOOKUP_TYPE = 'OKL_BOOK_CLASS'
AND FND.LOOKUP_CODE = KHR.DEAL_TYPE
AND SC.CODE = CHRB.SCS_CODE
AND SC.LANGUAGE = USERENV('LANG')
AND KHR.PDT_ID (+) = PDT.ID
AND CHRB.ID = VPUV.CONTRACT_ID (+)
AND CHRB.SCS_CODE = 'LEASE'
AND CHRB.CUST_ACCT_ID IS NOT NULL
AND IEX.OBJECT_ID(+) = CHRB.ID
AND IEX_LKUP.LOOKUP_TYPE(+) = 'IEX_DELINQUENCY_STATE'
AND IEX_LKUP.ENABLED_FLAG(+) = 'Y'
AND IEX_LKUP.LOOKUP_CODE(+) = IEX.DELINQUENCY_STATUS