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_TRX_COMPLETE_CHK dependencies on RA_CUSTOMER_TRX

Line 160: FROM ra_customer_trx_lines ctl_line,

156: )
157: )
158: )
159: ) message_name
160: FROM ra_customer_trx_lines ctl_line,
161: ra_customer_trx_lines ctl,
162: ra_cust_trx_line_gl_dist lgd,
163: ra_customer_trx ct
164: WHERE ct.customer_trx_id = p_customer_trx_id

Line 161: ra_customer_trx_lines ctl,

157: )
158: )
159: ) message_name
160: FROM ra_customer_trx_lines ctl_line,
161: ra_customer_trx_lines ctl,
162: ra_cust_trx_line_gl_dist lgd,
163: ra_customer_trx ct
164: WHERE ct.customer_trx_id = p_customer_trx_id
165: AND ct.customer_trx_id = ctl.customer_trx_id(+)

Line 163: ra_customer_trx ct

159: ) message_name
160: FROM ra_customer_trx_lines ctl_line,
161: ra_customer_trx_lines ctl,
162: ra_cust_trx_line_gl_dist lgd,
163: ra_customer_trx ct
164: WHERE ct.customer_trx_id = p_customer_trx_id
165: AND ct.customer_trx_id = ctl.customer_trx_id(+)
166: AND ctl.customer_trx_line_id = lgd.customer_trx_line_id(+)
167: AND ctl.link_to_cust_trx_line_id = ctl_line.customer_trx_line_id(+)

Line 468: FROM ra_customer_trx ct,

464: ct.invoicing_rule_id invoicing_rule_id,
465: ctt.type class,
466: ctt.tax_calculation_flag tax_calculation_flag,
467: ct.customer_trx_id customer_trx_id
468: FROM ra_customer_trx ct,
469: ra_cust_trx_types ctt
470: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
471: AND ct.customer_trx_id IN (' || p_query_string || ')';
472:

Line 677: ra_customer_trx.customer_trx_id%type,

673: +===========================================================================*/
674:
675: PROCEDURE do_completion_checking(
676: p_customer_trx_id IN
677: ra_customer_trx.customer_trx_id%type,
678: p_so_source_code IN varchar2,
679: p_so_installed_flag IN varchar2,
680: p_error_count OUT NOCOPY number
681: ) IS

Line 699: ra_customer_trx.customer_trx_id%type,

695: END;
696:
697: PROCEDURE do_completion_checking(
698: p_customer_trx_id IN
699: ra_customer_trx.customer_trx_id%type,
700: p_so_source_code IN varchar2,
701: p_so_installed_flag IN varchar2,
702: p_error_mode IN VARCHAR2,
703: p_error_count OUT NOCOPY number,

Line 708: l_trx_rec ra_customer_trx%rowtype;

704: p_check_tax_acct IN VARCHAR2 DEFAULT 'B'
705: ) IS
706:
707:
708: l_trx_rec ra_customer_trx%rowtype;
709: l_prev_trx_rec ra_customer_trx%rowtype;
710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;

Line 709: l_prev_trx_rec ra_customer_trx%rowtype;

705: ) IS
706:
707:
708: l_trx_rec ra_customer_trx%rowtype;
709: l_prev_trx_rec ra_customer_trx%rowtype;
710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;

Line 710: l_commit_trx_rec ra_customer_trx%rowtype;

706:
707:
708: l_trx_rec ra_customer_trx%rowtype;
709: l_prev_trx_rec ra_customer_trx%rowtype;
710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;
714: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 778: FROM ra_customer_trx_lines l,

774: CURSOR salesrep_check IS
775: SELECT l.line_number line_number,
776: l.customer_trx_line_id customer_trx_line_id,
777: round(SUM(s.revenue_percent_split),4) error_amount
778: FROM ra_customer_trx_lines l,
779: ra_cust_trx_line_salesreps s
780: WHERE pg_salesrep_required_flag = 'Y'
781: AND l.customer_trx_id = p_customer_trx_id
782: AND l.customer_trx_line_id = s.customer_trx_line_id(+)

Line 791: FROM ra_customer_trx_lines l,

787: UNION
788: SELECT l.line_number line_number,
789: l.customer_trx_line_id customer_trx_line_id,
790: round(SUM(s.revenue_percent_split),4) error_amount
791: FROM ra_customer_trx_lines l,
792: ra_cust_trx_line_salesreps s
793: WHERE pg_salesrep_required_flag = 'N'
794: AND l.customer_trx_id = p_customer_trx_id
795: AND l.customer_trx_line_id = s.customer_trx_line_id

Line 805: FROM ra_customer_trx_lines l

