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_APPROVAL_PKG dependencies on AP_INVOICE_LINES_ALL

Line 438: FROM ap_invoice_lines_all

434: REFERENCE_KEY4,
435: REFERENCE_KEY5,
436: SHIP_TO_LOCATION_ID,
437: PAY_AWT_GROUP_ID --bug 7022001
438: FROM ap_invoice_lines_all
439: WHERE invoice_id = c_invoice_id
440: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;
441:
442: PROCEDURE initialize_invoice_holds(

Line 1841: FROM ap_invoice_lines_all

1837: RETURN BOOLEAN IS
1838:
1839: CURSOR get_gl_date IS
1840: SELECT distinct accounting_date acc_date
1841: FROM ap_invoice_lines_all
1842: WHERE invoice_id = p_invoice_id
1843: and NVL(generate_dists,'N') <> 'D';
1844:
1845: CURSOR get_inv_source IS

Line 2080: FROM ap_invoice_lines_all L

2076: --bugfix:4745464
2077: BEGIN
2078: SELECT 'Y'
2079: INTO l_undistributed_line_exists
2080: FROM ap_invoice_lines_all L
2081: WHERE L.invoice_id = p_invoice_id
2082: AND L.amount <>
2083: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
2084: FROM ap_invoice_distributions_all aid

Line 2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;

2414:
2415: --Bugfix:4673607
2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

Line 2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;

2415: --Bugfix:4673607
2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);

Line 2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;

2416: l_registration_api VARCHAR2(1000);
2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:

Line 2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;

2417: l_registration_view VARCHAR2(1000);
2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:
2425: BEGIN

Line 2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

2418: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
2419: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
2420: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
2421: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
2422: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
2423: l_err varchar2(2000);
2424:
2425: BEGIN
2426:

Line 3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D

3320: SELECT 'Distribution needs to be verified. '
3321: FROM DUAL
3322: WHERE EXISTS (
3323: SELECT 'Dist Total <> Invoice Line Amount'
3324: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
3325: -- WHERE AIL.invoice_id = D.invoice_id
3326: WHERE AIL.invoice_id = D.invoice_id(+)
3327: AND AIL.line_number = nvl(p_invoice_line_number, AIL.line_number) --bug6661773
3328: AND AIL.invoice_id = p_invoice_id

Line 3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A

3479:
3480:
3481: CURSOR Line_Var_Cur IS
3482: SELECT 'Line Total <> Invoice Amount'
3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A
3484: WHERE AIL.invoice_id = A.invoice_id
3485: AND AIL.invoice_id = p_invoice_id
3486: AND ((AIL.line_type_lookup_code <> 'TAX'
3487: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL

4051: -- in the invoice. The prepaid amount will include taxes.
4052:
4053: CURSOR Prepay_Var_Cur IS
4054: SELECT AI.invoice_amount, (0 - sum(nvl(AIL.amount,0)))
4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL
4056: WHERE AI.invoice_id = p_invoice_id
4057: AND AIL.invoice_id = AI.invoice_id
4058: AND AIL.invoice_includes_prepay_flag = 'N'
4059: AND AIL.line_type_lookup_code IN ('PREPAY', 'TAX')

Line 4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

4293: -- in the invoice
4294: CURSOR c_non_awt_dists_segs is
4295: SELECT ap_utilities_pkg.get_auto_offsets_segments(
4296: aid.dist_code_combination_id)
4297: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
4298: WHERE ail.invoice_id = p_invoice_id
4299: AND ail.invoice_id = aid.invoice_id
4300: AND ail.line_number = aid.invoice_line_number
4301: AND ((aid.line_type_lookup_code not in ('AWT','PREPAY')

Line 6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

5997: --bugfix:5638734
5998: -- Get the exculusive tax amount for the prepay appln line.
5999: SELECT sum(aid.amount)
6000: INTO l_prepay_excl_tax_amt
6001: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
6002: WHERE ail.line_type_lookup_code='TAX'
6003: AND ail.invoice_id=p_invoice_id
6004: AND aid.invoice_id=ail.invoice_id
6005: AND aid.invoice_line_number=ail.line_number

Line 7259: from ap_invoice_lines_all ail

7255: AND ai.validation_request_id IS NULL
7256: /*bug 7029877 Invoice saved but not submitted*/
7257: AND ai.approval_ready_flag <>'S'
7258: AND EXISTS (select ail.invoice_id
7259: from ap_invoice_lines_all ail
7260: where ail.invoice_id = ai.invoice_id) ;
7261:
7262: -- bug 6351170 -Added below if condition - Return if there are no invoices to process
7263: IF sql%rowcount = 0 THEN

Line 8512: FROM ap_invoice_lines_all ail

8508: BEGIN
8509:
8510: SELECT 'Y'
8511: INTO l_not_exist_nond_line
8512: FROM ap_invoice_lines_all ail
8513: WHERE ail.invoice_id = p_invoice_rec.invoice_id
8514: AND nvl(ail.generate_dists, 'N') <> 'D'
8515: AND rownum < 2;
8516:

Line 8592: FROM ap_invoice_lines_all

8588: ----------------------------------------------------------------
8589:
8590: SELECT nvl(prorate_across_all_items,'N')
8591: INTO l_prorate_across_all_items
8592: FROM ap_invoice_lines_all
8593: WHERE invoice_id = t_inv_lines_table(i).invoice_id
8594: AND line_number = t_inv_lines_table(i).line_number;
8595:
8596: IF (l_prorate_across_all_items='Y') then