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_ADVANCED_CASH_APP_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 58: FROM AR_RECEIVABLE_APPLICATIONS_ALL

54:
55:
56: CURSOR get_unapp_amt(cp_csh_rcpt_id IN NUMBER) IS
57: SELECT sum(amount_applied)
58: FROM AR_RECEIVABLE_APPLICATIONS_ALL
59: WHERE status = 'UNAPP'
60: AND display = 'Y'
61: AND cash_receipt_id = cp_csh_rcpt_id;
62:

Line 229: FROM AR_RECEIVABLE_APPLICATIONS_ALL

225:
226:
227: CURSOR get_unapp_amt(cp_csh_rcpt_id IN NUMBER) IS
228: SELECT sum(nvl(amount_applied,0))
229: FROM AR_RECEIVABLE_APPLICATIONS_ALL
230: WHERE status = 'UNAPP'
231: AND cash_receipt_id = cp_csh_rcpt_id;
232:
233: CURSOR get_onacc_amt(cp_csh_rcpt_id IN NUMBER) IS

Line 235: FROM AR_RECEIVABLE_APPLICATIONS_ALL

231: AND cash_receipt_id = cp_csh_rcpt_id;
232:
233: CURSOR get_onacc_amt(cp_csh_rcpt_id IN NUMBER) IS
234: SELECT sum(nvl(amount_applied,0))
235: FROM AR_RECEIVABLE_APPLICATIONS_ALL
236: WHERE status = 'ACC'
237: AND cash_receipt_id = cp_csh_rcpt_id;
238:
239:

Line 978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

974: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
975:
976: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
977:
978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
980:
981: --
982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;

Line 979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;

975:
976: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
977:
978: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
979: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
980:
981: --
982: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
983: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;

Line 1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

1280: l_invoice_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_invoice_currency;
1281:
1282: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
1283:
1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
1286:
1287: --
1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;

Line 1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;

1281:
1282: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
1283:
1284: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
1285: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
1286:
1287: --
1288: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_currency_conv_type;
1289: l_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT p_currency_conv_date;

Line 1465: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1461: WHERE id = cp_khr_id;
1462:
1463: CURSOR get_onacc_amt(cp_csh_rcpt_id IN NUMBER) IS
1464: SELECT sum(nvl(amount_applied,0))
1465: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1466: WHERE status = 'ACC'
1467: AND cash_receipt_id = cp_csh_rcpt_id;
1468:
1469: CURSOR chk_exp_flag(cp_rct_id IN NUMBER) IS

Line 3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

3297: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
3298:
3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
3300:
3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
3303:
3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3305:

Line 3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;

3298:
3299: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT p_currency_code; -- entered currency code
3300:
3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
3303:
3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3305:
3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;

Line 3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;

3300:
3301: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
3303:
3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3305:
3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
3307:
3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;

Line 3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;

3302: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
3303:
3304: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
3305:
3306: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
3307:
3308: l_invoice_balance AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT NULL;
3309:
3310: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 3408: FROM AR_RECEIVABLE_APPLICATIONS_ALL

3404: -- check receipt applic
3405: CURSOR c_ver_dup_applic( cp_customer_trx_id IN NUMBER
3406: ,cp_cash_receipt_id IN NUMBER) IS
3407: SELECT amount_applied, receivable_application_id
3408: FROM AR_RECEIVABLE_APPLICATIONS_ALL
3409: WHERE applied_customer_trx_id = cp_customer_trx_id
3410: AND cash_receipt_id = cp_cash_receipt_id
3411: AND status = 'APP'
3412: ORDER BY creation_date desc;