DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 6378: , OKL_TXL_AR_INV_LNS_V TIL

6374: -- varangan - Bug#5588871 - Modified - End
6375: , ARL.AMOUNT_DUE_ORIGINAL invoice_amount
6376: , ARL.AMOUNT_DUE_REMAINING amount_due_remaining
6377: FROM OKL_BPD_AR_INV_LINES_V ARL
6378: , OKL_TXL_AR_INV_LNS_V TIL
6379: , OKL_TRX_AR_INVOICES_V TAI
6380: WHERE
6381: TIL.KLE_ID = p_cle_id -- < SUBSIDY CLE ID >
6382: AND TAI.ID = TIL.TAI_ID

Line 6424: , OKL_TXL_AR_INV_LNS_V TIL

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
6427: AND XTL.LSM_ID = LSM.ID
6428: AND TIL.ID = XTL.TIL_ID

Line 6460: FROM OKL_TXL_AR_INV_LNS_V TIL

6456: til.sty_id stream_type_id,
6457: til.line_number line_number,
6458: til.inv_receiv_line_code inv_receiv_line_code
6459: , til.bank_acct_id bank_acct_id
6460: FROM OKL_TXL_AR_INV_LNS_V TIL
6461: , OKL_TRX_AR_INVOICES_V TAI
6462: WHERE TIL.KLE_ID = p_cle_id -- < SUBSIDY CLE ID >
6463: AND TAI.ID = TIL.TAI_ID
6464: AND TAI.KHR_ID = p_chr_id;