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 114: ap_invoice_lines_all ail

110: -- distributions created for prepayment applications
111: SELECT SUM(NVL(aid.amount,0))
112: INTO distribution_total
113: FROM ap_invoice_distributions_all aid,
114: ap_invoice_lines_all ail
115: WHERE ail.invoice_id = l_invoice_id
116: AND aid.invoice_id = ail.invoice_id
117: AND aid.invoice_line_number = ail.line_number
118: AND ((aid.line_type_lookup_code NOT IN ('PREPAY', 'AWT')

Line 722: FROM ap_invoice_lines_all ail

718: BEGIN
719:
720: SELECT 'N'
721: INTO invoice_approval_flag
722: FROM ap_invoice_lines_all ail
723: WHERE ail.invoice_id = l_invoice_id
724: AND ail.amount <>
725: ( SELECT NVL(SUM(NVL(aid.amount,0)),0)
726: FROM ap_invoice_distributions_all aid

Line 762: FROM ap_invoice_lines_all AIL, ap_invoices_all A

758: BEGIN
759:
760: SELECT 'N'
761: INTO invoice_approval_flag
762: FROM ap_invoice_lines_all AIL, ap_invoices_all A
763: WHERE AIL.invoice_id = A.invoice_id
764: AND AIL.invoice_id = l_invoice_id
765: AND ((AIL.line_type_lookup_code <> 'TAX'
766: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

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

796: -- eTax Uptake. Use of prepay_distribution_id to determine
797: -- if the REC_TAX and NONREC_TAX distribution are related
798: -- to the prepayment application and should be included in the
799: -- total of the distributions if the invoice_includes_prepay_flag is
800: -- Y. Included ap_invoice_lines_all in select since the flag
801: -- at the dist level is obsolete.
802:
803: IF (encumbrance_flag = 'Y') AND (invoice_approval_flag = 'A') THEN
804:

Line 808: ap_invoice_lines_all ail

804:
805: SELECT NVL(SUM(nvl(aid.amount,0)), 0)
806: INTO sum_distributions
807: FROM ap_invoice_distributions_all aid,
808: ap_invoice_lines_all ail
809: WHERE ail.invoice_id = l_invoice_id
810: AND aid.invoice_id = ail.invoice_id
811: AND aid.invoice_line_number = ail.line_number
812: AND (aid.line_type_lookup_code <> 'RETAINAGE'

Line 931: FROM ap_invoice_lines_all L,

927: /* Bug 4669905. Modified the Cursor */
928: CURSOR po_number_cursor IS
929: SELECT DISTINCT ph.segment1, ph.po_header_id,
930: NVL(SUM(L.amount),0)
931: FROM ap_invoice_lines_all L,
932: po_headers PH
933: WHERE L.invoice_id = l_invoice_id
934: AND L.po_header_id = PH.po_header_id
935: AND L.match_type IN ( 'PRICE_CORRECTION', 'QTY_CORRECTION',

Line 959: FROM ap_invoice_lines_all AIL

955: EXIT;
956: ELSE /* Bug 4669905 */
957: SELECT NVL(SUM(AIL.amount), 0)
958: INTO l_corrected_amount
959: FROM ap_invoice_lines_all AIL
960: WHERE corrected_inv_id = l_invoice_id
961: AND po_header_id = l_po_header_id
962: AND NVL( AIL.discarded_flag, 'N' ) <> 'Y'
963: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y' ;

Line 1001: FROM ap_invoice_lines L,

997: l_shipment_type po_line_locations.shipment_type%TYPE;
998:
999: CURSOR po_shipment_type_cursor IS
1000: SELECT DISTINCT(pll.shipment_type)
1001: FROM ap_invoice_lines L,
1002: po_line_locations PLL
1003: WHERE L.invoice_id = l_invoice_id
1004: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1005: FROM ap_invoice_lines AIL

Line 1005: FROM ap_invoice_lines AIL

1001: FROM ap_invoice_lines L,
1002: po_line_locations PLL
1003: WHERE L.invoice_id = l_invoice_id
1004: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1005: FROM ap_invoice_lines AIL
1006: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1007: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1008: AND AIL.corrected_inv_id = L.invoice_id)
1009: AND L.po_line_location_id = PLL.line_location_id

Line 1025: FROM ap_invoice_lines L,

1021:
1022:
1023: CURSOR po_release_number_cursor IS
1024: SELECT DISTINCT(PRL.release_num)
1025: FROM ap_invoice_lines L,
1026: po_line_locations PLL,
1027: po_releases PRL
1028: WHERE L.invoice_id = l_invoice_id
1029: AND NOT EXISTS (SELECT AIL.corrected_inv_id

Line 1030: FROM ap_invoice_lines AIL

1026: po_line_locations PLL,
1027: po_releases PRL
1028: WHERE L.invoice_id = l_invoice_id
1029: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1030: FROM ap_invoice_lines AIL
1031: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1032: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1033: AND AIL.corrected_inv_id = L.invoice_id)
1034: AND L.po_line_location_id = PLL.line_location_id

Line 1104: FROM ap_invoice_lines L,

1100: receipt_number VARCHAR2(25) := 'UNMATCHED';
1101:
1102: CURSOR receipt_number_cursor IS
1103: SELECT DISTINCT(rsh.receipt_num)
1104: FROM ap_invoice_lines L,
1105: rcv_transactions RTXN,
1106: rcv_shipment_headers RSH
1107: WHERE L.invoice_id = l_invoice_id
1108: AND NOT EXISTS (SELECT AIL.corrected_inv_id

Line 1109: FROM ap_invoice_lines AIL

1105: rcv_transactions RTXN,
1106: rcv_shipment_headers RSH
1107: WHERE L.invoice_id = l_invoice_id
1108: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1109: FROM ap_invoice_lines AIL
1110: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1111: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1112: AND AIL.corrected_inv_id = L.invoice_id)
1113: AND L.rcv_transaction_id = RTXN.transaction_id

Line 1171: FROM ap_invoice_lines L,

1167: po_number_list VARCHAR2(2000) := NULL;
1168:
1169: CURSOR po_number_cursor IS
1170: SELECT DISTINCT(ph.segment1)
1171: FROM ap_invoice_lines L,
1172: po_headers PH
1173: WHERE L.invoice_id = l_invoice_id
1174: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1175: FROM ap_invoice_lines AIL

Line 1175: FROM ap_invoice_lines AIL

1171: FROM ap_invoice_lines L,
1172: po_headers PH
1173: WHERE L.invoice_id = l_invoice_id
1174: AND NOT EXISTS (SELECT AIL.corrected_inv_id
1175: FROM ap_invoice_lines AIL
1176: WHERE NVL( AIL.discarded_flag, 'N' ) <> 'Y'
1177: AND NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1178: AND AIL.corrected_inv_id = L.invoice_id)
1179: AND L.po_header_id = PH.po_header_id

Line 2628: FROM ap_invoice_lines

2624: BEGIN
2625:
2626: SELECT nvl( MAX(line_number),0 )
2627: INTO l_max_inv_line_num
2628: FROM ap_invoice_lines
2629: WHERE invoice_id = P_invoice_id;
2630:
2631: RETURN (l_max_inv_line_num);
2632:

Line 2663: FROM ap_invoice_lines ail

2659: -- is not included in the invoice. (invoice_includes_prepay_flag = N)
2660:
2661: SELECT SUM(NVL(amount,0))
2662: INTO line_total
2663: FROM ap_invoice_lines ail
2664: WHERE ail.invoice_id = p_invoice_id
2665: AND ((ail.line_type_lookup_code not in ('PREPAY','AWT') --Bug 7372061 Excluded 'AWT' amount from the total line amount.
2666: AND ail.prepay_invoice_id IS NULL
2667: AND ail.prepay_line_number IS NULL)

Line 2770: FROM ap_invoice_lines AIL

2766: IF (l_invoice_currency_code <> l_base_currency_code) THEN
2767: BEGIN
2768: SELECT SUM(base_amount), SUM(amount)
2769: INTO l_sum_base_amt, l_sum_amt
2770: FROM ap_invoice_lines AIL
2771: WHERE AIL.invoice_id = X_INVOICE_ID
2772: AND line_type_lookup_code <> 'AWT'
2773: AND (invoice_includes_prepay_flag = 'Y' OR
2774: line_type_lookup_code <> 'PREPAY');

Line 2813: FROM ap_invoice_lines ail1

2809: BEGIN
2810:
2811: SELECT ail1.line_number
2812: BULK COLLECT INTO l_Rounded_Line_Numbers
2813: FROM ap_invoice_lines ail1
2814: WHERE ail1.invoice_id = X_invoice_id
2815: AND ail1.amount <> 0
2816: AND (EXISTS
2817: (SELECT 'UNPOSTED'

Line 2890: FROM ap_invoice_lines AIL

2886: -- Perf bug 5173995 , removed count(*) from below 2 SQLs
2887: BEGIN
2888: SELECT 1
2889: INTO l_active_count
2890: FROM ap_invoice_lines AIL
2891: WHERE ( NVL( AIL.discarded_flag, 'N' ) <> 'Y' AND
2892: NVL( AIL.cancelled_flag, 'N' ) <> 'Y' )
2893: AND AIL.corrected_inv_id = p_invoice_id
2894: AND ROWNUM = 1 ;

Line 2958: FROM ap_invoice_lines_all il

2954: FROM ap_invoices_all i
2955: WHERE i.invoice_id = P_Invoice_Id
2956: AND EXISTS
2957: (SELECT il.invoice_id
2958: FROM ap_invoice_lines_all il
2959: WHERE il.invoice_id = i.invoice_id
2960: AND NVL(il.discarded_flag, 'N') <> 'Y'
2961: AND NVL(il.cancelled_flag, 'N') <> 'Y'
2962: AND il.match_type IN ('PRICE_CORRECTION',

Line 3046: FROM ap_invoice_lines_all il

3042: FROM ap_invoices_all i
3043: WHERE i.invoice_id = P_Invoice_Id
3044: AND EXISTS
3045: (SELECT il.invoice_id
3046: FROM ap_invoice_lines_all il
3047: WHERE il.invoice_id = i.invoice_id
3048: AND il.line_type_lookup_code = 'PREPAY'
3049: AND NVL(il.discarded_flag, 'N') <> 'Y'
3050: AND NVL(il.cancelled_flag, 'N') <> 'Y');

Line 3133: FROM ap_invoice_lines_all il

3129: FROM ap_invoices_all i
3130: WHERE i.invoice_id = P_Invoice_Id
3131: AND EXISTS
3132: (SELECT il.invoice_id
3133: FROM ap_invoice_lines_all il
3134: WHERE il.invoice_id = i.invoice_id
3135: AND il.line_type_lookup_code = 'AWT'
3136: AND NVL(il.discarded_flag, 'N') <> 'Y'
3137: AND NVL(il.cancelled_flag, 'N') <> 'Y');

Line 3219: FROM ap_invoice_lines_all ail,

3215: FROM ap_invoices_all i
3216: WHERE i.invoice_id = P_Invoice_Id
3217: AND EXISTS
3218: (SELECT ail.invoice_id
3219: FROM ap_invoice_lines_all ail,
3220: po_line_locations_all pll
3221: WHERE ail.invoice_id = i.invoice_id
3222: AND ail.po_line_location_id = pll.line_location_id
3223: AND ail.org_id = pll.org_id

Line 3349: (SELECT 'X' FROM ap_invoice_lines_all ail

3345: FROM ap_invoice_distributions_all aid
3346: WHERE aid.invoice_id = p_invoice_id
3347: AND aid.line_type_lookup_code = 'RETAINAGE'
3348: AND EXISTS
3349: (SELECT 'X' FROM ap_invoice_lines_all ail
3350: WHERE ail.invoice_id = p_invoice_id
3351: AND ail.line_number = aid.invoice_line_number
3352: AND ail.line_type_lookup_code <> 'RETAINAGE RELEASE');
3353:

Line 3382: from ap_invoice_lines_all

3378: BEGIN
3379:
3380: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3381: into item_total
3382: from ap_invoice_lines_all
3383: where invoice_id = p_invoice_id
3384: and line_type_lookup_code IN ('ITEM','RETAINAGE RELEASE');
3385:
3386: return(item_total);

Line 3414: from ap_invoice_lines_all

3410: BEGIN
3411:
3412: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3413: into freight_total
3414: from ap_invoice_lines_all
3415: where invoice_id = p_invoice_id
3416: and org_id = p_org_id
3417: and line_type_lookup_code = 'FREIGHT';
3418:

Line 3448: from ap_invoice_lines_all

3444: BEGIN
3445:
3446: select sum(nvl(amount,0)) - sum(nvl(included_tax_amount,0))
3447: into misc_total
3448: from ap_invoice_lines_all
3449: where invoice_id = p_invoice_id
3450: and org_id = p_org_id
3451: and line_type_lookup_code = 'MISCELLANEOUS';
3452: