eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 6389: FROM okl_cnsld_ar_strms_b lsm

6385: AND TIL.ID = ARL.TIL_ID_DETAILS
6386: AND ARL.AMOUNT_DUE_ORIGINAL > 0 -- donot consider credit memos
6387: AND ARL.AMOUNT_DUE_REMAINING > 0 -- only those invoices that have some balance
6388: AND NOT EXISTS (SELECT 1
6389: FROM okl_cnsld_ar_strms_b lsm
6390: WHERE lsm.receivables_invoice_id = ARL.receivables_invoice_id)
6391: UNION
6392: SELECT lsm.receivables_invoice_id receivables_invoice_id,
6393: NULL invoice_line_id,

Line 6422: , OKL_CNSLD_AR_STRMS_B LSM

6418: -- smadhava - Bug#5564198 - Modified - End
6419: , APS.AMOUNT_DUE_ORIGINAL invoice_amount
6420: , APS.AMOUNT_DUE_REMAINING amount_due_remaining
6421: FROM AR_PAYMENT_SCHEDULES_ALL APS
6422: , OKL_CNSLD_AR_STRMS_B LSM
6423: , OKL_XTL_SELL_INVS_B XTL
6424: , OKL_TXL_AR_INV_LNS_V TIL
6425: , OKL_TRX_AR_INVOICES_V TAI
6426: WHERE LSM.RECEIVABLES_INVOICE_ID = APS.CUSTOMER_TRX_ID