APPS.ARP_ALLOCATION_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1041: from ra_cust_trx_line_gl_dist gld

1037: END IF;
1038:
1039: select gld.customer_trx_id
1040: into l_dummy
1041: from ra_cust_trx_line_gl_dist gld
1042: where gld.account_class = 'TAX'
1043: and gld.customer_trx_id = p_invoice_id
1044: and gld.collected_tax_ccid IS NOT NULL
1045: group by gld.customer_trx_id;

Line 1265: FROM ra_cust_trx_line_gl_dist b,

1261: 0,max(b.code_combination_id), -- If no REV row, pick max of ccid as usual
1262: max(decode(b.account_class,'REV',b.code_combination_id,0))
1263: ),
1264: ctl.ae_cust_trx_line_gl_dist_id
1265: FROM ra_cust_trx_line_gl_dist b,
1266: ar_ae_alloc_rec_gt ctl
1267: WHERE ctl.ae_tax_link_id = b.customer_trx_line_id
1268: AND ctl.ae_account_class = 'TAX'
1269: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;

Line 1478: ra_cust_trx_line_gl_dist gld,

1474: det.from_acctd_amount ae_from_pro_acctd_amt,
1475: det.ccid ref_dist_ccid,
1476: det.ref_mf_dist_flag
1477: FROM ra_customer_trx_lines ctl,
1478: ra_cust_trx_line_gl_dist gld,
1479: ra_customer_trx_lines line,
1480: ar_line_app_detail_gt det
1481: where ctl.customer_trx_id = p_invoice_id
1482: and ctl.line_type = 'TAX'

Line 2012: ra_cust_trx_line_gl_dist gld,

2008: det.ccid ref_dist_ccid,
2009: det.ref_mf_dist_flag ref_mf_dist_flag
2010: --}
2011: from ra_customer_trx_lines ctl,
2012: ra_cust_trx_line_gl_dist gld,
2013: ar_line_app_detail_gt det,
2014: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
2015: max(decode(g_ae_rule_rec.gl_account_source1,
2016: 'TAX_CODE_ON_INVOICE',

Line 2091: ra_cust_trx_line_gl_dist gld

2087: 'UNEDISC'),
2088: ''),
2089: '')) override_ccid2
2090: from ra_customer_trx_lines ctl,
2091: ra_cust_trx_line_gl_dist gld
2092: where gld.customer_trx_line_id = ctl.customer_trx_line_id
2093: and gld.account_set_flag = 'N'
2094: and ctl.customer_trx_id = p_invoice_id
2095: and ctl.rowid in

Line 2374: ra_cust_trx_line_gl_dist gld

2370: 'UNEDISC'),
2371: ''),
2372: '')) override_ccid2
2373: from ra_customer_trx_lines ctl,
2374: ra_cust_trx_line_gl_dist gld
2375: where gld.customer_trx_line_id = ctl.customer_trx_line_id
2376: and gld.account_set_flag = 'N'
2377: and ctl.customer_trx_id = p_invoice_id
2378: and ctl.rowid in

Line 2480: FROM ra_cust_trx_line_gl_dist

2476: code_combination_id
2477: INTO g_ae_rule_rec.receivable_amt,
2478: g_ae_rule_rec.receivable_acctd_amt,
2479: g_ae_rule_rec.receivable_account
2480: FROM ra_cust_trx_line_gl_dist
2481: where customer_trx_id = p_invoice_id
2482: AND account_class = 'REC'
2483: and latest_rec_flag = 'Y';
2484: END IF;

Line 6228: ra_cust_trx_line_gl_dist d

6224: ,d.code_combination_id actual_tax_ccid
6225: ,ae1.ae_unedisc_ccid
6226: ,ae1.ae_edisc_ccid
6227: FROM ar_ae_alloc_rec_gt ae1,
6228: ra_cust_trx_line_gl_dist d
6229: WHERE ae1.ae_id = g_id
6230: AND ae1.ae_account_class = 'TAX'
6231: AND ae1.ae_cust_trx_line_gl_dist_id = d.cust_trx_line_gl_dist_id(+);
6232: