VIEW: APPS.OKL_RECEIPT_APPLICATIONS_UV

Source

View Text - Preformatted

SELECT ArcAsh.Cash_Receipt_Id, ArcAsh.Receipt_Number, aRap.Applied_Customer_trx_Id, DECODE(cUst_trx_Lines.InterFace_Line_Context,'OKL_CONTRACTS', Nvl(cUst_trx_Lines.InterFace_Line_Attribute1, Pay_sch.trx_Number), Pay_sch.trx_Number) Invoice_Number, 'LINE' Line_Type, arl.Amount Line_Applied, arl.Tax Tax_Applied, cUst_trx_Lines.Amount_Due_RemainIng Line_Balance, (SELECT Nvl(SUM(Amount_Due_RemainIng),0) FROM ra_Customer_trx_Lines_All Tax_Lines WHERE Tax_Lines.Link_To_cUst_trx_Line_Id = cUst_trx_Lines.Customer_trx_Line_Id AND Tax_Lines.Line_Type = 'TAX') Tax_Balance, DECODE(cUst_trx_Lines.InterFace_Line_Context,'OKL_CONTRACTS', Nvl2(cUst_trx_Lines.InterFace_Line_Attribute1, (SELECT ln.Sequence_Number FROM Okl_cnsld_ar_strms_b st, Okl_cnsld_ar_Lines_b ln WHERE st.Receivables_Invoice_Id = cUst_trx_Lines.Customer_trx_Id AND ln.Id = st.lln_Id),To_char(cUst_trx_Lines.Line_Number)), To_char(cUst_trx_Lines.Line_Number)) Line_Number, cUst_trx_Lines.Customer_trx_Line_Id, aRap.Apply_Date, Pay_sch.trx_Date Invoice_Date, Pay_sch.Due_Date, DECODE(cUst_trx_Lines.InterFace_Line_Context,'OKL_CONTRACTS', cUst_trx_Lines.InterFace_Line_Attribute7,'OKL_MANUAL', cUst_trx_Lines.InterFace_Line_Attribute7, NULL) Asset_Number, DECODE(cUst_trx_Lines.InterFace_Line_Context,'OKL_CONTRACTS', cUst_trx_Lines.InterFace_Line_Attribute9,'OKL_MANUAL', cUst_trx_Lines.InterFace_Line_Attribute9, NULL) Stream_Type, DECODE(cUst_trx_Lines.InterFace_Line_Context,'OKL_CONTRACTS', cUst_trx_Lines.InterFace_Line_Attribute6,'OKL_MANUAL', cUst_trx_Lines.InterFace_Line_Attribute6, NULL) Contract_Number, aRap.gl_Date, Nvl(aRap.tRans_To_Receipt_Rate,1) tRans_To_Receipt_Rate, Pay_sch.Invoice_Currency_Code, aRap.Receivable_Application_Id, (arl.Amount + arl.Tax ) LINE_TAX_APPLIED, (cUst_trx_Lines.Amount_Due_RemainIng + (SELECT Nvl(SUM(Amount_Due_RemainIng),0) FROM ra_Customer_trx_Lines_All Tax_Lines WHERE Tax_Lines.Link_To_cUst_trx_Line_Id = cUst_trx_Lines.Customer_trx_Line_Id AND Tax_Lines.Line_Type = 'TAX') ) LINE_TAX_BALANCE FROM ar_Cash_Receipts_All ArcAsh, ar_Receivable_Applications_All aRap, ar_Activity_Details arl, ar_Payment_Schedules_All Pay_sch, ra_Customer_trx_Lines_All cUst_trx_Lines WHERE ArcAsh.Cash_Receipt_Id = aRap.Cash_Receipt_Id AND aRap.Status = 'APP' AND aRap.Display = 'Y' AND aRap.Receivable_Application_Id = arl.Source_Id AND arl.Source_Table = 'RA' AND arl.Customer_trx_Line_Id = cUst_trx_Lines.Customer_trx_Line_Id AND cUst_trx_Lines.Line_Type = 'LINE' AND Pay_sch.Payment_Schedule_Id = aRap.Applied_Payment_Schedule_Id UNION ALL SELECT ArcAsh.Cash_Receipt_Id, ArcAsh.Receipt_Number, aRap.Applied_Customer_trx_Id, DECODE(cUst_trx.InterFace_Header_Context,'OKL_CONTRACTS', Nvl((SELECT ln.InterFace_Line_Attribute1 FROM ra_Customer_trx_Lines_All ln WHERE ln.Customer_trx_Id = cUst_trx.Customer_trx_Id AND ln.Line_Type = 'LINE' AND ROWNUM < 2),Pay_sch.trx_Number), Pay_sch.trx_Number) Invoice_Number, 'LINE' Line_Type, aRap.Line_Applied, aRap.Tax_Applied, Pay_sch.Amount_Line_Items_RemainIng Line_Balance, Pay_sch.Tax_RemainIng Tax_Balance, DECODE(Cust_trx.InterFace_Header_Context,'OKL_CONTRACTS', Nvl2((SELECT ln.InterFace_Line_Attribute1 FROM ra_Customer_trx_Lines_All ln WHERE ln.Customer_trx_Id = cUst_trx.Customer_trx_Id AND ln.Line_Type = 'LINE' AND ROWNUM < 2), (SELECT ln.Sequence_Number FROM Okl_cnsld_ar_strms_b st, Okl_cnsld_ar_Lines_b ln WHERE st.Receivables_Invoice_Id = cUst_trx.Customer_trx_Id AND ln.Id = st.lln_Id),null),null) LINE_NUMBER, NULL, aRap.Apply_Date, Pay_sch.trx_Date Invoice_Date, Pay_sch.Due_Date, DECODE(cUst_trx.InterFace_Header_Context,'OKL_CONTRACTS', Nvl2((SELECT ln.InterFace_Line_Attribute1 FROM ra_Customer_trx_Lines_All ln WHERE ln.Customer_trx_Id = cUst_trx.Customer_trx_Id AND ln.Line_Type = 'LINE' AND ROWNUM < 2),cUst_trx.InterFace_Header_Attribute7, NULL), NULL) Asset_Number, DECODE(cUst_trx.InterFace_Header_Context,'OKL_CONTRACTS', Nvl2((SELECT ln.InterFace_Line_Attribute1 FROM ra_Customer_trx_Lines_All ln WHERE ln.Customer_trx_Id = cUst_trx.Customer_trx_Id AND ln.Line_Type = 'LINE' AND ROWNUM < 2),cUst_trx.InterFace_Header_Attribute9, NULL), NULL) Stream_Type, DECODE(cUst_trx.InterFace_Header_Context,'OKL_CONTRACTS', Nvl2((SELECT ln.InterFace_Line_Attribute1 FROM ra_Customer_trx_Lines_All ln WHERE ln.Customer_trx_Id = cUst_trx.Customer_trx_Id AND ln.Line_Type = 'LINE' AND ROWNUM < 2),cUst_trx.InterFace_Header_Attribute6, NULL), NULL) Contract_Number, aRap.gl_Date, Nvl(aRap.tRans_To_Receipt_Rate,1) tRans_To_Receipt_Rate, Pay_sch.Invoice_Currency_Code, aRap.Receivable_Application_Id, (aRap.Line_Applied + aRap.Tax_Applied) LINE_TAX_APPLIED, (Pay_sch.Amount_Line_Items_RemainIng + Pay_sch.Tax_RemainIng ) LINE_TAX_BALANCE FROM ar_Cash_Receipts_All ArcAsh, ar_Receivable_Applications_All aRap, ar_Payment_Schedules_All Pay_sch, ra_Customer_trx_All cUst_trx WHERE ArcAsh.Cash_Receipt_Id = aRap.Cash_Receipt_Id AND aRap.Status = 'APP' AND aRap.Display = 'Y' AND Pay_sch.Payment_Schedule_Id = aRap.Applied_Payment_Schedule_Id AND Pay_sch.Customer_trx_Id = cUst_trx.Customer_trx_Id AND NOT EXISTS (SELECT 'X' FROM ar_Activity_Details arl WHERE arl.Source_Id = aRap.Receivable_Application_Id AND arl.Source_Table = 'RA') UNION ALL SELECT ArcAsh.Cash_Receipt_Id, ArcAsh.Receipt_Number, aRap.Applied_Customer_trx_Id, Pay_sch.trx_Number Invoice_Number, 'FREIGHT' Line_Type, aRap.Freight_Applied Line_Applied, 0 Tax_Applied, Pay_sch.Freight_RemainIng Line_Balance, 0 Tax_Balance, NULL Line_Number, NULL Customer_trx_Line_Id, aRap.Apply_Date, Pay_sch.trx_Date Invoice_Date, Pay_sch.Due_Date, NULL Asset_Number, NULL Stream_Type, NULL Contract_Number, aRap.gl_Date, Nvl(aRap.tRans_To_Receipt_Rate,1) tRans_To_Receipt_Rate, Pay_sch.Invoice_Currency_Code, aRap.Receivable_Application_Id, aRap.Freight_Applied Line_tax_Applied, Pay_sch.Freight_RemainIng line_tax_balance FROM ar_Cash_Receipts_All ArcAsh, ar_Receivable_Applications_All aRap, ar_Payment_Schedules_All Pay_sch WHERE ArcAsh.Cash_Receipt_Id = aRap.Cash_Receipt_Id AND aRap.Status = 'APP' AND aRap.Display = 'Y' AND Pay_sch.Payment_Schedule_Id = aRap.Applied_Payment_Schedule_Id AND aRap.Freight_Applied > 0 UNION ALL SELECT ArcAsh.Cash_Receipt_Id, ArcAsh.Receipt_Number, aRap.Applied_Customer_trx_Id, Pay_sch.trx_Number Invoice_Number, 'CHARGES' Line_Type, aRap.Receivables_Charges_Applied Line_Applied, 0 Tax_Applied, Pay_sch.Receivables_Charges_RemainIng Line_Balance, 0 Tax_Balance, NULL Line_Number, NULL Customer_trx_Line_Id, aRap.Apply_Date, Pay_sch.trx_Date Invoice_Date, Pay_sch.Due_Date, NULL Asset_Number, NULL Stream_Type, NULL Contract_Number, aRap.gl_Date, Nvl(aRap.tRans_To_Receipt_Rate,1) tRans_To_Receipt_Rate, Pay_sch.Invoice_Currency_Code, aRap.Receivable_Application_Id, aRap.Receivables_Charges_Applied line_Tax_Applied, Pay_sch.Receivables_Charges_RemainIng line_tax_balance FROM ar_Cash_Receipts_All ArcAsh, ar_Receivable_Applications_All aRap, ar_Payment_Schedules_All Pay_sch WHERE ArcAsh.Cash_Receipt_Id = aRap.Cash_Receipt_Id AND aRap.Status = 'APP' AND aRap.Display = 'Y' AND Pay_sch.Payment_Schedule_Id = aRap.Applied_Payment_Schedule_Id AND aRap.Receivables_Charges_Applied > 0

View Text - HTML Formatted

SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARAP.APPLIED_CUSTOMER_TRX_ID
, DECODE(CUST_TRX_LINES.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, NVL(CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE1
, PAY_SCH.TRX_NUMBER)
, PAY_SCH.TRX_NUMBER) INVOICE_NUMBER
, 'LINE' LINE_TYPE
, ARL.AMOUNT LINE_APPLIED
, ARL.TAX TAX_APPLIED
, CUST_TRX_LINES.AMOUNT_DUE_REMAINING LINE_BALANCE
, (SELECT NVL(SUM(AMOUNT_DUE_REMAINING)
, 0)
FROM RA_CUSTOMER_TRX_LINES_ALL TAX_LINES
WHERE TAX_LINES.LINK_TO_CUST_TRX_LINE_ID = CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID
AND TAX_LINES.LINE_TYPE = 'TAX') TAX_BALANCE
, DECODE(CUST_TRX_LINES.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, NVL2(CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE1
, (SELECT LN.SEQUENCE_NUMBER
FROM OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
WHERE ST.RECEIVABLES_INVOICE_ID = CUST_TRX_LINES.CUSTOMER_TRX_ID
AND LN.ID = ST.LLN_ID)
, TO_CHAR(CUST_TRX_LINES.LINE_NUMBER))
, TO_CHAR(CUST_TRX_LINES.LINE_NUMBER)) LINE_NUMBER
, CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID
, ARAP.APPLY_DATE
, PAY_SCH.TRX_DATE INVOICE_DATE
, PAY_SCH.DUE_DATE
, DECODE(CUST_TRX_LINES.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE7
, 'OKL_MANUAL'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE7
, NULL) ASSET_NUMBER
, DECODE(CUST_TRX_LINES.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE9
, 'OKL_MANUAL'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE9
, NULL) STREAM_TYPE
, DECODE(CUST_TRX_LINES.INTERFACE_LINE_CONTEXT
, 'OKL_CONTRACTS'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE6
, 'OKL_MANUAL'
, CUST_TRX_LINES.INTERFACE_LINE_ATTRIBUTE6
, NULL) CONTRACT_NUMBER
, ARAP.GL_DATE
, NVL(ARAP.TRANS_TO_RECEIPT_RATE
, 1) TRANS_TO_RECEIPT_RATE
, PAY_SCH.INVOICE_CURRENCY_CODE
, ARAP.RECEIVABLE_APPLICATION_ID
, (ARL.AMOUNT + ARL.TAX ) LINE_TAX_APPLIED
, (CUST_TRX_LINES.AMOUNT_DUE_REMAINING + (SELECT NVL(SUM(AMOUNT_DUE_REMAINING)
, 0)
FROM RA_CUSTOMER_TRX_LINES_ALL TAX_LINES
WHERE TAX_LINES.LINK_TO_CUST_TRX_LINE_ID = CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID
AND TAX_LINES.LINE_TYPE = 'TAX') ) LINE_TAX_BALANCE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAP
, AR_ACTIVITY_DETAILS ARL
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
, RA_CUSTOMER_TRX_LINES_ALL CUST_TRX_LINES
WHERE ARCASH.CASH_RECEIPT_ID = ARAP.CASH_RECEIPT_ID
AND ARAP.STATUS = 'APP'
AND ARAP.DISPLAY = 'Y'
AND ARAP.RECEIVABLE_APPLICATION_ID = ARL.SOURCE_ID
AND ARL.SOURCE_TABLE = 'RA'
AND ARL.CUSTOMER_TRX_LINE_ID = CUST_TRX_LINES.CUSTOMER_TRX_LINE_ID
AND CUST_TRX_LINES.LINE_TYPE = 'LINE'
AND PAY_SCH.PAYMENT_SCHEDULE_ID = ARAP.APPLIED_PAYMENT_SCHEDULE_ID UNION ALL SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARAP.APPLIED_CUSTOMER_TRX_ID
, DECODE(CUST_TRX.INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, NVL((SELECT LN.INTERFACE_LINE_ATTRIBUTE1
FROM RA_CUSTOMER_TRX_LINES_ALL LN
WHERE LN.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.LINE_TYPE = 'LINE'
AND ROWNUM < 2)
, PAY_SCH.TRX_NUMBER)
, PAY_SCH.TRX_NUMBER) INVOICE_NUMBER
, 'LINE' LINE_TYPE
, ARAP.LINE_APPLIED
, ARAP.TAX_APPLIED
, PAY_SCH.AMOUNT_LINE_ITEMS_REMAINING LINE_BALANCE
, PAY_SCH.TAX_REMAINING TAX_BALANCE
, DECODE(CUST_TRX.INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, NVL2((SELECT LN.INTERFACE_LINE_ATTRIBUTE1
FROM RA_CUSTOMER_TRX_LINES_ALL LN
WHERE LN.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.LINE_TYPE = 'LINE'
AND ROWNUM < 2)
, (SELECT LN.SEQUENCE_NUMBER
FROM OKL_CNSLD_AR_STRMS_B ST
, OKL_CNSLD_AR_LINES_B LN
WHERE ST.RECEIVABLES_INVOICE_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.ID = ST.LLN_ID)
, NULL)
, NULL) LINE_NUMBER
, NULL
, ARAP.APPLY_DATE
, PAY_SCH.TRX_DATE INVOICE_DATE
, PAY_SCH.DUE_DATE
, DECODE(CUST_TRX.INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, NVL2((SELECT LN.INTERFACE_LINE_ATTRIBUTE1
FROM RA_CUSTOMER_TRX_LINES_ALL LN
WHERE LN.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.LINE_TYPE = 'LINE'
AND ROWNUM < 2)
, CUST_TRX.INTERFACE_HEADER_ATTRIBUTE7
, NULL)
, NULL) ASSET_NUMBER
, DECODE(CUST_TRX.INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, NVL2((SELECT LN.INTERFACE_LINE_ATTRIBUTE1
FROM RA_CUSTOMER_TRX_LINES_ALL LN
WHERE LN.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.LINE_TYPE = 'LINE'
AND ROWNUM < 2)
, CUST_TRX.INTERFACE_HEADER_ATTRIBUTE9
, NULL)
, NULL) STREAM_TYPE
, DECODE(CUST_TRX.INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, NVL2((SELECT LN.INTERFACE_LINE_ATTRIBUTE1
FROM RA_CUSTOMER_TRX_LINES_ALL LN
WHERE LN.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND LN.LINE_TYPE = 'LINE'
AND ROWNUM < 2)
, CUST_TRX.INTERFACE_HEADER_ATTRIBUTE6
, NULL)
, NULL) CONTRACT_NUMBER
, ARAP.GL_DATE
, NVL(ARAP.TRANS_TO_RECEIPT_RATE
, 1) TRANS_TO_RECEIPT_RATE
, PAY_SCH.INVOICE_CURRENCY_CODE
, ARAP.RECEIVABLE_APPLICATION_ID
, (ARAP.LINE_APPLIED + ARAP.TAX_APPLIED) LINE_TAX_APPLIED
, (PAY_SCH.AMOUNT_LINE_ITEMS_REMAINING + PAY_SCH.TAX_REMAINING ) LINE_TAX_BALANCE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAP
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
, RA_CUSTOMER_TRX_ALL CUST_TRX
WHERE ARCASH.CASH_RECEIPT_ID = ARAP.CASH_RECEIPT_ID
AND ARAP.STATUS = 'APP'
AND ARAP.DISPLAY = 'Y'
AND PAY_SCH.PAYMENT_SCHEDULE_ID = ARAP.APPLIED_PAYMENT_SCHEDULE_ID
AND PAY_SCH.CUSTOMER_TRX_ID = CUST_TRX.CUSTOMER_TRX_ID
AND NOT EXISTS (SELECT 'X'
FROM AR_ACTIVITY_DETAILS ARL
WHERE ARL.SOURCE_ID = ARAP.RECEIVABLE_APPLICATION_ID
AND ARL.SOURCE_TABLE = 'RA') UNION ALL SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARAP.APPLIED_CUSTOMER_TRX_ID
, PAY_SCH.TRX_NUMBER INVOICE_NUMBER
, 'FREIGHT' LINE_TYPE
, ARAP.FREIGHT_APPLIED LINE_APPLIED
, 0 TAX_APPLIED
, PAY_SCH.FREIGHT_REMAINING LINE_BALANCE
, 0 TAX_BALANCE
, NULL LINE_NUMBER
, NULL CUSTOMER_TRX_LINE_ID
, ARAP.APPLY_DATE
, PAY_SCH.TRX_DATE INVOICE_DATE
, PAY_SCH.DUE_DATE
, NULL ASSET_NUMBER
, NULL STREAM_TYPE
, NULL CONTRACT_NUMBER
, ARAP.GL_DATE
, NVL(ARAP.TRANS_TO_RECEIPT_RATE
, 1) TRANS_TO_RECEIPT_RATE
, PAY_SCH.INVOICE_CURRENCY_CODE
, ARAP.RECEIVABLE_APPLICATION_ID
, ARAP.FREIGHT_APPLIED LINE_TAX_APPLIED
, PAY_SCH.FREIGHT_REMAINING LINE_TAX_BALANCE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAP
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
WHERE ARCASH.CASH_RECEIPT_ID = ARAP.CASH_RECEIPT_ID
AND ARAP.STATUS = 'APP'
AND ARAP.DISPLAY = 'Y'
AND PAY_SCH.PAYMENT_SCHEDULE_ID = ARAP.APPLIED_PAYMENT_SCHEDULE_ID
AND ARAP.FREIGHT_APPLIED > 0 UNION ALL SELECT ARCASH.CASH_RECEIPT_ID
, ARCASH.RECEIPT_NUMBER
, ARAP.APPLIED_CUSTOMER_TRX_ID
, PAY_SCH.TRX_NUMBER INVOICE_NUMBER
, 'CHARGES' LINE_TYPE
, ARAP.RECEIVABLES_CHARGES_APPLIED LINE_APPLIED
, 0 TAX_APPLIED
, PAY_SCH.RECEIVABLES_CHARGES_REMAINING LINE_BALANCE
, 0 TAX_BALANCE
, NULL LINE_NUMBER
, NULL CUSTOMER_TRX_LINE_ID
, ARAP.APPLY_DATE
, PAY_SCH.TRX_DATE INVOICE_DATE
, PAY_SCH.DUE_DATE
, NULL ASSET_NUMBER
, NULL STREAM_TYPE
, NULL CONTRACT_NUMBER
, ARAP.GL_DATE
, NVL(ARAP.TRANS_TO_RECEIPT_RATE
, 1) TRANS_TO_RECEIPT_RATE
, PAY_SCH.INVOICE_CURRENCY_CODE
, ARAP.RECEIVABLE_APPLICATION_ID
, ARAP.RECEIVABLES_CHARGES_APPLIED LINE_TAX_APPLIED
, PAY_SCH.RECEIVABLES_CHARGES_REMAINING LINE_TAX_BALANCE
FROM AR_CASH_RECEIPTS_ALL ARCASH
, AR_RECEIVABLE_APPLICATIONS_ALL ARAP
, AR_PAYMENT_SCHEDULES_ALL PAY_SCH
WHERE ARCASH.CASH_RECEIPT_ID = ARAP.CASH_RECEIPT_ID
AND ARAP.STATUS = 'APP'
AND ARAP.DISPLAY = 'Y'
AND PAY_SCH.PAYMENT_SCHEDULE_ID = ARAP.APPLIED_PAYMENT_SCHEDULE_ID
AND ARAP.RECEIVABLES_CHARGES_APPLIED > 0