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

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 234: currency_code ra_customer_trx.invoice_currency_code%type,

230: allow_overapp_flag ra_cust_trx_types.allow_overapplication_flag%type,
231: cm_amount NUMBER,
232: credit_method_for_rules VARCHAR2(1),
233: last_period_to_credit NUMBER,
234: currency_code ra_customer_trx.invoice_currency_code%type,
235: inv_acct_rule_duration NUMBER,
236: allow_not_open_flag VARCHAR2(1),
237: partial_period_flag VARCHAR2(1),
238: cm_gl_date DATE,

Line 541: FROM ra_customer_trx_lines

537: l_delete_header_cma_sql :=
538: 'DELETE from ar_credit_memo_amounts
539: WHERE customer_trx_line_id in
540: (SELECT customer_trx_line_id
541: FROM ra_customer_trx_lines
542: WHERE line_type = ''LINE''
543: and customer_trx_id = :customer_trx_id)';
544:
545: debug(l_delete_header_cma_sql);

Line 558: 'UPDATE ra_customer_trx_lines

554: debug(' len(delete_line_cma_sql) = '||
555: to_char(lengthb(l_delete_line_cma_sql)));
556:
557: l_update_header_lines_sql :=
558: 'UPDATE ra_customer_trx_lines
559: SET
560: rule_start_date = null,
561: rule_end_date = null,
562: accounting_rule_duration = null

Line 571: 'UPDATE ra_customer_trx_lines

567: debug(' len(update_header_lines_sql) = '||
568: to_char(lengthb(l_update_header_lines_sql)));
569:
570: l_update_lines_sql :=
571: 'UPDATE ra_customer_trx_lines
572: SET
573: rule_start_date = null,
574: rule_end_date = null,
575: accounting_rule_duration = null

Line 943: ra_customer_trx ct,

939: ct.org_id
940: FROM
941: fnd_currencies foreign_fc,
942: ar_lookups al_rules,
943: ra_customer_trx ct,
944: ra_customer_trx_lines ctl,
945: ra_cust_trx_line_gl_dist ctlgd,
946: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
947: ra_cust_trx_line_salesreps ctls,

Line 944: ra_customer_trx_lines ctl,

940: FROM
941: fnd_currencies foreign_fc,
942: ar_lookups al_rules,
943: ra_customer_trx ct,
944: ra_customer_trx_lines ctl,
945: ra_cust_trx_line_gl_dist ctlgd,
946: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
947: ra_cust_trx_line_salesreps ctls,
948: ra_customer_trx prev_ct,

Line 948: ra_customer_trx prev_ct,

944: ra_customer_trx_lines ctl,
945: ra_cust_trx_line_gl_dist ctlgd,
946: ra_cust_trx_line_gl_dist rec_ctlgd, /* cm rec dist */
947: ra_cust_trx_line_salesreps ctls,
948: ra_customer_trx prev_ct,
949: ra_customer_trx_lines prev_ctl,
950: ra_cust_trx_line_gl_dist prev_ctlgd,
951: ra_cust_trx_line_gl_dist prev_ctlgd2 /* inv rec dist */
952: WHERE ct.customer_trx_id = ctl.customer_trx_id

Line 949: ra_customer_trx_lines prev_ctl,

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

Line 1104: ra_customer_trx ct,

1100: inv_rec.revenue_adjustment_id, /* Bug 2543675 */
1101: null, /* Bug 2560036 */
1102: ct.org_id
1103: FROM
1104: ra_customer_trx ct,
1105: ar_lookups al_rules,
1106: ra_cust_trx_line_gl_dist inv_rec,
1107: ra_cust_trx_line_gl_dist cm_rec,
1108: ra_cust_trx_line_gl_dist lgd,

Line 1109: ra_customer_trx_lines ctl

1105: ar_lookups al_rules,
1106: ra_cust_trx_line_gl_dist inv_rec,
1107: ra_cust_trx_line_gl_dist cm_rec,
1108: ra_cust_trx_line_gl_dist lgd,
1109: ra_customer_trx_lines ctl
1110: WHERE ct.customer_trx_id = ctl.customer_trx_id
1111: and ctl.customer_trx_id = lgd.customer_trx_id(+)
1112: and ''REC'' = lgd.account_class(+)
1113: and ''N'' = lgd.account_set_flag(+)

