APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_LINES_ALL

Line 256: ap_invoice_lines_all ail

252: If (X_LINE_NUMBER is null) then
253: SELECT NVL(SUM(aid.amount), 0)
254: INTO X_Total
255: FROM ap_invoice_distributions_all aid,
256: ap_invoice_lines_all ail
257: WHERE ail.invoice_id = X_Invoice_Id
258: AND ail.invoice_id = aid.invoice_id
259: AND ail.line_number = aid.invoice_line_number
260: AND ((aid.line_type_lookup_code NOT IN ('PREPAY', 'AWT', 'RETAINAGE')

Line 269: ap_invoice_lines_all ail

265: else
266: SELECT NVL(SUM(aid.amount), 0)
267: INTO X_Total
268: FROM ap_invoice_distributions_all aid,
269: ap_invoice_lines_all ail
270: WHERE ail.invoice_id = X_Invoice_Id
271: AND ail.invoice_id = aid.invoice_id
272: AND ail.line_number = aid.invoice_line_number
273: AND ail.line_number = X_LINE_NUMBER;

Line 3806: FROM ap_invoice_lines_all

3802: --bugfix:4674194
3803: SHIP_TO_LOCATION_ID,
3804: --bug7022001
3805: PAY_AWT_GROUP_ID
3806: FROM ap_invoice_lines_all
3807: WHERE invoice_id = X_invoice_id
3808: AND line_number = X_line_number;
3809:
3810:

Line 5436: l_chrg_line_rec ap_invoice_lines_all%rowtype;

5432: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
5433:
5434: -- Bug 5114543
5435: l_max_dist_line_num NUMBER :=0;
5436: l_chrg_line_rec ap_invoice_lines_all%rowtype;
5437: l_dummy VARCHAR2(30);
5438:
5439: BEGIN
5440:

Line 5540: from ap_invoice_lines_all ail

5536: -- continue with creation of charge distributions based on the allocation.
5537:
5538: select ail.*
5539: into l_chrg_line_rec
5540: from ap_invoice_lines_all ail
5541: where invoice_id = X_invoice_id
5542: and line_number = X_line_number;
5543:
5544: if not ap_invoice_lines_pkg.reverse_charge_distributions

Line 5625: FROM ap_invoice_lines_all ail,

5621: SELECT DECODE(NVL(ai.net_of_retainage_flag, 'N'),
5622: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
5623: SUM(ail.amount) )
5624: INTO l_sum_lines_amount
5625: FROM ap_invoice_lines_all ail,
5626: ap_invoices_all ai
5627: WHERE ai.invoice_id = ail.invoice_id
5628: AND ail.invoice_id = X_invoice_id
5629: AND ail.line_type_lookup_code NOT IN ('AWT')

Line 5662: FROM ap_invoice_lines_all AIL

5658:
5659: BEGIN
5660: SELECT count(*)
5661: INTO l_count_undistributed_lines
5662: FROM ap_invoice_lines_all AIL
5663: WHERE AIL.invoice_id = X_invoice_id
5664: AND AIL.line_type_lookup_code = 'ITEM'
5665: AND NVL(AIL.match_type,'NOT_MATCHED') NOT IN
5666: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')

Line 6562: from ap_invoice_lines_all ail,

6558: WHERE invoice_id = X_invoice_id
6559: AND chrg_invoice_line_number = X_line_number
6560: AND exists
6561: (select 'Line Amount Equals Distribution Total'
6562: from ap_invoice_lines_all ail,
6563: ap_invoice_distributions_all aid
6564: where ail.invoice_id = aid.invoice_id
6565: and ail.line_number = aid.invoice_line_number
6566: and ail.invoice_id = X_invoice_id

Line 7311: UPDATE ap_invoice_lines_all ail

7307: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
7308:
7309: l_line_number := l_line_number_tab(uniq_values);
7310:
7311: UPDATE ap_invoice_lines_all ail
7312: SET generate_dists = 'D'
7313: WHERE nvl(ail.generate_dists,'N') = 'Y'
7314: AND invoice_id = p_invoice_id
7315: AND ail.line_number = l_line_number_tab(uniq_values);