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

Line 564: FROM ar_Receivable_Applications_All app_Line

560: -- added by dcshanmu for 6326279. Cross currency conversions ends
561:
562: CURSOR c_get_app_amount(p_cash_receipt_id IN NUMBER) IS
563: SELECT Nvl(SUM(app_Line.Amount_Applied),0)
564: FROM ar_Receivable_Applications_All app_Line
565: WHERE app_Line.Cash_Receipt_Id = p_cash_receipt_id
566: AND app_Line.Status = 'APP'
567: AND app_Line.Application_Type = 'CASH';
568:

Line 571: FROM ar_Receivable_Applications_All onAcc_Line

567: AND app_Line.Application_Type = 'CASH';
568:
569: CURSOR c_get_onacc_amount(p_cash_receipt_id IN NUMBER) IS
570: SELECT Nvl(SUM(onAcc_Line.Amount_Applied),0)
571: FROM ar_Receivable_Applications_All onAcc_Line
572: WHERE onAcc_Line.Cash_Receipt_Id = p_cash_receipt_id
573: AND onAcc_Line.Status = 'ONACC'
574: AND onAcc_Line.Application_Type = 'CASH';
575:

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

1035: l_api_name CONSTANT VARCHAR2(30) := 'unapply_receipt';
1036:
1037: l_customer_trx_id NUMBER DEFAULT p_customer_trx_id;
1038: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1039: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1040: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1041: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1042: i NUMBER DEFAULT NULL;
1043: l_counter NUMBER;

Line 1051: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1047: -- check receipt applic
1048: CURSOR c_ver_dup_applic( cp_customer_trx_id IN NUMBER
1049: ,cp_cash_receipt_id IN NUMBER) IS
1050: SELECT NVL(RECEIVABLE_APPLICATION_ID,0)
1051: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1052: WHERE APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
1053: AND CASH_RECEIPT_ID = cp_cash_receipt_id
1054: AND STATUS = 'APP'
1055: AND APPLICATION_TYPE ='CASH'

Line 1063: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1059: /*
1060: -- verify receipt applied amount
1061: CURSOR c_ver_app_amt(cp_csh_rcpt_id IN NUMBER) IS
1062: SELECT NVL(SUM(AMOUNT_APPLIED),0)
1063: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1064: WHERE STATUS = 'APP'
1065: AND CASH_RECEIPT_ID = cp_csh_rcpt_id;
1066: -------------------------------------------------------------------------------
1067: */

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

1177: l_customer_trx_id NUMBER DEFAULT p_customer_trx_id;
1178: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1179: l_llca_tbl llca_tbl_type := p_llca_tbl;
1180: l_ar_llca_tbl ar_receipt_api_pub.llca_trx_lines_tbl_type;
1181: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1182: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
1183: l_org_id NUMBER := p_org_id;
1184: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1185: i NUMBER DEFAULT NULL;

Line 1212: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1208: --Begain - handle onaccount - varangan - 6353486
1209: --Application Id for ON-Account record
1210: CURSOR c_get_onacc_app_id ( p_cash_rcpt_id IN NUMBER) IS
1211: SELECT NVL(RECEIVABLE_APPLICATION_ID,0)
1212: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1213: WHERE CASH_RECEIPT_ID = p_cash_rcpt_id
1214: AND STATUS = 'ACC'
1215: AND APPLICATION_TYPE ='CASH'
1216: AND DISPLAY ='Y'

Line 1222: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1218:
1219: CURSOR c_get_trans_to_receipt_rate (p_cash_rcpt_id IN NUMBER
1220: , p_customer_trx_id IN NUMBER) IS
1221: SELECT TRANS_TO_RECEIPT_RATE
1222: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1223: WHERE CASH_RECEIPT_ID = p_cash_rcpt_id
1224: AND APPLIED_CUSTOMER_TRX_ID = p_customer_trx_id
1225: AND NVL(DISPLAY,'N') = 'Y';
1226:

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

1502: l_msg_data VARCHAR2(2000);
1503: l_api_name CONSTANT VARCHAR2(30) := 'handle_onacc_update';
1504:
1505: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_cash_receipt_id;
1506: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
1507: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_gl_date;
1508: l_org_id NUMBER := p_org_id;
1509: l_apply_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
1510: i NUMBER DEFAULT NULL;

Line 1522: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1518: --Begain - handle onaccount - varangan - 6353486
1519: --Application Id for ON-Account record
1520: CURSOR c_get_onacc_app_id ( p_cash_rcpt_id IN NUMBER) IS
1521: SELECT NVL(RECEIVABLE_APPLICATION_ID,0)
1522: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1523: WHERE CASH_RECEIPT_ID = p_cash_rcpt_id
1524: AND STATUS = 'ACC'
1525: AND APPLICATION_TYPE ='CASH'
1526: AND DISPLAY ='Y'

Line 1715: FROM AR_RECEIVABLE_APPLICATIONS_ALL

1711:
1712: --Application Id for ON-Account record
1713: CURSOR c_get_onacc_app_id ( cp_cash_rcpt_id IN NUMBER) IS
1714: SELECT NVL(RECEIVABLE_APPLICATION_ID,0)
1715: FROM AR_RECEIVABLE_APPLICATIONS_ALL
1716: WHERE CASH_RECEIPT_ID = cp_cash_rcpt_id
1717: AND STATUS = 'ACC'
1718: AND APPLICATION_TYPE ='CASH'
1719: AND DISPLAY ='Y'