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_REPORT_PVT dependencies on RA_CUST_RECEIPT_METHODS

Line 4640: CURSOR validate_cust_pmt_method (cp_customer_id IN ra_cust_receipt_methods.customer_id%TYPE,

4636: AND linked_asset.BILL_TO_SITE_USE_ID = cs.id1
4637: AND khr.bill_to_site_use_id = cp.site_use_id(+);
4638:
4639: -- Validate customer payment method in AR
4640: CURSOR validate_cust_pmt_method (cp_customer_id IN ra_cust_receipt_methods.customer_id%TYPE,
4641: cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,
4642: cp_trx_date IN DATE) IS
4643: SELECT 'X'
4644: FROM ra_cust_receipt_methods CPM

Line 4641: cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,

4637: AND khr.bill_to_site_use_id = cp.site_use_id(+);
4638:
4639: -- Validate customer payment method in AR
4640: CURSOR validate_cust_pmt_method (cp_customer_id IN ra_cust_receipt_methods.customer_id%TYPE,
4641: cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,
4642: cp_trx_date IN DATE) IS
4643: SELECT 'X'
4644: FROM ra_cust_receipt_methods CPM
4645: WHERE cpm.customer_id = cp_customer_id

Line 4644: FROM ra_cust_receipt_methods CPM

4640: CURSOR validate_cust_pmt_method (cp_customer_id IN ra_cust_receipt_methods.customer_id%TYPE,
4641: cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,
4642: cp_trx_date IN DATE) IS
4643: SELECT 'X'
4644: FROM ra_cust_receipt_methods CPM
4645: WHERE cpm.customer_id = cp_customer_id
4646: AND cpm.receipt_method_id = cp_receipt_method_id
4647: AND cp_trx_date BETWEEN NVL(CPM.START_DATE, cp_trx_date)
4648: AND NVL(CPM.END_DATE, cp_trx_date);

Line 4651: CURSOR validate_pmt_method (cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,

4647: AND cp_trx_date BETWEEN NVL(CPM.START_DATE, cp_trx_date)
4648: AND NVL(CPM.END_DATE, cp_trx_date);
4649:
4650: -- Validate payment method in AR
4651: CURSOR validate_pmt_method (cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,
4652: cp_trx_date IN DATE) IS
4653: SELECT 'X'
4654: FROM AR_RECEIPT_METHODS CPM
4655: WHERE cpm.receipt_method_id = cp_receipt_method_id