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_LINES

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 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 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 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: