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 452: FROM ap_invoice_lines_all

448: REFERENCE_KEY4,
449: REFERENCE_KEY5,
450: SHIP_TO_LOCATION_ID,
451: PAY_AWT_GROUP_ID --bug 7022001
452: FROM ap_invoice_lines_all
453: WHERE invoice_id = c_invoice_id
454: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;
455:
456: --Bug 8346277

Line 612: FROM ap_invoice_lines_all

608: , REFERENCE_KEY4
609: , REFERENCE_KEY5
610: , SHIP_TO_LOCATION_ID
611: , PAY_AWT_GROUP_ID
612: FROM ap_invoice_lines_all
613: WHERE invoice_id = c_invoice_id
614: AND line_type_lookup_code = 'AWT'
615: AND line_source = 'MANUAL LINE ENTRY'
616: ORDER BY line_number;

Line 1290: FROM ap_invoice_lines_all ail

1286: -- Bug 8346277 start
1287: l_manual_awt_exist:=0;
1288: SELECT COUNT(*)
1289: INTO l_manual_awt_exist
1290: FROM ap_invoice_lines_all ail
1291: WHERE ail.invoice_id = l_invoice_rec.invoice_id
1292: AND ail.line_type_lookup_code = 'AWT'
1293: AND ail.line_source = 'MANUAL LINE ENTRY';
1294:

Line 2626: FROM ap_invoice_lines_all

2622: RETURN BOOLEAN IS
2623:
2624: CURSOR get_gl_date IS
2625: SELECT distinct accounting_date acc_date
2626: FROM ap_invoice_lines_all
2627: WHERE invoice_id = p_invoice_id
2628: and NVL(generate_dists,'N') <> 'D';
2629:
2630: CURSOR get_inv_source IS

Line 2886: FROM ap_invoice_lines_all L

