VIEW: APPS.OKL_RCPT_CONSINV_BALANCES_UV

Source

View Text - Preformatted

SELECT HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER, HD.ID CONSOLIDATED_INVOICE_ID, HD.CURRENCY_CODE, HD.DATE_CONSOLIDATED INVOICE_DATE, LN.SEQUENCE_NUMBER CONSOLIDATED_LINE_NUMBER , cUst_trx.trx_Number AR_Invoice_Number, cUst_trx.Customer_trx_Id ar_Invoice_Id, cUst_trx.Org_Id Org_Id, cUst_trx_Lines.customer_trx_line_id, cUst_trx_Lines.line_number, cUst.Party_Name Customer_Name, cust.party_number CUSTOMER_NUMBER, acct.cUst_Account_Id Customer_acct_Id, acct.Account_Number Customer_ACCOUNT_Number, cUst_trx.Bill_To_Site_Use_Id Bill_To_Site_Use_Id, st.khr_id, CN.Contract_Number Contract_Number, CN.START_DATE CONTRACT_START_DATE, cUst_trx.InterFace_header_Attribute7 Asset_Number, cUst_trx.InterFace_header_Attribute9 stream_type, st.sty_id, st.kle_id, st.sel_id, pay_sch.amount_due_original amount_due_original, pay_sch.amount_due_remaining amount_due_remaining, pay_sch.tax_original, pay_sch.tax_remaining, pay_sch.due_date, pay_sch.trx_date trx_date, pay_sch.status FROM ra_Customer_trx_All cUst_trx, ra_Customer_trx_Lines_All cUst_trx_Lines, hz_cUst_Accounts acct, hz_Parties cUst, ar_Payment_Schedules_All Pay_sch, okl_cnsld_ar_strms_b st, OKL_CNSLD_AR_LINES_B LN, OKL_CNSLD_AR_HDRS_ALL_B HD, OKC_K_HEADERS_ALL_B CN WHERE cUst_trx.Bill_To_Customer_Id = acct.cUst_Account_Id AND acct.Party_Id = cUst.Party_Id AND cUst_trx.Customer_trx_Id = Pay_sch.Customer_trx_Id AND cUst_trx.Customer_trx_Id = cUst_trx_Lines.Customer_trx_Id AND cUst_trx_Lines.Line_Type = 'LINE' AND CN.ID = ST.KHR_ID AND pay_sch.class = 'INV' AND st.receivables_invoice_id = cust_trx.customer_trx_id AND LN.ID = ST.LLN_ID AND HD.ID = LN.CNR_ID

View Text - HTML Formatted

SELECT HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, HD.ID CONSOLIDATED_INVOICE_ID
, HD.CURRENCY_CODE
, HD.DATE_CONSOLIDATED INVOICE_DATE
, LN.SEQUENCE_NUMBER CONSOLIDATED_LINE_NUMBER
, CUST_TRX.TRX_NUMBER AR_INVOICE_NUMBER
, CUST_TRX.CUSTOMER_TRX_ID AR_INVOICE_ID
, CUST_TRX.ORG_ID ORG_ID
, CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID
, CUST_TRX_LINES.LINE_NUMBER
, CUST.PARTY_NAME CUSTOMER_NAME
, CUST.PARTY_NUMBER CUSTOMER_NUMBER
, ACCT.CUST_ACCOUNT_ID CUSTOMER_ACCT_ID
, ACCT.ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, CUST_TRX.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, ST.KHR_ID
, CN.CONTRACT_NUMBER CONTRACT_NUMBER
, CN.START_DATE CONTRACT_START_DATE
, CUST_TRX.INTERFACE_HEADER_ATTRIBUTE7 ASSET_NUMBER
, CUST_TRX.INTERFACE_HEADER_ATTRIBUTE9 STREAM_TYPE
, ST.STY_ID
, ST.KLE_ID
, ST.SEL_ID
, PAY_SCH.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, PAY_SCH.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING
, PAY_SCH.TAX_ORIGINAL
, PAY_SCH.TAX_REMAINING
, PAY_SCH.DUE_DATE
, PAY_SCH.TRX_DATE TRX_DATE
, PAY_SCH.STATUS
FROM RA_CUSTOMER_TRX_ALL CUST_TRX
, RA_CUSTOMER_TRX_LINES_ALL CUST_TRX_LINES
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
, OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_HDRS_ALL_B HD
, OKC_K_HEADERS_ALL_B CN
WHERE CUST_TRX.BILL_TO_CUSTOMER_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID
AND CUST_TRX.CUSTOMER_TRX_ID = PAY_SCH.CUSTOMER_TRX_ID
AND CUST_TRX.CUSTOMER_TRX_ID = CUST_TRX_LINES.CUSTOMER_TRX_ID
AND CUST_TRX_LINES.LINE_TYPE = 'LINE'
AND CN.ID = ST.KHR_ID
AND PAY_SCH.CLASS = 'INV'
AND ST.RECEIVABLES_INVOICE_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.ID = ST.LLN_ID
AND HD.ID = LN.CNR_ID