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.

[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on AR_RECEIVABLES_TRX

Line 684: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

680: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
682: ) IS
683:
684: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
685: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;
686: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
687: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
688: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */

Line 685: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;

681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
682: ) IS
683:
684: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
685: l_distribution_set_id ar_receivables_trx.default_acctg_distribution_set%TYPE;
686: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
687: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
688: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
689: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /*Bug fix 4025652 */

Line 690: l_type ar_receivables_trx.type%TYPE; /4726219 /

686: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
687: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
688: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
689: l_crh_ccid ar_cash_receipt_history.account_code_combination_id%TYPE; /*Bug fix 4025652 */
690: l_type ar_receivables_trx.type%TYPE; /*4726219 */
691:
692: l_xla_ev_rec arp_xla_events.xla_events_type;
693:
694: CURSOR c_hist IS

Line 762: FROM ar_receivables_trx rt

758: rt.type
759: INTO l_trx_code_combination_id,
760: l_distribution_set_id,
761: l_type
762: FROM ar_receivables_trx rt
763: WHERE rt.type in
764: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND','CC_CHARGEBACK')
765: AND NVL( rt.status, 'A' ) = 'A'
766: AND rt.RECEIVABLES_TRX_ID = p_receivables_trx_id;

Line 936: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

932: p_receipt_date_changed_flag IN BOOLEAN,
933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
934: ) IS
935:
936: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
937: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
938: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
939: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
940: l_old_recs_auto_flag BOOLEAN;

Line 937: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;

933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
934: ) IS
935:
936: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
937: l_old_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
938: l_dummy ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
939: l_misc_cash_dist_rec ar_misc_cash_distributions%ROWTYPE;
940: l_old_recs_auto_flag BOOLEAN;
941: l_new_recs_auto_flag BOOLEAN;

Line 1115: FROM ar_receivables_trx rt

1111: /* Start Bug 6416611 - modified query to handle case of receivable activity
1112: with distribution set */
1113: SELECT rt.code_combination_id, rt.default_acctg_distribution_set
1114: INTO l_old_trx_code_combination_id, l_old_default_distribution_set
1115: FROM ar_receivables_trx rt
1116: WHERE rt.type in
1117: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND', 'CC_CHARGEBACK')
1118: -- AND ( (NVL( rt.status, 'A' ) = 'A') or (rt.end_date_active=p_receipt_date))
1119: AND rt.RECEIVABLES_TRX_ID = p_old_receivables_trx_id;

Line 1152: FROM ar_receivables_trx rt

1148: /* Start Bug 6416611 - modified query to handle case of receivable activity
1149: with distribution set */
1150: SELECT rt.code_combination_id, rt.default_acctg_distribution_set
1151: INTO l_trx_code_combination_id, l_default_distribution_set
1152: FROM ar_receivables_trx rt
1153: WHERE rt.type in
1154: ('MISCCASH', 'BANK_ERROR', 'CCREFUND', 'CM_REFUND' , 'CC_CHARGEBACK')
1155: -- AND ((NVL( rt.status, 'A' ) = 'A') or (rt.end_date_active=p_receipt_date))
1156: AND rt.RECEIVABLES_TRX_ID = p_receivables_trx_id;

Line 2120: | ar_receivables_trx instead of |

2116: | and added parameters to allow procedure to |
2117: | return all ccid's for the IN parameters |
2118: | 07-JAN-98 DJANCIS selected code combination id's for earned |
2119: | and unearnd ccids from |
2120: | ar_receivables_trx instead of |
2121: | ar_receipt_method_accounts for |
2122: | 11.5 VAT changes |
2123: | |
2124: +===========================================================================*/

Line 2143: ar_receivables_trx instead of ar_receipt_method_accounts for

2139: ) IS
2140: BEGIN
2141:
2142: /* selected code combination id's for earned and unearnd ccids from
2143: ar_receivables_trx instead of ar_receipt_method_accounts for
2144: 11.5 VAT changes */
2145:
2146: SELECT
2147: rma.unidentified_ccid,

Line 2170: AR_RECEIVABLES_TRX ed,

2166: p_remittance_ccid,
2167: p_cash_ccid
2168: FROM
2169: AR_RECEIPT_METHOD_ACCOUNTS rma,
2170: AR_RECEIVABLES_TRX ed,
2171: AR_RECEIVABLES_TRX uned
2172: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2173: AND receipt_method_id = p_receipt_method_id
2174: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)

Line 2171: AR_RECEIVABLES_TRX uned

2167: p_cash_ccid
2168: FROM
2169: AR_RECEIPT_METHOD_ACCOUNTS rma,
2170: AR_RECEIVABLES_TRX ed,
2171: AR_RECEIVABLES_TRX uned
2172: WHERE remit_bank_acct_use_id = p_remittance_bank_account_id
2173: AND receipt_method_id = p_receipt_method_id
2174: AND rma.edisc_receivables_trx_id = ed.receivables_trx_id (+)
2175: AND rma.unedisc_receivables_trx_id = uned.receivables_trx_id (+);