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 OKL_TXL_RCPT_APPS_V

Line 468: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

464: --
465:
466:
467: l_rct_id NUMBER;
468: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
469: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
470: i NUMBER DEFAULT NULL;
471:
472: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;

Line 539: OKL_TXL_RCPT_APPS_V b,

535: -- arcash.exchange_rate ,
536: a.id,
537: arcash.receipt_Date
538: FROM OKL_TRX_CSH_RECEIPT_V a,
539: OKL_TXL_RCPT_APPS_V b,
540: ar_cash_receipts_All arcash
541: WHERE a.id = b.rct_id_details
542: AND a.FULLY_APPLIED_FLAG = 'N'
543: AND a.EXPIRED_FLAG = 'N'

Line 992: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

988: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
989: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
990:
991: l_xcr_id NUMBER DEFAULT p_xcr_id;
992: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
993: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
994: i NUMBER DEFAULT NULL;
995:
996: l_counter NUMBER;

Line 1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;

1313: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1320:
1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

Line 1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

1314: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1320:
1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1322:

Line 1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

1315: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
1316:
1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1320:
1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1322:
1323: l_xcr_id NUMBER DEFAULT p_xcr_id;

Line 1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;

1317: l_purpose_id OKL_TXL_RCPT_APPS_V.STY_ID%TYPE DEFAULT NULL;
1318: l_purpose_amt OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1319: l_purpose_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1320:
1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1322:
1323: l_xcr_id NUMBER DEFAULT p_xcr_id;
1324: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
1325: i NUMBER DEFAULT NULL;

Line 1324: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

1320:
1321: l_applied_running_total OKL_TXL_RCPT_APPS_V.AMOUNT%TYPE DEFAULT NULL;
1322:
1323: l_xcr_id NUMBER DEFAULT p_xcr_id;
1324: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
1325: i NUMBER DEFAULT NULL;
1326: k NUMBER := 0;
1327:
1328: l_counter NUMBER;

Line 1392: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b

1388:
1389: -- get purpose for advance receipt if any
1390: CURSOR c_get_purpose_for_adv_rcpt(cp_cont_id IN NUMBER, cp_icr_id IN NUMBER) IS
1391: SELECT b.sty_id, b.amount
1392: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
1393: WHERE a.id = b.rct_id_details
1394: AND a.receipt_type = 'ADV'
1395: AND a.EXPIRED_FLAG = 'N'
1396: AND a.FULLY_APPLIED_FLAG = 'N'

Line 1876: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

1872:
1873: l_okl_receipt_id NUMBER;
1874: l_xcr_id NUMBER;
1875: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
1876: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
1877: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
1878: i NUMBER DEFAULT NULL;
1879:
1880:

Line 1954: OKL_TXL_RCPT_APPS_V b,

1950: a.id RCT_ID,
1951: c.receipt_date,
1952: b.khr_id
1953: FROM OKL_TRX_CSH_RECEIPT_V a,
1954: OKL_TXL_RCPT_APPS_V b,
1955: AR_CASH_RECEIPTS_ALL c
1956: WHERE a.id = b.rct_id_details
1957: AND a.cash_receipt_id = c.cash_receipt_id
1958: AND a.FULLY_APPLIED_FLAG = 'N'

Line 2737: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;

2733: l_temp_rcpt_date AR_CASH_RECEIPTS_ALL.RECEIPT_DATE%TYPE DEFAULT NULL;
2734:
2735: l_xcr_id NUMBER;
2736: l_rct_id OKL_TRX_CSH_RECEIPT_V.ID%TYPE;
2737: l_rca_id OKL_TXL_RCPT_APPS_V.ID%TYPE;
2738: l_cat_id OKL_CASH_ALLCTN_RLS.ID%TYPE DEFAULT NULL;
2739: l_cau_id OKL_CSH_ALLCTN_RL_HDR.ID%TYPE DEFAULT NULL;
2740:
2741: l_stat_total_rcpt_amt OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT 0;

Line 2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c

2785: SELECT DISTINCT(a.cash_receipt_id) icr_id,
2786: a.id RCT_ID,
2787: c.receipt_date,
2788: b.khr_id
2789: FROM OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b, AR_CASH_RECEIPTS_ALL c
2790: WHERE a.id = b.rct_id_details
2791: AND a.cash_receipt_id = c.cash_receipt_id
2792: AND a.FULLY_APPLIED_FLAG = 'N'
2793: AND a.receipt_type = 'ADV'