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_ARINTF_PVT dependencies on AR_RECEIPT_METHODS

Line 147: FROM AR_RECEIPT_METHODS M,

143:
144: -- Bank Account Cursor
145: CURSOR rcpt_method_csr ( p_rct_method_id NUMBER) IS
146: SELECT C.CREATION_METHOD_CODE
147: FROM AR_RECEIPT_METHODS M,
148: AR_RECEIPT_CLASSES C
149: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
150: M.receipt_method_id = p_rct_method_id;
151:

Line 941: FROM AR_RECEIPT_METHODS M,

937: WHERE C.cust_receipt_method_id = p_payment_method_id;
938:
939: CURSOR c_receipt_method ( p_rct_method_id NUMBER) IS
940: SELECT C.CREATION_METHOD_CODE, M.PAYMENT_CHANNEL_CODE
941: FROM AR_RECEIPT_METHODS M,
942: AR_RECEIPT_CLASSES C
943: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
944: M.receipt_method_id = p_rct_method_id;
945:

Line 953: AR_RECEIPT_METHODS RM

949: SELECT RM.Payment_channel_code,
950: CRM.CUST_RECEIPT_METHOD_ID,
951: CRM.RECEIPT_METHOD_ID
952: FROM RA_CUST_RECEIPT_METHODS CRM,
953: AR_RECEIPT_METHODS RM
954: WHERE RM.RECEIPT_METHOD_ID = CRM.RECEIPT_METHOD_ID
955: AND customer_id = p_cust_acct_id
956: AND NVL(site_use_id,-101) = NVL(p_site_use_id,-101)
957: AND NVL(CRM.PRIMARY_FLAG,'N') = 'Y'

Line 1018: l_vend_acct_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;

1014: l_vend_pmt_mth_acct_rec c_vendor_payment_method%ROWTYPE;
1015: l_vend_pmt_mth_site_rec c_vendor_payment_method%ROWTYPE;
1016: l_vend_pmt_ins_acct_rec c_vendor_payment_instrument%ROWTYPE;
1017: l_vend_pmt_ins_site_rec c_vendor_payment_instrument%ROWTYPE;
1018: l_vend_acct_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1019: l_vend_site_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1020: l_instrument_type IBY_PMT_INSTR_USES_ALL.INSTRUMENT_TYPE%TYPE DEFAULT NULL;
1021: l_vend_payment_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1022:

Line 1019: l_vend_site_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;

1015: l_vend_pmt_mth_site_rec c_vendor_payment_method%ROWTYPE;
1016: l_vend_pmt_ins_acct_rec c_vendor_payment_instrument%ROWTYPE;
1017: l_vend_pmt_ins_site_rec c_vendor_payment_instrument%ROWTYPE;
1018: l_vend_acct_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1019: l_vend_site_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1020: l_instrument_type IBY_PMT_INSTR_USES_ALL.INSTRUMENT_TYPE%TYPE DEFAULT NULL;
1021: l_vend_payment_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1022:
1023: l_vend_pmt_mth_acct_found BOOLEAN := FALSE;

Line 1021: l_vend_payment_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;

1017: l_vend_pmt_ins_site_rec c_vendor_payment_instrument%ROWTYPE;
1018: l_vend_acct_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1019: l_vend_site_pmt_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1020: l_instrument_type IBY_PMT_INSTR_USES_ALL.INSTRUMENT_TYPE%TYPE DEFAULT NULL;
1021: l_vend_payment_channel_code AR_RECEIPT_METHODS.PAYMENT_CHANNEL_CODE%TYPE DEFAULT NULL;
1022:
1023: l_vend_pmt_mth_acct_found BOOLEAN := FALSE;
1024: l_vend_pmt_mth_site_found BOOLEAN := FALSE;
1025: l_vend_pmt_ins_acct_found BOOLEAN := FALSE;

Line 2467: FROM AR_RECEIPT_METHODS M,

2463:
2464: -- sosharma for bug 9871252
2465: CURSOR rcpt_cr_method_csr ( p_rct_method_id NUMBER) IS
2466: SELECT C.CREATION_METHOD_CODE
2467: FROM AR_RECEIPT_METHODS M,
2468: AR_RECEIPT_CLASSES C
2469: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
2470: M.receipt_method_id = p_rct_method_id;
2471: