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

Line 42: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

38:
39: PROCEDURE Get_Doc_Entitity_Data (
40: p_level IN VARCHAR2 ,
41: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,
42: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
43: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
44: p_rule_rec OUT NOCOPY ae_rule_rec_type ,
45: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE );
46:

Line 55: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

51: p_gt_id IN NUMBER DEFAULT NULL);
52: -- Added parameter for Line Level Adjustment
53: PROCEDURE Create_Ae_Lines_ADJ(
54: p_adj_rec IN ar_adjustments%ROWTYPE ,
55: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
56: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
57: p_rule_rec IN ae_rule_rec_type ,
58: p_ard_rec IN ar_distributions%ROWTYPE ,
59: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,

Line 663: ra_customer_trx ctinv

659: ctinv.bill_to_site_use_id bill_to_site_use_id,
660: ctinv.drawee_id drawee_id,
661: ctinv.drawee_site_use_id drawee_site_use_id
662: from ar_adjustments adj,
663: ra_customer_trx ctinv
664: where adj.adjustment_id = g_ae_doc_rec.source_id_old
665: and adj.status = 'A'
666: and g_ae_doc_rec.source_table = 'ADJ'
667: and adj.customer_trx_id = ctinv.customer_trx_id;

Line 672: l_cust_inv_rec ra_customer_trx%ROWTYPE;

668:
669: l_ael_line_rec ae_line_rec_type;
670: l_ael_empty_line_rec ae_line_rec_type;
671: i BINARY_INTEGER := 1;
672: l_cust_inv_rec ra_customer_trx%ROWTYPE;
673: l_customer_trx_id NUMBER;
674: l_amount NUMBER;
675: l_acctd_amount NUMBER;
676: --{3377004

Line 806: UPDATE ra_customer_trx_lines

802:
803: --{3377004
804: IF l_index <> 0 THEN
805: FORALL m IN l_ctl_rem_amt.customer_trx_line_id.FIRST .. l_ctl_rem_amt.customer_trx_line_id.LAST
806: UPDATE ra_customer_trx_lines
807: SET AMOUNT_DUE_REMAINING = AMOUNT_DUE_REMAINING + l_ctl_rem_amt.amount_due_remaining(m),
808: ACCTD_AMOUNT_DUE_REMAINING = ACCTD_AMOUNT_DUE_REMAINING + l_ctl_rem_amt.acctd_amount_due_remaining(m),
809: CHRG_AMOUNT_REMAINING = CHRG_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_amount_remaining(m),
810: CHRG_ACCTD_AMOUNT_REMAINING = CHRG_ACCTD_AMOUNT_REMAINING + l_ctl_rem_amt.chrg_acctd_amount_remaining(m)

Line 897: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,

893: * ======================================================================*/
894: PROCEDURE Get_Doc_Entitity_Data (
895: p_level IN VARCHAR2 ,
896: p_adj_rec OUT NOCOPY ar_adjustments%ROWTYPE ,
897: p_cust_inv_rec OUT NOCOPY ra_customer_trx%ROWTYPE ,
898: p_ctlgd_inv_rec OUT NOCOPY ra_cust_trx_line_gl_dist%ROWTYPE ,
899: p_rule_rec OUT NOCOPY ae_rule_rec_type ,
900: p_ard_rec OUT NOCOPY ar_distributions%ROWTYPE ) IS
901:

Line 1030: ra_customer_trx ctinv ,

1026: p_rule_rec.act_vat_tax_id2
1027: from ar_adjustments adj ,
1028: ar_receivables_trx rt ,
1029: ar_rec_trx_le_details rtd ,
1030: ra_customer_trx ctinv ,
1031: ra_cust_trx_line_gl_dist ctlgdinv
1032: where adj.adjustment_id = g_ae_doc_rec.source_id
1033: and adj.status = 'A' --only approved adjustments
1034: and adj.receivables_trx_id = rt.receivables_trx_id

Line 1149: ra_customer_trx ctinv ,

1145: p_rule_rec.act_tax_non_rec_ccid2 ,
1146: p_rule_rec.act_vat_tax_id2
1147: from ar_adjustments adj ,
1148: ar_receivables_trx rt ,
1149: ra_customer_trx ctinv ,
1150: ra_cust_trx_line_gl_dist ctlgdinv
1151: where adj.adjustment_id = g_ae_doc_rec.source_id
1152: and adj.status = 'A' --only approved adjustments
1153: and adj.receivables_trx_id = rt.receivables_trx_id

Line 1386: l_cust_inv_rec ra_customer_trx%ROWTYPE ;

1382: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
1383: p_gt_id IN NUMBER DEFAULT NULL) IS
1384:
1385: l_adj_rec ar_adjustments%ROWTYPE ;
1386: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1387: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1388: l_rule_rec ae_rule_rec_type ;
1389: l_ard_rec ar_distributions%ROWTYPE ;
1390: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;

Line 1390: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;

1386: l_cust_inv_rec ra_customer_trx%ROWTYPE ;
1387: l_ctlgd_inv_rec ra_cust_trx_line_gl_dist%ROWTYPE ;
1388: l_rule_rec ae_rule_rec_type ;
1389: l_ard_rec ar_distributions%ROWTYPE ;
1390: l_tmp_upg_method ra_customer_trx.upgrade_method%TYPE;
1391:
1392: BEGIN
1393:
1394: IF PG_DEBUG in ('Y', 'C') THEN

Line 1472: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,

1468: | p_ard_rec Distributions record used by Bills Receivable
1469: * ======================================================================*/
1470: PROCEDURE Create_Ae_Lines_ADJ(
1471: p_adj_rec IN ar_adjustments%ROWTYPE ,
1472: p_cust_inv_rec IN ra_customer_trx%ROWTYPE ,
1473: p_ctlgd_inv_rec IN ra_cust_trx_line_gl_dist%ROWTYPE ,
1474: p_rule_rec IN ae_rule_rec_type ,
1475: p_ard_rec IN ar_distributions%ROWTYPE ,
1476: p_from_llca_call IN VARCHAR2 DEFAULT 'N' ,

Line 1743: FROM ra_customer_trx_lines ctl,

1739: min(decode(alv.location_segment_id,
1740: '',avt.adj_non_rec_tax_ccid,
1741: alv.adj_non_rec_tax_ccid))
1742: into l_code_combination_id
1743: FROM ra_customer_trx_lines ctl,
1744: ar_vat_tax avt,
1745: ar_location_accounts alv
1746: where ctl.customer_trx_id = p_adj_rec.customer_trx_id
1747: and ctl.line_type = 'TAX'