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.ARP_PROCESS_CHARGEBACK dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 143: FROM ra_cust_trx_line_gl_dist dist,

139: AND ps.class = 'CB';
140:
141: SELECT dist.code_combination_id
142: INTO l_adj_rec.code_combination_id
143: FROM ra_cust_trx_line_gl_dist dist,
144: ra_customer_trx ct
145: WHERE ct.customer_trx_id = p_cb_ct_id
146: AND ct.customer_trx_id = dist.customer_trx_id
147: AND dist.account_class = 'REV';

Line 1042: into RA_CUST_TRX_LINE_GL_DIST

1038: 1. Instantiate variables with default values
1039: 2. Insert header RA_CUSTOMER_TRX
1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution
1044: into RA_CUST_TRX_LINE_GL_DIST
1045: 6. Insert into AR_PAYMENT_SCHEDULES
1046: - Call event handler

Line 1044: into RA_CUST_TRX_LINE_GL_DIST

1040: 3. Insert one line into RA_CUSTOMER_TRX_LINES
1041: 4. Insert revenue account GL distribution
1042: into RA_CUST_TRX_LINE_GL_DIST
1043: 5. Insert receivables account GL distribution
1044: into RA_CUST_TRX_LINE_GL_DIST
1045: 6. Insert into AR_PAYMENT_SCHEDULES
1046: - Call event handler
1047:
1048: 7. Initialize, then populate app_struct and ps_struct

Line 1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist

1064: ARTITRXB.pls Table handler for ra_customer_trx
1065: - insert_p
1066: ARTICTLB.pls Table handler for ra_customer_trx_lines
1067: - insert_p
1068: ARTILGDB.pls Table handler ra_cust_trx_line_gl_dist
1069: - insert_p
1070: ARTEADJS.pls Adjustment procedures
1071: - insert_adjustment
1072:

Line 1208: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;

1204: IS
1205:
1206: l_ct_row ra_customer_trx%ROWTYPE;
1207: l_ctl_row ra_customer_trx_lines%ROWTYPE;
1208: l_ctlgd_row ra_cust_trx_line_gl_dist%ROWTYPE;
1209: l_ps_row ar_payment_schedules%ROWTYPE;
1210: l_adj_row ar_adjustments%ROWTYPE;
1211:
1212: ln_app_payment_schedule_id NUMBER;

Line 1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1237: l_receivables_trx_id ar_receivables_trx.receivables_trx_id%TYPE;
1238: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1239: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

Line 1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1240: l_cr_unapp_ccid ar_receivable_applications.code_combination_id%TYPE;
1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1246: --Bug2979254
1247: l_ev_rec arp_xla_events.xla_events_type;
1248: /* Bug 3879127 */

Line 1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;

1241: l_inv_rec_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1242: l_id_dummy ar_receivable_applications.code_combination_id%TYPE;
1243: l_bill_to_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1244: l_cb_activity_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1245: l_actual_ccid ra_cust_trx_line_gl_dist.code_combination_id%TYPE;
1246: --Bug2979254
1247: l_ev_rec arp_xla_events.xla_events_type;
1248: /* Bug 3879127 */
1249: ln_amount_due_remaining NUMBER;

Line 1390: , ra_cust_trx_line_gl_dist ctlgd

1386: , l_ct_row.legal_entity_id /* R12 LE uptake */
1387: , ln_trx_number /*bug 5550153*/
1388: FROM
1389: ar_payment_schedules ps
1390: , ra_cust_trx_line_gl_dist ctlgd
1391: , ra_customer_trx ct
1392: WHERE
1393: ct.customer_trx_id = p_app_customer_trx_id
1394: AND ct.customer_trx_id = ps.customer_trx_id

Line 1686: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns

1682: -- Insert revenue account distribution
1683: -- ---------------------------------------------------
1684:
1685: -- ---------------------------------------------------
1686: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns
1687: -- The revenue distributions should have an account class
1688: -- of 'REV'
1689: -- ---------------------------------------------------
1690:

Line 1799: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table

1795:
1796: END IF;
1797: l_ctlgd_row.code_combination_id := l_actual_ccid;
1798: -- ---------------------------------------------------
1799: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table
1800: -- ---------------------------------------------------
1801:
1802: arp_ctlgd_pkg.insert_p(
1803: -- IN

Line 1819: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns

1815: -- Insert receivables account distribution
1816: -- ---------------------------------------------------
1817:
1818: -- ---------------------------------------------------
1819: -- Set values for RA_CUST_TRX_LINE_GL_DIST table columns
1820: -- The receivables distributions should have an account class
1821: -- of 'REC'.
1822: -- The receivable account distributions records should
1823: -- not have a value in CUSTOMER_TRX_LINE_ID

Line 1844: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table

1840: l_ctlgd_row.ussgl_transaction_code_context :=
1841: l_ct_row.default_ussgl_trx_code_context;
1842:
1843: -- ---------------------------------------------------
1844: -- Insert line into RA_CUST_TRX_LINE_GL_DIST table
1845: -- ---------------------------------------------------
1846: arp_ctlgd_pkg.insert_p(
1847: -- IN
1848: p_dist_rec => l_ctlgd_row