APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 6334: FROM OKL_TRX_AR_INVOICES_V TRX

6330: CURSOR c_get_bill_stat( p_cle_id IN NUMBER,
6331: p_chr_id IN NUMBER) IS
6332: SELECT TRX.ID
6333: , TRX.DESCRIPTION
6334: FROM OKL_TRX_AR_INVOICES_V TRX
6335: , OKL_TXL_AR_INV_LNS_B TIL
6336: WHERE TIL.TAI_ID = TRX.ID
6337: AND TIL.KLE_ID = p_cle_id -- subsidy cle id
6338: AND TRX.KHR_ID = p_chr_id

Line 6379: , OKL_TRX_AR_INVOICES_V TAI

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
6383: AND TAI.KHR_ID = p_chr_id

Line 6425: , OKL_TRX_AR_INVOICES_V TAI

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
6429: AND TIL.KLE_ID = p_cle_id -- < SUBSIDY CLE ID >

Line 6461: , OKL_TRX_AR_INVOICES_V TAI

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;
6465: