View: OKL_CS_PAY_LINE_DTL_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_PAY_LINE_DTL_UV

View Text

SELECT CHR.ID CHR_ID
, TPL.ID TPL_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, LOOK.MEANING LINE_TYPE
, TAS.ASSET_NUMBER ASSET_NUMBER
, STYT.NAME STREAM_TYPE
, TPL.AMOUNT INVOICE_AMOUNT
, VND_PROG.CONTRACT_NUMBER VENDOR_PROGRAM
, PRI_LABEL.PARTY_NAME PRIVATE_LABEL
, OKL_CS_LC_CONTRACT_PVT.GET_AP_LINE_TAX(APINV.INVOICE_ID
, TPL.LINE_NUMBER) TAX_AMOUNT
, CUST.PARTY_NAME CUSTOMER
, LOOK1.MEANING FUNDING_TYPE
, DECODE(LSEB.LTY_CODE
, 'ITEM'
, OSI2.NAME
, OSI1.NAME) ITEM_NAME
, IPTL.NAME INSURANCE_PRODUCT
, IPC.POLICY_NUMBER POLICY_NUMBER
, CIN.CURRENCY_CODE CURRENCY
, TPL.CNSLD_AP_INV_ID
, APINV.INVOICE_ID
FROM OKL_CNSLD_AP_INVS_ALL CIN
, OKL_TXL_AP_INV_LNS_ALL_B TPL
, AP_INVOICES_ALL APINV
, OKL_STRM_TYPE_TL STYT
, OKC_K_HEADERS_ALL_B CHR
, OKL_K_HEADERS KHR
, OKC_K_HEADERS_ALL_B VND_PROG
, OKC_K_PARTY_ROLES_B CPL
, HZ_PARTIES PRI_LABEL
, OKL_TXL_ASSETS_B TAS
, OKC_K_LINES_B CLE
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSE
, OKC_LINE_STYLES_B LSEB
, FND_LOOKUPS LOOK
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES CUST
, FND_LOOKUPS LOOK1
, OKC_K_ITEMS CIM
, OKC_K_ITEMS CIMB
, OKX_SYSTEM_ITEMS_V OSI1
, OKL_INS_POLICIES_ALL_B IPC
, OKL_INS_PRODUCTS_TL IPTL
, FND_APPLICATION APP
, OKX_SYSTEM_ITEMS_V OSI2
WHERE TPL.CNSLD_AP_INV_ID = CIN.CNSLD_AP_INV_ID
AND CIN.CNSLD_AP_INV_ID = TO_NUMBER(APINV.REFERENCE_KEY1)
AND APINV.APPLICATION_ID = APP.APPLICATION_ID
AND APP.APPLICATION_SHORT_NAME = 'OKL'
AND APINV.PRODUCT_TABLE = 'OKL_CNSLD_AP_INVS_ALL'
AND APINV.VENDOR_SITE_ID = CIN.IPVS_ID
AND TPL.STY_ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')
AND TPL.KHR_ID = CHR.ID
AND CHR.ID = KHR.ID
AND KHR.KHR_ID = VND_PROG.ID(+)
AND VND_PROG.SCS_CODE(+) = 'PROGRAM'
AND CLE.CLE_ID(+) = TPL.KLE_ID
AND CLEB.LSE_ID = LSEB.ID(+)
AND LSEB.LTY_CODE(+) = 'ITEM'
AND CLEB.DNZ_CHR_ID(+)= CLE.DNZ_CHR_ID
AND CIMB.CLE_ID(+) = CLEB.ID
AND CIMB.DNZ_CHR_ID(+) = CLEB.DNZ_CHR_ID
AND CLEB.CLE_ID(+) = CLE.CLE_ID
AND CLE.LSE_ID = LSE.ID(+)
AND LSE.LTY_CODE = LOOK.LOOKUP_CODE(+)
AND (LSE.LTY_CODE IS NULL OR LSE.LTY_CODE IN ('FEE'
, 'SOLD_SERVICE'
, 'FIXED_ASSET'
, 'INSURANCE'))
AND LOOK.LOOKUP_TYPE(+) = 'OKC_LINE_TYPE'
AND CLE.ID = TAS.KLE_ID(+)
AND TAS.DNZ_KHR_ID(+) = CLE.DNZ_CHR_ID
AND CHR.ID = CPL.DNZ_CHR_ID(+)
AND CPL.RLE_CODE(+) = 'PRIVATE_LABEL'
AND CPL.OBJECT1_ID1 = PRI_LABEL.PARTY_ID(+)
AND CHR.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = CUST.PARTY_ID
AND TPL.FUNDING_REFERENCE_TYPE_CODE=LOOK1.LOOKUP_CODE(+)
AND LOOK1.LOOKUP_TYPE(+) = 'OKL_FUNDING_TYPE'
AND CIM.CLE_ID(+) = CLE.ID
AND CIM.DNZ_CHR_ID(+) = CLE.DNZ_CHR_ID
AND OSI1.ID1(+) = CIM.OBJECT1_ID1
AND OSI1.ID2(+) = CIM.OBJECT1_ID2
AND OSI2.ID1(+) = CIMB.OBJECT1_ID1
AND OSI2.ID2(+) = CIMB.OBJECT1_ID2
AND IPC.KHR_ID(+) = CHR.ID
AND IPC.IPT_ID = IPTL.ID(+)
AND IPC.IPY_TYPE(+) = 'LEASE_POLICY'
AND IPC.QUOTE_YN(+) ='N'
AND IPTL.LANGUAGE(+) = USERENV('LANG')

Columns