VIEW: APPS.IEX_OKL_PAYMENTS_V

Source

View Text - Preformatted

SELECT HD.ID ,HD.CONSOLIDATED_INVOICE_NUMBER ,LN.SEQUENCE_NUMBER ,CNSLD.KHR_ID ,CNSLD.KLE_ID ,CN.CONTRACT_NUMBER ,CNSLD.ID ,SM.ID ,SM.NAME ,LT.NAME ,PY.PARTY_ID ,HD.IXX_ID ,CA.ACCOUNT_NUMBER ,SUBSTRB (PY.PARTY_NAME, 1, 50) ,CNSLD.RECEIVABLES_INVOICE_ID ,ARCASH.CASH_RECEIPT_ID ,ARCASH.RECEIPT_NUMBER ,ARAPP.RECEIVABLE_APPLICATION_ID ,ARAPP.AMOUNT_APPLIED ,ARAPP.APPLY_DATE ,ARCASH.CURRENCY_CODE ,ARAPP.REVERSAL_GL_DATE ,PMTSCH.PAYMENT_SCHEDULE_ID ,PMTSCH.TRX_NUMBER ,PMTSCH.CUSTOMER_TRX_ID ,PMTSCH.DUE_DATE ,PMTSCH.AMOUNT_DUE_ORIGINAL ,PMTSCH.AMOUNT_DUE_REMAINING ,PMTSCH.CLASS ,PMTSCH.STATUS ,PMTSCH.CREATED_BY ,PMTSCH.CREATION_DATE ,PMTSCH.LAST_UPDATED_BY ,PMTSCH.LAST_UPDATE_DATE ,PMTSCH.LAST_UPDATE_LOGIN ,ARCASH.PAYMENT_METHOD_DSP ,ARCASH.CUSTOMER_SITE_USE_ID ,ARCASH.RECEIPT_STATUS ,ARCASH.RECEIPT_STATUS_DSP FROM OKL_CNSLD_AR_HDRS_B HD, OKL_CNSLD_AR_LINES_B LN, OKL_INVC_LINE_TYPES_V LT, OKL_CNSLD_AR_STRMS_B CNSLD, AR_PAYMENT_SCHEDULES PMTSCH, AR_RECEIVABLE_APPLICATIONS ARAPP, AR_CASH_RECEIPTS_V ARCASH, OKL_STRM_TYPE_V SM, HZ_CUST_ACCOUNTS CA, HZ_PARTIES PY, OKC_K_HEADERS_B CN WHERE HD.ID = LN.CNR_ID AND LN.ID = CNSLD.LLN_ID AND CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID AND CNSLD.STY_ID = SM.ID AND HD.IXX_ID = CA.CUST_ACCOUNT_ID AND LN.ILT_ID = LT.ID (+) AND CA.PARTY_ID = PY.PARTY_ID AND CN.ID (+) = CNSLD.KHR_ID AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID AND PMTSCH.class = 'INV' AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID

View Text - HTML Formatted

SELECT HD.ID
, HD.CONSOLIDATED_INVOICE_NUMBER
, LN.SEQUENCE_NUMBER
, CNSLD.KHR_ID
, CNSLD.KLE_ID
, CN.CONTRACT_NUMBER
, CNSLD.ID
, SM.ID
, SM.NAME
, LT.NAME
, PY.PARTY_ID
, HD.IXX_ID
, CA.ACCOUNT_NUMBER
, SUBSTRB (PY.PARTY_NAME
, 1
, 50)
, CNSLD.RECEIVABLES_INVOICE_ID
, ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARAPP.RECEIVABLE_APPLICATION_ID
, ARAPP.AMOUNT_APPLIED
, ARAPP.APPLY_DATE
, ARCASH.CURRENCY_CODE
, ARAPP.REVERSAL_GL_DATE
, PMTSCH.PAYMENT_SCHEDULE_ID
, PMTSCH.TRX_NUMBER
, PMTSCH.CUSTOMER_TRX_ID
, PMTSCH.DUE_DATE
, PMTSCH.AMOUNT_DUE_ORIGINAL
, PMTSCH.AMOUNT_DUE_REMAINING
, PMTSCH.CLASS
, PMTSCH.STATUS
, PMTSCH.CREATED_BY
, PMTSCH.CREATION_DATE
, PMTSCH.LAST_UPDATED_BY
, PMTSCH.LAST_UPDATE_DATE
, PMTSCH.LAST_UPDATE_LOGIN
, ARCASH.PAYMENT_METHOD_DSP
, ARCASH.CUSTOMER_SITE_USE_ID
, ARCASH.RECEIPT_STATUS
, ARCASH.RECEIPT_STATUS_DSP
FROM OKL_CNSLD_AR_HDRS_B HD
, OKL_CNSLD_AR_LINES_B LN
, OKL_INVC_LINE_TYPES_V LT
, OKL_CNSLD_AR_STRMS_B CNSLD
, AR_PAYMENT_SCHEDULES PMTSCH
, AR_RECEIVABLE_APPLICATIONS ARAPP
, AR_CASH_RECEIPTS_V ARCASH
, OKL_STRM_TYPE_V SM
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKC_K_HEADERS_B CN
WHERE HD.ID = LN.CNR_ID
AND LN.ID = CNSLD.LLN_ID
AND CNSLD.RECEIVABLES_INVOICE_ID = PMTSCH.CUSTOMER_TRX_ID
AND CNSLD.STY_ID = SM.ID
AND HD.IXX_ID = CA.CUST_ACCOUNT_ID
AND LN.ILT_ID = LT.ID (+)
AND CA.PARTY_ID = PY.PARTY_ID
AND CN.ID (+) = CNSLD.KHR_ID
AND ARAPP.APPLIED_PAYMENT_SCHEDULE_ID = PMTSCH.PAYMENT_SCHEDULE_ID
AND PMTSCH.CLASS = 'INV'
AND ARAPP.CASH_RECEIPT_ID = ARCASH.CASH_RECEIPT_ID