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_CREDIT_MEMO_MODULE dependencies on RA_CUSTOMER_TRX_LINES

Line 205: TABLE OF ra_customer_trx_lines.customer_trx_line_id%type

201: null_cm_sched_check_gl_date CONSTANT cm_sched_check_gld_tab_type :=
202: cm_sched_check_gl_date_t;
203:
204: TYPE cm_mrc_cust_trx_line_id_type IS
205: TABLE OF ra_customer_trx_lines.customer_trx_line_id%type
206: INDEX BY BINARY_INTEGER;
207: mrc_cm_cust_trx_line_id cm_mrc_cust_trx_line_id_type;
208: mrc_cust_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
209:

Line 208: mrc_cust_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;

204: TYPE cm_mrc_cust_trx_line_id_type IS
205: TABLE OF ra_customer_trx_lines.customer_trx_line_id%type
206: INDEX BY BINARY_INTEGER;
207: mrc_cm_cust_trx_line_id cm_mrc_cust_trx_line_id_type;
208: mrc_cust_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
209:
210:
211: --
212: --

Line 545: FROM ra_customer_trx_lines

541: l_delete_header_cma_sql :=
542: 'DELETE from ar_credit_memo_amounts
543: WHERE customer_trx_line_id in
544: (SELECT customer_trx_line_id
545: FROM ra_customer_trx_lines
546: WHERE line_type = ''LINE''
547: and customer_trx_id = :customer_trx_id)';
548:
549: debug(l_delete_header_cma_sql);

Line 562: 'UPDATE ra_customer_trx_lines

558: debug(' len(delete_line_cma_sql) = '||
559: to_char(lengthb(l_delete_line_cma_sql)));
560:
561: l_update_header_lines_sql :=
562: 'UPDATE ra_customer_trx_lines
563: SET
564: rule_start_date = null,
565: rule_end_date = null,
566: accounting_rule_duration = null

Line 575: 'UPDATE ra_customer_trx_lines

571: debug(' len(update_header_lines_sql) = '||
572: to_char(lengthb(l_update_header_lines_sql)));
573:
574: l_update_lines_sql :=
575: 'UPDATE ra_customer_trx_lines
576: SET
577: rule_start_date = null,
578: rule_end_date = null,
579: accounting_rule_duration = null

Line 948: ra_customer_trx_lines ctl,

944: FROM
945: fnd_currencies foreign_fc,
946: ar_lookups al_rules,
947: ra_customer_trx ct,
948: ra_customer_trx_lines ctl,
949: ra_cust_trx_line_gl_dist ctlgd,
950: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
951: ra_cust_trx_line_salesreps ctls,
952: ra_customer_trx prev_ct,

Line 953: ra_customer_trx_lines prev_ctl,

949: ra_cust_trx_line_gl_dist ctlgd,
950: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
951: ra_cust_trx_line_salesreps ctls,
952: ra_customer_trx prev_ct,
953: ra_customer_trx_lines prev_ctl,
954: ra_cust_trx_line_gl_dist prev_ctlgd,
955: ra_cust_trx_line_gl_dist prev_ctlgd2 /* inv rec dist */
956: WHERE ct.customer_trx_id = ctl.customer_trx_id
957: and ctl.customer_trx_line_id = ctlgd.customer_trx_line_id(+)

Line 1116: ra_customer_trx_lines ctl

1112: ar_lookups al_rules,
1113: ra_cust_trx_line_gl_dist inv_rec,
1114: ra_cust_trx_line_gl_dist cm_rec,
1115: ra_cust_trx_line_gl_dist lgd,
1116: ra_customer_trx_lines ctl
1117: WHERE ct.customer_trx_id = ctl.customer_trx_id
1118: and ctl.customer_trx_id = lgd.customer_trx_id(+)
1119: and ''REC'' = lgd.account_class(+)
1120: and ''N'' = lgd.account_set_flag(+)

Line 1197: 'UPDATE ra_customer_trx_lines ctl

1193: ------------------------------------------------
1194: -- Construct the update lines sql
1195: ------------------------------------------------
1196: l_nonrule_update_lines_sql :=
1197: 'UPDATE ra_customer_trx_lines ctl
1198: SET autorule_complete_flag = '''',
1199: autorule_duration_processed = accounting_rule_duration
1200: WHERE ctl.accounting_rule_id is not null' || CRLF ||
1201: l_where_pred || CRLF ||

Line 1230: FROM ra_customer_trx_lines ctl

1226: and d.account_set_flag = ''Y''
1227: and d.customer_trx_id in
1228: (
1229: SELECT ctl.customer_trx_id
1230: FROM ra_customer_trx_lines ctl
1231: WHERE 1 = 1' || CRLF ||
1232: l_where_pred || CRLF ||
1233: ')
1234: and exists

Line 1283: ra_customer_trx_lines ctl,

1279: (ctl.extended_amount - sum(lgd2.amount) ) + lgd.amount,' || CRLF ||
1280: ' (' || l_amount_fragment || CRLF ||
1281: ' - sum(lgd2.acctd_amount)) + lgd.acctd_amount
1282: FROM
1283: ra_customer_trx_lines ctl,
1284: ra_customer_trx ct,
1285: ra_cust_trx_line_gl_dist lgd2
1286: WHERE ctl.customer_trx_line_id = lgd2.customer_trx_line_id
1287: and ctl.customer_trx_line_id = lgd.customer_trx_line_id

Line 1299: ra_customer_trx_lines ctl,

1295: WHERE lgd.cust_trx_line_gl_dist_id in
1296: (
1297: SELECT min(cust_trx_line_gl_dist_id)
1298: from
1299: ra_customer_trx_lines ctl,
1300: ra_customer_trx ct,
1301: ra_cust_trx_line_gl_dist lgd3
1302: where ctl.customer_trx_line_id = lgd3.customer_trx_line_id';
1303:

Line 1517: ra_customer_trx_lines inv,

1513: ra_cust_trx_line_gl_dist inv_rec,
1514: ra_cust_trx_line_gl_dist inv_rev,
1515: ra_cust_trx_types inv_type,
1516: ra_customer_trx inv_trx,
1517: ra_customer_trx_lines inv,
1518: ra_customer_trx cmt,
1519: ra_customer_trx_lines cm
1520: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id
1521: and inv.customer_trx_id = inv_trx.customer_trx_id

Line 1519: ra_customer_trx_lines cm

1515: ra_cust_trx_types inv_type,
1516: ra_customer_trx inv_trx,
1517: ra_customer_trx_lines inv,
1518: ra_customer_trx cmt,
1519: ra_customer_trx_lines cm
1520: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id
1521: and inv.customer_trx_id = inv_trx.customer_trx_id
1522: and inv_trx.cust_trx_type_id = inv_type.cust_trx_type_id
1523: and cm.customer_trx_id = cmt.customer_trx_id

Line 1573: 'UPDATE ra_customer_trx_lines l

1569: -- Build update cm lines sql
1570: ----------------------------------------------------
1571: /* Bug 2142941 - removed l_deferred_duration_sql and l_deferred_complete_sql */
1572: l_rule_update_cm_lines_sql :=
1573: 'UPDATE ra_customer_trx_lines l
1574: SET
1575: l.rule_start_date = :rule_start_date,
1576: l.rule_end_date = :rule_end_date,
1577: l.accounting_rule_duration = :cm_acct_rule_duration,

Line 1785: ra_customer_trx_lines ctl,

1781: lgd.collected_tax_concat_seg, /* collected tax seg */
1782: lgd.revenue_adjustment_id, /* revenue_adjustment_id */ /*Bug 2543675*/
1783: ct.org_id
1784: FROM
1785: ra_customer_trx_lines ctl,
1786: ra_customer_trx ct,
1787: fnd_currencies fc,
1788: ar_revenue_assignments_v ara /* Bug 2347001 */,
1789: ra_cust_trx_line_gl_dist inv_rec,

Line 1959: ra_customer_trx_lines ctl,

1955: ct.org_id
1956: FROM
1957: ra_cust_trx_line_gl_dist lgd,
1958: fnd_currencies fc,
1959: ra_customer_trx_lines ctl,
1960: ra_customer_trx ct,
1961: ra_customer_trx_lines ictl,
1962: ra_rules ir
1963: WHERE lgd.customer_trx_id = ct.customer_trx_id

Line 1961: ra_customer_trx_lines ictl,

1957: ra_cust_trx_line_gl_dist lgd,
1958: fnd_currencies fc,
1959: ra_customer_trx_lines ctl,
1960: ra_customer_trx ct,
1961: ra_customer_trx_lines ictl,
1962: ra_rules ir
1963: WHERE lgd.customer_trx_id = ct.customer_trx_id
1964: and lgd.customer_trx_line_id = :customer_trx_line_id_1
1965: and lgd.customer_trx_line_id = ctl.customer_trx_line_id

Line 2314: RA_CUSTOMER_TRX_LINES_ALL CTL,

2310:
2311: SELECT SUM(LGD.AMOUNT), MAX(SUBSTR(NVL(RR.TYPE, 'N'), 1, 1))
2312: INTO l_rev_count, l_rule_type
2313: FROM RA_CUST_TRX_LINE_GL_DIST LGD,
2314: RA_CUSTOMER_TRX_LINES_ALL CTL,
2315: RA_RULES RR
2316: WHERE LGD.CUSTOMER_TRX_LINE_ID = p_prev_cust_trx_line_id
2317: AND CTL.CUSTOMER_TRX_LINE_ID = LGD.CUSTOMER_TRX_LINE_ID
2318: AND CTL.ACCOUNTING_RULE_ID = RR.RULE_ID(+)

Line 2996: FROM ra_customer_trx_lines_all cmline,

2992: CURSOR lines (p_cm_line_id NUMBER) IS
2993: SELECT invline.accounting_rule_id,
2994: invline.rule_start_date,
2995: cmline.extended_amount line_amount
2996: FROM ra_customer_trx_lines_all cmline,
2997: ra_customer_trx_lines_all invline
2998: WHERE cmline.previous_customer_trx_line_id =
2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;

Line 2997: ra_customer_trx_lines_all invline

2993: SELECT invline.accounting_rule_id,
2994: invline.rule_start_date,
2995: cmline.extended_amount line_amount
2996: FROM ra_customer_trx_lines_all cmline,
2997: ra_customer_trx_lines_all invline
2998: WHERE cmline.previous_customer_trx_line_id =
2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:

Line 3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;

2999: invline.customer_trx_line_id
3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;

Line 3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;

3000: AND cmline.customer_trx_line_id = p_cm_line_id;
3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:

Line 3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;

3001:
3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:
3009: BEGIN

Line 3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;

3002: l_ignore INTEGER;
3003: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
3004: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
3005: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3006: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
3007: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
3008:
3009: BEGIN
3010:

Line 3502: FROM ra_customer_trx ct, ra_customer_trx_lines ctl

3498: ELSE
3499: BEGIN
3500: SELECT ct.invoicing_rule_id
3501: INTO l_rule_id
3502: FROM ra_customer_trx ct, ra_customer_trx_lines ctl
3503: WHERE ct.customer_trx_id = ctl.customer_trx_id
3504: AND ctl.customer_trx_line_id = p_line_id;
3505:
3506: l_result_flag := arp_util.validate_and_default_gl_date(

Line 5320: from ra_customer_trx_lines tl, ra_rules rl

5316: l_sum_dist NUMBER;
5317:
5318: CURSOR c1 IS
5319: select tl.customer_trx_id
5320: from ra_customer_trx_lines tl, ra_rules rl
5321: where tl.customer_trx_id = p_prev_customer_trx_id
5322: and tl.autorule_complete_flag = 'N'
5323: and tl.accounting_rule_id = rl.rule_id
5324: and substr(rl.type, 1,1) = 'P';

Line 5337: FROM ra_customer_trx_lines ctl,

5333: WHERE int.previous_customer_trx_id = ctlgd.customer_trx_id
5334: AND ctlgd.account_class = 'REC'
5335: AND ctlgd.account_set_flag = 'N')
5336: AND EXISTS (SELECT 1
5337: FROM ra_customer_trx_lines ctl,
5338: ra_rules rl
5339: WHERE ctl.customer_trx_id = int.previous_customer_trx_id
5340: AND ctl.accounting_rule_id = rl.rule_id
5341: AND substr(rl.type, 1,1) = 'P');