2882: --bugfix:4745464
2883: BEGIN
2884: SELECT 'Y'
2885: INTO l_undistributed_line_exists
2886: FROM ap_invoice_lines_all L
2887: WHERE L.invoice_id = p_invoice_id
2888: AND L.amount <>
2889: (SELECT NVL(SUM(NVL(aid.amount,0)),0)
2890: FROM ap_invoice_distributions_all aid

Line 3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;

3259:
3260: --Bugfix:4673607
3261: l_registration_api VARCHAR2(1000);
3262: l_registration_view VARCHAR2(1000);
3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

Line 3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;

3260: --Bugfix:4673607
3261: l_registration_api VARCHAR2(1000);
3262: l_registration_view VARCHAR2(1000);
3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
3268: l_err varchar2(2000);

Line 3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;

3261: l_registration_api VARCHAR2(1000);
3262: l_registration_view VARCHAR2(1000);
3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
3268: l_err varchar2(2000);
3269:

Line 3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;

3262: l_registration_view VARCHAR2(1000);
3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
3268: l_err varchar2(2000);
3269:
3270: BEGIN

Line 3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;

3263: l_reference_key1 ap_invoice_lines_all.reference_key1%type;
3264: l_reference_key2 ap_invoice_lines_all.reference_key2%type;
3265: l_reference_key3 ap_invoice_lines_all.reference_key3%type;
3266: l_reference_key4 ap_invoice_lines_all.reference_key4%type;
3267: l_reference_key5 ap_invoice_lines_all.reference_key5%type;
3268: l_err varchar2(2000);
3269:
3270: BEGIN
3271:

Line 4550: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D

4546: SELECT 'Distribution needs to be verified. '
4547: FROM DUAL
4548: WHERE EXISTS (
4549: SELECT 'Dist Total <> Invoice Line Amount'
4550: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
4551: -- WHERE AIL.invoice_id = D.invoice_id
4552: WHERE AIL.invoice_id = D.invoice_id(+)
4553: AND AIL.line_number = nvl(p_invoice_line_number, AIL.line_number) --bug6661773
4554: AND AIL.invoice_id = p_invoice_id

Line 4864: FROM ap_invoice_lines_all AIL, ap_invoices_all A

4860:
4861:
4862: CURSOR Line_Var_Cur IS
4863: SELECT 'Line Total <> Invoice Amount'
4864: FROM ap_invoice_lines_all AIL, ap_invoices_all A
4865: WHERE AIL.invoice_id = A.invoice_id
4866: AND AIL.invoice_id = p_invoice_id
4867: AND ((AIL.line_type_lookup_code <> 'TAX'
4868: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 5515: FROM ap_invoice_lines_all ail1

5511:
5512: CURSOR Prepay_Var_Cur IS
5513: SELECT AI.invoice_amount +
5514: (SELECT NVL(SUM(nvl(ail1.amount,0)), 0) --Bug 13050996
5515: FROM ap_invoice_lines_all ail1
5516: WHERE ail1.invoice_id=ai.invoice_id
5517: AND ail1.line_type_lookup_code ='AWT')
5518: ,nvl(AI.amount_paid,0)
5519: , (0 - sum(nvl(AIL.amount,0))) -- taking the remaining amount to be paid on as part of bug 8339454

Line 5520: FROM ap_invoices_all AI, ap_invoice_lines_all AIL

5516: WHERE ail1.invoice_id=ai.invoice_id
5517: AND ail1.line_type_lookup_code ='AWT')
5518: ,nvl(AI.amount_paid,0)
5519: , (0 - sum(nvl(AIL.amount,0))) -- taking the remaining amount to be paid on as part of bug 8339454
5520: FROM ap_invoices_all AI, ap_invoice_lines_all AIL
5521: WHERE AI.invoice_id = p_invoice_id
5522: AND AIL.invoice_id = AI.invoice_id
5523: AND AIL.invoice_includes_prepay_flag = 'N' --Bug 13050996: Uncommented out this line
5524: AND AIL.line_type_lookup_code IN ('PREPAY', 'TAX')

Line 5799: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

5795: -- in the invoice
5796: CURSOR c_non_awt_dists_segs is
5797: SELECT ap_utilities_pkg.get_auto_offsets_segments(
5798: aid.dist_code_combination_id)
5799: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
5800: WHERE ail.invoice_id = p_invoice_id
5801: AND ail.invoice_id = aid.invoice_id
5802: AND ail.line_number = aid.invoice_line_number
5803: AND ((aid.line_type_lookup_code not in ('AWT','PREPAY')

Line 7942: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

7938: --bugfix:5638734
7939: -- Get the exculusive tax amount for the prepay appln line.
7940: SELECT sum(aid.amount)
7941: INTO l_prepay_excl_tax_amt
7942: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
7943: WHERE ail.line_type_lookup_code='TAX'
7944: AND ail.invoice_id=p_invoice_id
7945: AND aid.invoice_id=ail.invoice_id
7946: AND aid.invoice_line_number=ail.line_number

Line 9496: from ap_invoice_lines_all ail

9492: AND ai.validation_request_id IS NULL
9493: /*bug 7029877 Invoice saved but not submitted*/
9494: AND ai.approval_ready_flag <>'S'
9495: AND EXISTS (select ail.invoice_id
9496: from ap_invoice_lines_all ail
9497: where ail.invoice_id = ai.invoice_id) ;
9498:
9499: -- bug 6351170 -Added below if condition - Return if there are no invoices to process
9500: IF sql%rowcount = 0 THEN

Line 9659: FROM ap_invoice_lines_all ail

9655: -- Bug 11830074 start
9656: l_manual_awt_exist:=0;
9657: SELECT COUNT(*)
9658: INTO l_manual_awt_exist
9659: FROM ap_invoice_lines_all ail
9660: WHERE ail.invoice_id = l_invoice_rec.invoice_id
9661: AND ail.line_type_lookup_code = 'AWT'
9662: AND ail.line_source = 'MANUAL LINE ENTRY';
9663:

Line 9853: FROM AP_INVOICE_LINES_ALL L2

9849: AND USER_RELEASEABLE_FLAG = ''N''))) /* Bug 14579876 */
9850: AND H.RELEASE_LOOKUP_CODE IS NULL
9851: AND EXISTS
9852: ( SELECT ''Lines''
9853: FROM AP_INVOICE_LINES_ALL L2
9854: WHERE L2.INVOICE_ID = H.INVOICE_ID ) --8580790,9112369
9855: UNION ALL
9856: SELECT 1
9857: FROM AP_INVOICE_LINES_ALL AIL

Line 9857: FROM AP_INVOICE_LINES_ALL AIL

9853: FROM AP_INVOICE_LINES_ALL L2
9854: WHERE L2.INVOICE_ID = H.INVOICE_ID ) --8580790,9112369
9855: UNION ALL
9856: SELECT 1
9857: FROM AP_INVOICE_LINES_ALL AIL
9858: WHERE AIL.INVOICE_ID = AI.INVOICE_ID
9859: /* Bug 9777752 AND AI.CANCELLED_DATE IS NULL */
9860: AND NVL(AIL.DISCARDED_FLAG, ''N'') <> ''Y''
9861: AND NVL(AIL.CANCELLED_FLAG, ''N'') <> ''Y''

Line 10335: FROM ap_invoice_lines_all ail

10331: -- Bug 11830074 start
10332: l_manual_awt_exist:=0;
10333: SELECT COUNT(*)
10334: INTO l_manual_awt_exist
10335: FROM ap_invoice_lines_all ail
10336: WHERE ail.invoice_id = l_selected_invoices_cursor(i).invoice_id
10337: AND ail.line_type_lookup_code = 'AWT'
10338: AND ail.line_source = 'MANUAL LINE ENTRY';
10339:

Line 10763: FROM ap_invoice_lines_all ail

10759: -- Bug 11830074 start
10760: l_manual_awt_exist:=0;
10761: SELECT COUNT(*)
10762: INTO l_manual_awt_exist
10763: FROM ap_invoice_lines_all ail
10764: WHERE ail.invoice_id = l_selected_invoices_cursor(i).invoice_id
10765: AND ail.line_type_lookup_code = 'AWT'
10766: AND ail.line_source = 'MANUAL LINE ENTRY';
10767:

Line 11003: FROM ap_invoice_lines_all ail

10999: -- Bug 11830074 start
11000: l_manual_awt_exist:=0;
11001: SELECT COUNT(*)
11002: INTO l_manual_awt_exist
11003: FROM ap_invoice_lines_all ail
11004: WHERE ail.invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id
11005: AND ail.line_type_lookup_code = 'AWT'
11006: AND ail.line_source = 'MANUAL LINE ENTRY';
11007:

Line 11586: FROM ap_invoice_lines_all ail

11582: BEGIN
11583:
11584: SELECT 'Y'
11585: INTO l_not_exist_nond_line
11586: FROM ap_invoice_lines_all ail
11587: WHERE ail.invoice_id = p_invoice_rec.invoice_id
11588: AND nvl(ail.generate_dists, 'N') <> 'D'
11589: AND rownum < 2;
11590:

Line 11613: FROM ap_invoice_lines_all ail, ap_allocation_rules ALR

11609: WHERE aha.invoice_id = p_invoice_rec.invoice_id
11610: AND aha.hold_lookup_code = 'CANNOT EXECUTE ALLOCATION'
11611: AND aha.release_lookup_code IS NULL
11612: AND NOT EXISTS ( SELECT 1
11613: FROM ap_invoice_lines_all ail, ap_allocation_rules ALR
11614: WHERE ail.invoice_id = p_invoice_rec.invoice_id
11615: AND ail.line_type_lookup_code in ('FREIGHT','MISCELLANEOUS')
11616: AND nvl(ail.discarded_flag,'N') ='N'
11617: AND ALR.invoice_id = AIL.invoice_id

Line 11693: FROM ap_invoice_lines_all

11689: ----------------------------------------------------------------
11690:
11691: SELECT nvl(prorate_across_all_items,'N')
11692: INTO l_prorate_across_all_items
11693: FROM ap_invoice_lines_all
11694: WHERE invoice_id = t_inv_lines_table(i).invoice_id
11695: AND line_number = t_inv_lines_table(i).line_number;
11696:
11697: --Bug10052153: Added below code to check if PRORATION rule is defined.

Line 12256: FROM ap_invoice_lines_all ail

12252: BEGIN
12253:
12254: SELECT 'Y'
12255: INTO l_not_exist_nond_line
12256: FROM ap_invoice_lines_all ail
12257: WHERE ail.invoice_id = p_invoice_rec.invoice_id
12258: AND nvl(ail.generate_dists, 'N') <> 'D'
12259: AND rownum < 2;
12260: