View: OKL_EBIZ_KHEADERS_V

Product:	OKL - Lease and Finance Management
Description:	Find grid for eBusiness Integration.This grid is shown of Contracts tab in eBusiness,Purpose of this view is to filter out lease contracts,based on subclass_code='LEASE'
Implementation/DBA Data:	APPS.OKL_EBIZ_KHEADERS_V

View Text

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
, HP.PARTY_NAME 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
, 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
FROM HZ_PARTIES HP
, HZ_CUST_ACCOUNTS CA
, 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
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.CUST_ACCT_ID = CA.CUST_ACCOUNT_ID
AND CHRB.ID = VPUV.CONTRACT_ID (+)
AND CA.PARTY_ID = HP.PARTY_ID
AND CHRB.SCS_CODE = 'LEASE'

Columns