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.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 738: l_line_type_lookup_code ap_invoice_lines_all.line_type_lookup_code%TYPE; --Bug16324208

734: --Bug#10241241
735: l_set_of_books_id NUMBER;
736: l_chart_of_accounts_id NUMBER;
737: l_dist_updated NUMBER;
738: l_line_type_lookup_code ap_invoice_lines_all.line_type_lookup_code%TYPE; --Bug16324208
739:
740: BEGIN
741:
742: --------------------------------------------------------------------------

Line 757: FROM ap_invoice_lines_all

753: debug_info := 'Get line_type_lookup_code';
754: BEGIN
755: SELECT line_type_lookup_code
756: INTO l_line_type_lookup_code
757: FROM ap_invoice_lines_all
758: WHERE invoice_id = X_invoice_id
759: AND line_number = X_line_number;
760:
761: EXCEPTION

Line 3976: FROM ap_invoice_lines_all

3972: --bugfix:4674194
3973: SHIP_TO_LOCATION_ID,
3974: --bug7022001
3975: PAY_AWT_GROUP_ID
3976: FROM ap_invoice_lines_all
3977: WHERE invoice_id = X_invoice_id
3978: AND line_number = X_line_number;
3979:
3980:

Line 5225: FROM ap_invoice_lines_all

5221: , REFERENCE_KEY4
5222: , REFERENCE_KEY5
5223: , SHIP_TO_LOCATION_ID
5224: , PAY_AWT_GROUP_ID
5225: FROM ap_invoice_lines_all
5226: WHERE invoice_id = X_invoice_id
5227: AND line_number = X_line_number;
5228:
5229:

Line 6802: l_chrg_line_rec ap_invoice_lines_all%rowtype;

6798: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
6799:
6800: -- Bug 5114543
6801: l_max_dist_line_num NUMBER :=0;
6802: l_chrg_line_rec ap_invoice_lines_all%rowtype;
6803: l_dummy VARCHAR2(30);
6804:
6805: l_country_code VARCHAR2(20); --bug 9169915
6806: l_stat_amount AP_INVOICE_LINES.STAT_AMOUNT%TYPE; --Bug#10241241

Line 6977: from ap_invoice_lines_all ail

6973: -- continue with creation of charge distributions based on the allocation.
6974:
6975: select ail.*
6976: into l_chrg_line_rec
6977: from ap_invoice_lines_all ail
6978: where invoice_id = X_invoice_id
6979: and line_number = X_line_number;
6980:
6981: if not ap_invoice_lines_pkg.reverse_charge_distributions

Line 7062: FROM ap_invoice_lines_all ail,

7058: SELECT DECODE(NVL(ai.net_of_retainage_flag, 'N'),
7059: 'Y', (SUM(NVL(ail.amount, 0)) + SUM(NVL(retained_amount,0))),
7060: SUM(ail.amount) )
7061: INTO l_sum_lines_amount
7062: FROM ap_invoice_lines_all ail,
7063: ap_invoices_all ai
7064: WHERE ai.invoice_id = ail.invoice_id
7065: AND ail.invoice_id = X_invoice_id
7066: AND ail.line_type_lookup_code NOT IN ('AWT')

Line 7099: FROM ap_invoice_lines_all AIL

7095:
7096: BEGIN
7097: SELECT count(*)
7098: INTO l_count_undistributed_lines
7099: FROM ap_invoice_lines_all AIL
7100: WHERE AIL.invoice_id = X_invoice_id
7101: AND AIL.line_type_lookup_code = 'ITEM'
7102: AND NVL(AIL.match_type,'NOT_MATCHED') NOT IN
7103: ('PRICE_CORRECTION', 'QTY_CORRECTION','LINE_CORRECTION','AMOUNT_CORRECTION')

Line 8057: from ap_invoice_lines_all ail,

8053: WHERE invoice_id = X_invoice_id
8054: AND chrg_invoice_line_number = X_line_number
8055: AND exists
8056: (select 'Line Amount Equals Distribution Total'
8057: from ap_invoice_lines_all ail,
8058: ap_invoice_distributions_all aid
8059: where ail.invoice_id = aid.invoice_id
8060: and ail.line_number = aid.invoice_line_number
8061: and ail.invoice_id = X_invoice_id

Line 8353: AP_INVOICE_LINES_ALL ail --bug#10416960

8349: po_line_types PLT, -- Amount Based Matching
8350: po_line_locations PLL,
8351: rcv_transactions RTXN,
8352: rcv_shipment_lines RSL,
8353: AP_INVOICE_LINES_ALL ail --bug#10416960
8354: WHERE AI.invoice_id = D.invoice_id
8355: AND D.invoice_distribution_id = X_distribution_id
8356: AND AIL.invoice_id = D.invoice_id
8357: AND AIL.line_number=D.invoice_line_number

Line 9153: UPDATE ap_invoice_lines_all ail

9149: FOR uniq_values IN 1 .. l_line_number_tab.count LOOP
9150:
9151: l_line_number := l_line_number_tab(uniq_values);
9152:
9153: UPDATE ap_invoice_lines_all ail
9154: SET generate_dists = 'D'
9155: WHERE nvl(ail.generate_dists,'N') = 'Y'
9156: AND invoice_id = p_invoice_id
9157: AND ail.line_number = l_line_number_tab(uniq_values);