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.

APPS.OKL_BPD_MAN_RCT_HANDLE_PVT dependencies on OKL_CNSLD_AR_STRMS_V

Line 190: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS

186: ORDER BY CREATION_DATE desc;
187:
188: -------------------------------------------------------------------------------
189: -- Gets the Invoice details for the stream
190: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS
191: SELECT CNSLD.RECEIVABLES_INVOICE_ID
192: FROM OKL_CNSLD_AR_STRMS_V CNSLD
193: WHERE CNSLD.ID = cp_stream_id;
194: -------------------------------------------------------------------------------

Line 192: FROM OKL_CNSLD_AR_STRMS_V CNSLD

188: -------------------------------------------------------------------------------
189: -- Gets the Invoice details for the stream
190: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS
191: SELECT CNSLD.RECEIVABLES_INVOICE_ID
192: FROM OKL_CNSLD_AR_STRMS_V CNSLD
193: WHERE CNSLD.ID = cp_stream_id;
194: -------------------------------------------------------------------------------
195:
196: -- Obtain the payment details for the invoice

Line 713: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS

709: ORDER BY CREATION_DATE desc;
710:
711: -------------------------------------------------------------------------------
712: -- Gets the Invoice details for the stream
713: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS
714: SELECT CNSLD.RECEIVABLES_INVOICE_ID
715: FROM OKL_CNSLD_AR_STRMS_V CNSLD
716: WHERE CNSLD.ID = cp_stream_id;
717: -------------------------------------------------------------------------------

Line 715: FROM OKL_CNSLD_AR_STRMS_V CNSLD

711: -------------------------------------------------------------------------------
712: -- Gets the Invoice details for the stream
713: CURSOR c_get_rec_inv_dtls( cp_stream_id IN OKL_CNSLD_AR_STRMS_V.ID%TYPE ) IS
714: SELECT CNSLD.RECEIVABLES_INVOICE_ID
715: FROM OKL_CNSLD_AR_STRMS_V CNSLD
716: WHERE CNSLD.ID = cp_stream_id;
717: -------------------------------------------------------------------------------
718:
719: -- verify receipt applied amount