801: ORDER BY 1,3,2;
802:
803: CURSOR rule_check IS
804: SELECT l.line_number line_number
805: FROM ra_customer_trx_lines l
806: WHERE l.customer_trx_id = p_customer_trx_id
807: AND (
808: l.accounting_rule_id IS NULL
809: OR

Line 1013: FROM ra_customer_trx_lines

1009: END IF;
1010:
1011: SELECT COUNT(*)
1012: INTO l_result
1013: FROM ra_customer_trx_lines
1014: WHERE customer_trx_id = p_customer_trx_id;
1015:
1016: IF (l_result < 1)
1017: THEN

Line 1053: ra_customer_trx_lines cl,

1049:
1050: SELECT count(*)
1051: INTO l_result
1052: FROM ra_terms tm,
1053: ra_customer_trx_lines cl,
1054: ra_customer_trx cs,
1055: zx_lines zl,
1056: zx_formula_b zf
1057: WHERE cs.customer_trx_id = p_customer_trx_id

Line 1054: ra_customer_trx cs,

1050: SELECT count(*)
1051: INTO l_result
1052: FROM ra_terms tm,
1053: ra_customer_trx_lines cl,
1054: ra_customer_trx cs,
1055: zx_lines zl,
1056: zx_formula_b zf
1057: WHERE cs.customer_trx_id = p_customer_trx_id
1058: AND cs.term_id = tm.term_id

Line 1410: FROM ra_customer_trx trx,

1406: SELECT decode( max(d.customer_trx_id),
1407: null, 'N',
1408: 'Y')
1409: INTO l_rule_flag
1410: FROM ra_customer_trx trx,
1411: ra_cust_trx_line_gl_dist d
1412: WHERE trx.customer_trx_id = l_trx_rec.customer_trx_id
1413: and trx.previous_customer_trx_id = d.customer_trx_id
1414: and d.account_class in ('UNEARN', 'UNBILL');

Line 1606: FROM ra_customer_trx_lines ctl

1602: )
1603: INTO l_line_amount,
1604: l_tax_amount,
1605: l_freight_amount
1606: FROM ra_customer_trx_lines ctl
1607: WHERE customer_trx_id = l_trx_rec.customer_trx_id;
1608:
1609:
1610: /*-------------------------------------------------+

Line 2000: FROM ra_customer_trx other_ct,

1996: arp_util.debug( 'check for later credit memos');
1997: END IF;
1998: SELECT MAX( other_ct.customer_trx_id )
1999: INTO l_result
2000: FROM ra_customer_trx other_ct,
2001: ra_customer_trx this_ct
2002: WHERE this_ct.customer_trx_id = p_customer_trx_id
2003: AND other_ct.previous_customer_trx_id =
2004: this_ct.previous_customer_trx_id

Line 2001: ra_customer_trx this_ct

1997: END IF;
1998: SELECT MAX( other_ct.customer_trx_id )
1999: INTO l_result
2000: FROM ra_customer_trx other_ct,
2001: ra_customer_trx this_ct
2002: WHERE this_ct.customer_trx_id = p_customer_trx_id
2003: AND other_ct.previous_customer_trx_id =
2004: this_ct.previous_customer_trx_id
2005: AND other_ct.customer_trx_id <> this_ct.customer_trx_id

Line 2159: ra_customer_trx.customer_trx_id%type,

2155:
2156: /* Bug 3185358 */
2157: PROCEDURE dm_reversal_amount_chk(
2158: p_customer_trx_id IN
2159: ra_customer_trx.customer_trx_id%type,
2160: p_reversed_cash_receipt_id IN
2161: ra_customer_trx.reversed_cash_receipt_id%type,
2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;

Line 2161: ra_customer_trx.reversed_cash_receipt_id%type,

2157: PROCEDURE dm_reversal_amount_chk(
2158: p_customer_trx_id IN
2159: ra_customer_trx.customer_trx_id%type,
2160: p_reversed_cash_receipt_id IN
2161: ra_customer_trx.reversed_cash_receipt_id%type,
2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;

Line 2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;

2159: ra_customer_trx.customer_trx_id%type,
2160: p_reversed_cash_receipt_id IN
2161: ra_customer_trx.reversed_cash_receipt_id%type,
2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;

Line 2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;

2160: p_reversed_cash_receipt_id IN
2161: ra_customer_trx.reversed_cash_receipt_id%type,
2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;
2168: BEGIN

Line 2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;

2161: ra_customer_trx.reversed_cash_receipt_id%type,
2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;
2168: BEGIN
2169: /* step 1: Fetch the original receipt amount from ar_cash_receipts

Line 2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;

2162: p_status OUT NOCOPY VARCHAR2) IS
2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;
2168: BEGIN
2169: /* step 1: Fetch the original receipt amount from ar_cash_receipts
2170: step 2: Fetch total amount from trx (dm)

Line 2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;

2163: l_original_amount ra_customer_trx_lines.gross_extended_amount%type;
2164: l_dm_amount ra_customer_trx_lines.gross_extended_amount%type;
2165: line_amount ra_customer_trx_lines.gross_extended_amount%type;
2166: tax_amount ra_customer_trx_lines.gross_extended_amount%type;
2167: frt_amount ra_customer_trx_lines.gross_extended_amount%type;
2168: BEGIN
2169: /* step 1: Fetch the original receipt amount from ar_cash_receipts
2170: step 2: Fetch total amount from trx (dm)
2171: step 3: compare .

Line 2202: ra_customer_trx_lines ctl

2198: line_amount,
2199: tax_amount,
2200: frt_amount
2201: FROM
2202: ra_customer_trx_lines ctl
2203: WHERE ctl.customer_trx_id = p_customer_trx_id;
2204:
2205: l_dm_amount:=nvl(line_amount,0)+nvl(tax_amount,0)+nvl(frt_amount,0);
2206: