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_INVOICES_UTILITY_PKG dependencies on AP_INVOICE_LINES

Line 120: ap_invoice_lines_all ail

116: -- distributions created for prepayment applications
117: SELECT SUM(NVL(aid.amount,0))
118: INTO distribution_total
119: FROM ap_invoice_distributions_all aid,
120: ap_invoice_lines_all ail
121: WHERE ail.invoice_id = l_invoice_id
122: AND aid.invoice_id = ail.invoice_id
123: AND aid.invoice_line_number = ail.line_number
124: AND ((aid.line_type_lookup_code NOT IN ('PREPAY', 'AWT')

Line 771: FROM ap_invoice_lines_all ail

767: BEGIN
768:
769: SELECT 'N'
770: INTO invoice_approval_flag
771: FROM ap_invoice_lines_all ail
772: WHERE ail.invoice_id = l_invoice_id
773: AND ail.amount <>
774: ( SELECT NVL(SUM(NVL(aid.amount,0)),0)
775: FROM ap_invoice_distributions_all aid

Line 811: FROM ap_invoice_lines_all AIL, ap_invoices_all A

807: BEGIN
808:
809: SELECT 'N'
810: INTO invoice_approval_flag
811: FROM ap_invoice_lines_all AIL, ap_invoices_all A
812: WHERE AIL.invoice_id = A.invoice_id
813: AND AIL.invoice_id = l_invoice_id
814: AND ((AIL.line_type_lookup_code <> 'TAX'
815: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 849: -- Y. Included ap_invoice_lines_all in select since the flag

845: -- eTax Uptake. Use of prepay_distribution_id to determine
846: -- if the REC_TAX and NONREC_TAX distribution are related
847: -- to the prepayment application and should be included in the
848: -- total of the distributions if the invoice_includes_prepay_flag is
849: -- Y. Included ap_invoice_lines_all in select since the flag
850: -- at the dist level is obsolete.
851:
852: IF (encumbrance_flag = 'Y') AND (invoice_approval_flag = 'A') THEN
853:

Line 857: ap_invoice_lines_all ail

853:
854: SELECT NVL(SUM(nvl(aid.amount,0)), 0)
855: INTO sum_distributions
856: FROM ap_invoice_distributions_all aid,
857: ap_invoice_lines_all ail
858: WHERE ail.invoice_id = l_invoice_id
859: AND aid.invoice_id = ail.invoice_id
860: AND aid.invoice_line_number = ail.line_number
861: AND (aid.line_type_lookup_code <> 'RETAINAGE'

Line 989: FROM ap_invoice_lines_all L,

985: /* Bug 4669905. Modified the Cursor */
986: CURSOR po_number_cursor IS
987: SELECT DISTINCT NVL(ph.CLM_DOCUMENT_NUMBER , ph.segment1), ph.po_header_id, -- for CLM Bug 9503239
988: NVL(SUM(L.amount),0)
989: FROM ap_invoice_lines_all L,
990: po_headers PH
991: WHERE L.invoice_id = l_invoice_id
992: AND L.po_header_id = PH.po_header_id
993: AND L.match_type IN ( 'PRICE_CORRECTION', 'QTY_CORRECTION',

Line 1025: FROM ap_invoice_lines_all AIL

1021: EXIT;
1022: ELSE /* Bug 4669905 */
1023: SELECT NVL(SUM(AIL.amount), 0)
1024: INTO l_corrected_amount
1025: FROM ap_invoice_lines_all AIL
1026: WHERE corrected_inv_id = l_invoice_id
1027: AND po_header_id = l_po_header_id
1028: AND NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1029: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y' ;

Line 1073: FROM ap_invoice_lines L,

1069: l_shipment_type po_line_locations.shipment_type%TYPE;
1070:
1071: CURSOR po_shipment_type_cursor IS
1072: SELECT DISTINCT(pll.shipment_type)
1073: FROM ap_invoice_lines L,
1074: po_line_locations PLL
1075: WHERE L.invoice_id = l_invoice_id
1076: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1077: FROM ap_invoice_lines AIL

Line 1077: FROM ap_invoice_lines AIL

1073: FROM ap_invoice_lines L,
1074: po_line_locations PLL
1075: WHERE L.invoice_id = l_invoice_id
1076: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1077: FROM ap_invoice_lines AIL
1078: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1079: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1080: AND AIL.corrected_inv_id = L.invoice_id)
1081: AND L.po_line_location_id = PLL.line_location_id

Line 1097: FROM ap_invoice_lines L,

1093:
1094:
1095: CURSOR po_release_number_cursor IS
1096: SELECT DISTINCT(PRL.release_num)
1097: FROM ap_invoice_lines L,
1098: po_line_locations PLL,
1099: po_releases PRL
1100: WHERE L.invoice_id = l_invoice_id
1101: AND NOT EXISTS (SELECT AIL.corrected_inv_id

Line 1102: FROM ap_invoice_lines AIL

1098: po_line_locations PLL,
1099: po_releases PRL
1100: WHERE L.invoice_id = l_invoice_id
1101: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1102: FROM ap_invoice_lines AIL
1103: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1104: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1105: AND AIL.corrected_inv_id = L.invoice_id)
1106: AND L.po_line_location_id = PLL.line_location_id

Line 1176: FROM ap_invoice_lines L,

1172: receipt_number RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE:= 'UNMATCHED'; --Bug 16413390
1173:
1174: CURSOR receipt_number_cursor IS
1175: SELECT DISTINCT(rsh.receipt_num)
1176: FROM ap_invoice_lines L,
1177: rcv_transactions RTXN,
1178: rcv_shipment_headers RSH
1179: WHERE L.invoice_id = l_invoice_id
1180: AND NOT EXISTS (SELECT AIL.corrected_inv_id

Line 1181: FROM ap_invoice_lines AIL

1177: rcv_transactions RTXN,
1178: rcv_shipment_headers RSH
1179: WHERE L.invoice_id = l_invoice_id
1180: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1181: FROM ap_invoice_lines AIL
1182: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1183: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1184: AND AIL.corrected_inv_id = L.invoice_id)
1185: AND L.rcv_transaction_id = RTXN.transaction_id

Line 1243: FROM ap_invoice_lines L,

1239: po_number_list VARCHAR2(5000) := NULL; -- for CLM Bug 9503239
1240:
1241: CURSOR po_number_cursor IS
1242: SELECT DISTINCT(NVL(ph.CLM_DOCUMENT_NUMBER , ph.segment1)) -- for CLM Bug 9503239
1243: FROM ap_invoice_lines L,
1244: po_headers PH
1245: WHERE L.invoice_id = l_invoice_id
1246: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1247: FROM ap_invoice_lines AIL

Line 1247: FROM ap_invoice_lines AIL

1243: FROM ap_invoice_lines L,
1244: po_headers PH
1245: WHERE L.invoice_id = l_invoice_id
1246: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1247: FROM ap_invoice_lines AIL
1248: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1249: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1250: AND AIL.corrected_inv_id = L.invoice_id)
1251: AND L.po_header_id = PH.po_header_id

Line 2700: FROM ap_invoice_lines

2696: BEGIN
2697:
2698: SELECT nvl( MAX(line_number),0 )
2699: INTO l_max_inv_line_num
2700: FROM ap_invoice_lines
2701: WHERE invoice_id = P_invoice_id;
2702:
2703: RETURN (l_max_inv_line_num);
2704:

Line 2735: FROM ap_invoice_lines ail

2731: -- is not included in the invoice. (invoice_includes_prepay_flag = N)
2732:
2733: SELECT SUM(NVL(amount,0))
2734: INTO line_total
2735: FROM ap_invoice_lines ail
2736: WHERE ail.invoice_id = p_invoice_id
2737: AND ((ail.line_type_lookup_code not in ('PREPAY','AWT') --Bug 7372061 Excluded 'AWT' amount from the total line amount.
2738: AND ail.prepay_invoice_id IS NULL
2739: AND ail.prepay_line_number IS NULL)

Line 2842: FROM ap_invoice_lines AIL

2838: IF (l_invoice_currency_code <> l_base_currency_code) THEN
2839: BEGIN
2840: SELECT SUM(base_amount), SUM(amount)
2841: INTO l_sum_base_amt, l_sum_amt
2842: FROM ap_invoice_lines AIL
2843: WHERE AIL.invoice_id = X_INVOICE_ID
2844: AND line_type_lookup_code <> 'AWT'
2845: AND (invoice_includes_prepay_flag = 'Y' OR
2846: line_type_lookup_code <> 'PREPAY');

Line 2885: FROM ap_invoice_lines ail1

2881: BEGIN
2882:
2883: SELECT ail1.line_number
2884: BULK COLLECT INTO l_Rounded_Line_Numbers
2885: FROM ap_invoice_lines ail1
2886: WHERE ail1.invoice_id = X_invoice_id
2887: AND ail1.amount <> 0
2888: AND LINE_TYPE_LOOKUP_CODE not in ('TAX', 'AWT') -- bug 9582952 --bug16090813
2889: AND (EXISTS

Line 2963: FROM ap_invoice_lines AIL

2959: -- Perf bug 5173995 , removed count(*) from below 2 SQLs
2960: BEGIN
2961: SELECT 1
2962: INTO l_active_count
2963: FROM ap_invoice_lines AIL
2964: WHERE ( NVL( AIL.discarded_flag, 'N' ) <> 'Y' AND
2965: NVL( AIL.cancelled_flag, 'N' ) <> 'Y' )
2966: AND AIL.corrected_inv_id = p_invoice_id
2967: AND ROWNUM = 1 ;

Line 3031: FROM ap_invoice_lines_all il

3027: FROM ap_invoices_all i
3028: WHERE i.invoice_id = P_Invoice_Id
3029: AND EXISTS
3030: (SELECT il.invoice_id
3031: FROM ap_invoice_lines_all il
3032: WHERE il.invoice_id = i.invoice_id
3033: AND NVL(il.discarded_flag, 'N') <> 'Y'
3034: AND NVL(il.cancelled_flag, 'N') <> 'Y'
3035: AND il.match_type IN ('PRICE_CORRECTION',

Line 3119: FROM ap_invoice_lines_all il

3115: FROM ap_invoices_all i
3116: WHERE i.invoice_id = P_Invoice_Id
3117: AND EXISTS
3118: (SELECT il.invoice_id
3119: FROM ap_invoice_lines_all il
3120: WHERE il.invoice_id = i.invoice_id
3121: AND il.line_type_lookup_code = 'PREPAY'
3122: AND NVL(il.discarded_flag, 'N') <> 'Y'
3123: AND NVL(il.cancelled_flag, 'N') <> 'Y');

Line 3206: FROM ap_invoice_lines_all il

3202: FROM ap_invoices_all i
3203: WHERE i.invoice_id = P_Invoice_Id
3204: AND EXISTS
3205: (SELECT il.invoice_id
3206: FROM ap_invoice_lines_all il
3207: WHERE il.invoice_id = i.invoice_id
3208: AND il.line_type_lookup_code = 'AWT'
3209: AND NVL(il.discarded_flag, 'N') <> 'Y'
3210: AND NVL(il.cancelled_flag, 'N') <> 'Y');

Line 3292: FROM ap_invoice_lines_all ail,

3288: FROM ap_invoices_all i
3289: WHERE i.invoice_id = P_Invoice_Id
3290: AND EXISTS
3291: (SELECT ail.invoice_id
3292: FROM ap_invoice_lines_all ail,
3293: po_line_locations_all pll
3294: WHERE ail.invoice_id = i.invoice_id
3295: AND ail.po_line_location_id = pll.line_location_id
3296: AND ail.org_id = pll.org_id

Line 3422: (SELECT 'X' FROM ap_invoice_lines_all ail

3418: FROM ap_invoice_distributions_all aid
3419: WHERE aid.invoice_id = p_invoice_id
3420: AND aid.line_type_lookup_code = 'RETAINAGE'
3421: AND EXISTS
3422: (SELECT 'X' FROM ap_invoice_lines_all ail
3423: WHERE ail.invoice_id = p_invoice_id
3424: AND ail.line_number = aid.invoice_line_number
3425: AND ail.line_type_lookup_code <> 'RETAINAGE RELEASE');
3426:

Line 3455: from ap_invoice_lines_all

3451: BEGIN
3452:
3453: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3454: into item_total
3455: from ap_invoice_lines_all
3456: where invoice_id = p_invoice_id
3457: and line_type_lookup_code IN ('ITEM','RETAINAGE RELEASE');
3458:
3459: return(item_total);

Line 3487: from ap_invoice_lines_all

3483: BEGIN
3484:
3485: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3486: into freight_total
3487: from ap_invoice_lines_all
3488: where invoice_id = p_invoice_id
3489: and org_id = p_org_id
3490: and line_type_lookup_code = 'FREIGHT';
3491:

Line 3521: from ap_invoice_lines_all

3517: BEGIN
3518:
3519: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3520: into misc_total
3521: from ap_invoice_lines_all
3522: where invoice_id = p_invoice_id
3523: and org_id = p_org_id
3524: and line_type_lookup_code = 'MISCELLANEOUS';
3525:

Line 3932: FROM ap_invoice_lines_interface

3928: INTO L_INVOICE_TYPE_LOOKUP_CODE
3929: FROM AP_INVOICES_INTERFACE
3930: /* Modified for bug#15906783 */
3931: WHERE INVOICE_ID in (SELECT INVOICE_ID
3932: FROM ap_invoice_lines_interface
3933: WHERE invoice_line_id = P_ID);
3934:
3935:
3936: ELSIF(P_calling_mode = 'INV_VLD')THEN