Line 1190: 'UPDATE ra_customer_trx_lines ctl

1186: ------------------------------------------------
1187: -- Construct the update lines sql
1188: ------------------------------------------------
1189: l_nonrule_update_lines_sql :=
1190: 'UPDATE ra_customer_trx_lines ctl
1191: SET autorule_complete_flag = '''',
1192: autorule_duration_processed = accounting_rule_duration
1193: WHERE ctl.accounting_rule_id is not null' || CRLF ||
1194: l_where_pred || CRLF ||

Line 1223: FROM ra_customer_trx_lines ctl

1219: and d.account_set_flag = ''Y''
1220: and d.customer_trx_id in
1221: (
1222: SELECT ctl.customer_trx_id
1223: FROM ra_customer_trx_lines ctl
1224: WHERE 1 = 1' || CRLF ||
1225: l_where_pred || CRLF ||
1226: ')
1227: and exists

Line 1276: ra_customer_trx_lines ctl,

1272: (ctl.extended_amount - sum(lgd2.amount) ) + lgd.amount,' || CRLF ||
1273: ' (' || l_amount_fragment || CRLF ||
1274: ' - sum(lgd2.acctd_amount)) + lgd.acctd_amount
1275: FROM
1276: ra_customer_trx_lines ctl,
1277: ra_customer_trx ct,
1278: ra_cust_trx_line_gl_dist lgd2
1279: WHERE ctl.customer_trx_line_id = lgd2.customer_trx_line_id
1280: and ctl.customer_trx_line_id = lgd.customer_trx_line_id

Line 1277: ra_customer_trx ct,

1273: ' (' || l_amount_fragment || CRLF ||
1274: ' - sum(lgd2.acctd_amount)) + lgd.acctd_amount
1275: FROM
1276: ra_customer_trx_lines ctl,
1277: ra_customer_trx ct,
1278: ra_cust_trx_line_gl_dist lgd2
1279: WHERE ctl.customer_trx_line_id = lgd2.customer_trx_line_id
1280: and ctl.customer_trx_line_id = lgd.customer_trx_line_id
1281: and ct.customer_trx_id = ctl.customer_trx_id

Line 1292: ra_customer_trx_lines ctl,

1288: WHERE lgd.cust_trx_line_gl_dist_id in
1289: (
1290: SELECT min(cust_trx_line_gl_dist_id)
1291: from
1292: ra_customer_trx_lines ctl,
1293: ra_customer_trx ct,
1294: ra_cust_trx_line_gl_dist lgd3
1295: where ctl.customer_trx_line_id = lgd3.customer_trx_line_id';
1296:

Line 1293: ra_customer_trx ct,

1289: (
1290: SELECT min(cust_trx_line_gl_dist_id)
1291: from
1292: ra_customer_trx_lines ctl,
1293: ra_customer_trx ct,
1294: ra_cust_trx_line_gl_dist lgd3
1295: where ctl.customer_trx_line_id = lgd3.customer_trx_line_id';
1296:
1297: IF( p_cm_control.customer_trx_id IS NULL ) then

Line 1508: ra_customer_trx inv_trx,

1504: ra_cust_trx_line_gl_dist cm_rec,
1505: ra_cust_trx_line_gl_dist inv_rec,
1506: ra_cust_trx_line_gl_dist inv_rev,
1507: ra_cust_trx_types inv_type,
1508: ra_customer_trx inv_trx,
1509: ra_customer_trx_lines inv,
1510: ra_customer_trx cmt,
1511: ra_customer_trx_lines cm
1512: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id

Line 1509: ra_customer_trx_lines inv,

1505: ra_cust_trx_line_gl_dist inv_rec,
1506: ra_cust_trx_line_gl_dist inv_rev,
1507: ra_cust_trx_types inv_type,
1508: ra_customer_trx inv_trx,
1509: ra_customer_trx_lines inv,
1510: ra_customer_trx cmt,
1511: ra_customer_trx_lines cm
1512: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id
1513: and inv.customer_trx_id = inv_trx.customer_trx_id

Line 1510: ra_customer_trx cmt,

1506: ra_cust_trx_line_gl_dist inv_rev,
1507: ra_cust_trx_types inv_type,
1508: ra_customer_trx inv_trx,
1509: ra_customer_trx_lines inv,
1510: ra_customer_trx cmt,
1511: ra_customer_trx_lines cm
1512: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id
1513: and inv.customer_trx_id = inv_trx.customer_trx_id
1514: and inv_trx.cust_trx_type_id = inv_type.cust_trx_type_id

Line 1511: ra_customer_trx_lines cm

1507: ra_cust_trx_types inv_type,
1508: ra_customer_trx inv_trx,
1509: ra_customer_trx_lines inv,
1510: ra_customer_trx cmt,
1511: ra_customer_trx_lines cm
1512: WHERE cm.previous_customer_trx_line_id = inv.customer_trx_line_id
1513: and inv.customer_trx_id = inv_trx.customer_trx_id
1514: and inv_trx.cust_trx_type_id = inv_type.cust_trx_type_id
1515: and cm.customer_trx_id = cmt.customer_trx_id

Line 1564: 'UPDATE ra_customer_trx_lines l

1560: -- Build update cm lines sql
1561: ----------------------------------------------------
1562: /* Bug 2142941 - removed l_deferred_duration_sql and l_deferred_complete_sql */
1563: l_rule_update_cm_lines_sql :=
1564: 'UPDATE ra_customer_trx_lines l
1565: SET
1566: l.rule_start_date = :rule_start_date,
1567: l.rule_end_date = :rule_end_date,
1568: l.accounting_rule_duration = :cm_acct_rule_duration,

Line 1773: ra_customer_trx_lines ctl,

1769: lgd.collected_tax_concat_seg, /* collected tax seg */
1770: lgd.revenue_adjustment_id, /* revenue_adjustment_id */ /*Bug 2543675*/
1771: ct.org_id
1772: FROM
1773: ra_customer_trx_lines ctl,
1774: ra_customer_trx ct,
1775: fnd_currencies fc,
1776: ar_revenue_assignments_v ara /* Bug 2347001 */,
1777: ra_cust_trx_line_gl_dist inv_rec,

Line 1774: ra_customer_trx ct,

1770: lgd.revenue_adjustment_id, /* revenue_adjustment_id */ /*Bug 2543675*/
1771: ct.org_id
1772: FROM
1773: ra_customer_trx_lines ctl,
1774: ra_customer_trx ct,
1775: fnd_currencies fc,
1776: ar_revenue_assignments_v ara /* Bug 2347001 */,
1777: ra_cust_trx_line_gl_dist inv_rec,
1778: ra_cust_trx_line_gl_dist lgd,

Line 1781: and ctl.previous_customer_trx_line_id = ara.customer_trx_line_id

1777: ra_cust_trx_line_gl_dist inv_rec,
1778: ra_cust_trx_line_gl_dist lgd,
1779: ra_cust_trx_line_salesreps ctls
1780: WHERE lgd.customer_trx_line_id = ctl.previous_customer_trx_line_id
1781: and ctl.previous_customer_trx_line_id = ara.customer_trx_line_id
1782: and ara.session_id in (:session_id, -99) /**Bug 2347001 */
1783: and ara.gl_date = nvl(lgd.original_gl_date, lgd.gl_date)
1784: and ara.account_class = lgd.account_class
1785: and ara.period_set_name = :period_set_name /* 4254587 */

Line 1945: ra_customer_trx_lines ctl,

1941: ct.org_id
1942: FROM
1943: ra_cust_trx_line_gl_dist lgd,
1944: fnd_currencies fc,
1945: ra_customer_trx_lines ctl,
1946: ra_customer_trx ct,
1947: ra_customer_trx_lines ictl,
1948: ra_rules ir
1949: WHERE lgd.customer_trx_id = ct.customer_trx_id

Line 1946: ra_customer_trx ct,

1942: FROM
1943: ra_cust_trx_line_gl_dist lgd,
1944: fnd_currencies fc,
1945: ra_customer_trx_lines ctl,
1946: ra_customer_trx ct,
1947: ra_customer_trx_lines ictl,
1948: ra_rules ir
1949: WHERE lgd.customer_trx_id = ct.customer_trx_id
1950: and lgd.customer_trx_line_id = :customer_trx_line_id_1

Line 1947: ra_customer_trx_lines ictl,

1943: ra_cust_trx_line_gl_dist lgd,
1944: fnd_currencies fc,
1945: ra_customer_trx_lines ctl,
1946: ra_customer_trx ct,
1947: ra_customer_trx_lines ictl,
1948: ra_rules ir
1949: WHERE lgd.customer_trx_id = ct.customer_trx_id
1950: and lgd.customer_trx_line_id = :customer_trx_line_id_1
1951: and lgd.customer_trx_line_id = ctl.customer_trx_line_id

Line 2141: ra_customer_trx trx,

2137: NULL, ''N'',
2138: ''Y'')
2139: ) /* inv dist exists */
2140: FROM ra_cust_trx_line_gl_dist lgd,
2141: ra_customer_trx trx,
2142: ar_cm_net_revenue_form cnr
2143: WHERE cnr.previous_customer_trx_line_id = :start_prev_ctlid
2144: and cnr.previous_customer_trx_line_id = lgd.customer_trx_line_id(+)
2145: and cnr.previous_customer_trx_id = trx.customer_trx_id

Line 2911: FROM ra_customer_trx_lines_all cmline,

2907: CURSOR lines (p_cm_line_id NUMBER) IS
2908: SELECT invline.accounting_rule_id,
2909: invline.rule_start_date,
2910: cmline.extended_amount line_amount
2911: FROM ra_customer_trx_lines_all cmline,
2912: ra_customer_trx_lines_all invline
2913: WHERE cmline.previous_customer_trx_line_id =
2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;

Line 2912: ra_customer_trx_lines_all invline

2908: SELECT invline.accounting_rule_id,
2909: invline.rule_start_date,
2910: cmline.extended_amount line_amount
2911: FROM ra_customer_trx_lines_all cmline,
2912: ra_customer_trx_lines_all invline
2913: WHERE cmline.previous_customer_trx_line_id =
2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:

Line 2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;

2914: invline.customer_trx_line_id
2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;

Line 2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;

2915: AND cmline.customer_trx_line_id = p_cm_line_id;
2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:

Line 2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;

2916:
2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:
2924: BEGIN

Line 2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;

2917: l_ignore INTEGER;
2918: l_accounting_rule_id ra_customer_trx_lines_all.accounting_rule_id%TYPE;
2919: l_line_amount ra_customer_trx_lines_all.extended_amount%TYPE;
2920: l_rule_start_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2921: l_original_gl_date ra_customer_trx_lines_all.rule_start_date%TYPE;
2922: gl_dist_id ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%TYPE;
2923:
2924: BEGIN
2925:

Line 3414: FROM ra_customer_trx ct, ra_customer_trx_lines ctl

3410: ELSE
3411: BEGIN
3412: SELECT invoicing_rule_id
3413: INTO l_rule_id
3414: FROM ra_customer_trx ct, ra_customer_trx_lines ctl
3415: WHERE ct.customer_trx_id = ctl.customer_trx_id
3416: AND ctl.customer_trx_line_id = p_line_id;
3417:
3418: l_result_flag := arp_util.validate_and_default_gl_date(

Line 5375: FROM ra_customer_trx trx

5371: BEGIN
5372:
5373: SELECT decode( trx.invoicing_rule_id, null, 'N', 'Y')
5374: INTO l_rule_flag
5375: FROM ra_customer_trx trx
5376: WHERE trx.customer_trx_id = p_customer_trx_id;
5377:
5378: EXCEPTION
5379: WHEN OTHERS THEN