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_CUST_TRX_LINE_GL_DIST

Line 162: ra_cust_trx_line_gl_dist lgd,

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(+)
166: AND ctl.customer_trx_line_id = lgd.customer_trx_line_id(+)

Line 215: FROM ra_cust_trx_line_gl_dist lgd

211: DECODE( lgd.cust_trx_line_gl_dist_id,
212: NULL, 'AR_TW_NO_REC_SETS',
213: 'AR_TW_BAD_REC_SETS')
214: ) message_name
215: FROM ra_cust_trx_line_gl_dist lgd
216: WHERE lgd.customer_trx_id = p_customer_trx_id
217: AND lgd.account_class = 'REC'
218: AND lgd.latest_rec_flag = 'Y'
219: AND (

Line 724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
722:
723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
726: l_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
727: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
728:

Line 725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
722:
723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
726: l_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
727: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
728:
729: l_commit_amount number;

Line 726: l_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

722:
723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
726: l_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
727: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
728:
729: l_commit_amount number;
730: l_trx_amount number;

Line 727: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
726: l_prev_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
727: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
728:
729: l_commit_amount number;
730: l_trx_amount number;
731: l_commitment_balance number;

Line 766: l_gl_account_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;

762: l_commit_tax_amount NUMBER;
763: l_commit_frt_amount NUMBER;
764:
765: --Bug Fix: 3261620 Begin#1
766: l_gl_account_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
767: l_dist_gl_date DATE;
768: --Bug Fix: 3261620 End#1
769: /* Bug fix 5444418 */
770: l_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

Line 770: l_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;

766: l_gl_account_ccid ra_cust_trx_line_gl_dist.code_combination_id%type;
767: l_dist_gl_date DATE;
768: --Bug Fix: 3261620 End#1
769: /* Bug fix 5444418 */
770: l_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
771: l_account_set_flag ra_cust_trx_line_gl_dist.account_set_flag%TYPE;
772: l_revrec_complete varchar2(1);
773: /*bug 2836430*/
774: CURSOR salesrep_check IS

Line 771: l_account_set_flag ra_cust_trx_line_gl_dist.account_set_flag%TYPE;

767: l_dist_gl_date DATE;
768: --Bug Fix: 3261620 End#1
769: /* Bug fix 5444418 */
770: l_account_class ra_cust_trx_line_gl_dist.account_class%TYPE;
771: l_account_set_flag ra_cust_trx_line_gl_dist.account_set_flag%TYPE;
772: l_revrec_complete varchar2(1);
773: /*bug 2836430*/
774: CURSOR salesrep_check IS
775: SELECT l.line_number line_number,

Line 820: FROM ra_cust_trx_line_gl_dist

816: CURSOR gl_account_ccid_cur IS
817: /* modified bug5444418*/
818: SELECT DISTINCT code_combination_id , gl_date, account_class,
819: account_set_flag
820: FROM ra_cust_trx_line_gl_dist
821: WHERE customer_trx_id = p_customer_trx_id;
822: --Bug Fix: 3261620 End#2
823:
824: /* Bug3185358 */

Line 888: FROM ra_cust_trx_line_gl_dist lgd_trx

884: SELECT lgd_trx.gl_date,
885: lgd_trx.amount
886: INTO l_trx_gl_date,
887: l_trx_amount
888: FROM ra_cust_trx_line_gl_dist lgd_trx
889: WHERE lgd_trx.customer_trx_id = l_trx_rec.customer_trx_id
890: AND lgd_trx.latest_rec_flag = 'Y'
891: AND lgd_trx.account_class = 'REC';
892:

Line 920: FROM ra_cust_trx_line_gl_dist lgd_trx

916: SELECT lgd_trx.gl_date,
917: lgd_trx.amount
918: INTO l_commit_gl_date,
919: l_commit_amount
920: FROM ra_cust_trx_line_gl_dist lgd_trx
921: WHERE lgd_trx.customer_trx_id = l_trx_rec.initial_customer_trx_id
922: AND lgd_trx.latest_rec_flag = 'Y'
923: AND lgd_trx.account_class = 'REC';
924:

Line 1411: ra_cust_trx_line_gl_dist d

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');
1415: IF ( l_rule_flag ='Y')

Line 1566: FROM ra_cust_trx_line_gl_dist lgd_trx

1562: l_trx_rec.previous_customer_trx_id);
1563:
1564: SELECT lgd_trx.gl_date
1565: INTO l_prev_gl_date
1566: FROM ra_cust_trx_line_gl_dist lgd_trx
1567: WHERE lgd_trx.customer_trx_id = l_trx_rec.previous_customer_trx_id
1568: AND lgd_trx.latest_rec_flag = 'Y'
1569: AND lgd_trx.account_class = 'REC';
1570:

Line 2070: from ra_cust_trx_line_gl_dist

2066: Check if the transaction is revenue recognized */
2067:
2068: select decode(account_set_flag,'Y','N','N','Y','Y')
2069: into l_revrec_complete
2070: from ra_cust_trx_line_gl_dist
2071: where customer_trx_id = p_customer_trx_id
2072: and account_class = 'REC'
2073: and latest_rec_flag = 'Y';
2074: