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

Line 193: ap_invoice_lines ail

189: IS
190: SELECT DECODE(COUNT(*),
191: 0, 'INVALID PREPAY LINE NUM', NULL)
192: FROM ap_invoices ai,
193: ap_invoice_lines ail
194: WHERE ai.invoice_num = cv_prepay_num
195: AND ail.line_number = cv_prepay_line_num
196: AND ail.invoice_id = ai.invoice_id
197: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 240: FROM ap_invoice_lines_all ail,

236: (cv_prepay_invoice_id NUMBER,
237: cv_prepay_line_num NUMBER)
238: IS
239: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
240: FROM ap_invoice_lines_all ail,
241: ap_invoice_distributions_all aid
242: WHERE ail.invoice_id = cv_prepay_invoice_id
243: AND ail.line_number = cv_prepay_line_num
244: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'

Line 289: FROM ap_invoice_lines_all ail,

285: CURSOR C_Check_No_Apply_Inv_Amount
286: (cv_prepay_invoice_id NUMBER)
287: IS
288: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
289: FROM ap_invoice_lines_all ail,
290: ap_invoice_distributions_all aid
291: WHERE ail.invoice_id = cv_prepay_invoice_id
292: AND ail.line_type_lookup_code <> 'TAX'
293: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'

Line 338: ap_invoice_lines ail,

334: (cv_vendor_id NUMBER)
335: IS
336: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
337: FROM ap_invoices ai,
338: ap_invoice_lines ail,
339: ap_invoice_distributions aid
340: WHERE ai.vendor_id = cv_vendor_id
341: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
342: AND ai.payment_status_flag = 'Y'

Line 793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

789: -- there is no need to verify the payment_status flag.
790:
791: SELECT SUM(NVL(aid.amount,0))
792: INTO l_invoice_amount_remaining
793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
794: WHERE ail.invoice_id = p_invoice_id
795: AND ail.invoice_id = aid.invoice_id
796: AND ail.line_number = aid.invoice_line_number
797: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 819: FROM ap_invoice_lines_all ail,

815:
816: -- Get the Prepay Amount Remaining
817: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
818: INTO l_prepay_amount_remaining
819: FROM ap_invoice_lines_all ail,
820: ap_invoice_distributions_all aid
821: WHERE ail.invoice_id = p_prepay_invoice_id
822: AND ail.line_number = p_prepay_line_num
823: AND ail.line_type_lookup_code = 'ITEM'

Line 857: FROM ap_invoice_lines_all ail,

853:
854: -- Get the Prepay Amount Remaining
855: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
856: INTO l_prepay_amount_remaining
857: FROM ap_invoice_lines_all ail,
858: ap_invoice_distributions_all aid
859: WHERE ail.invoice_id = p_prepay_invoice_id
860: AND ail.line_type_lookup_code = 'ITEM'
861: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 895: ap_invoice_lines ail,

891: -- Get the Prepay Amount Remaining
892: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
893: INTO l_prepay_amount_remaining
894: FROM ap_invoices ai,
895: ap_invoice_lines ail,
896: ap_invoice_distributions aid
897: WHERE ai.vendor_id = p_vendor_id
898: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
899: AND nvl(ai.earliest_settlement_date,sysdate+1) <= SYSDATE

Line 967: ap_invoice_lines_all ail

963: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
964: (ail.invoice_id,
965: ail.line_number)
966: FROM ap_invoices_all ai,
967: ap_invoice_lines_all ail
968: WHERE ai.invoice_id = cv_prepay_invoice_id
969: AND ail.invoice_id = ai.invoice_id
970: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
971: (ail.invoice_id,

Line 988: ap_invoice_lines ail

984: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
985: (ail.invoice_id,
986: ail.line_number)
987: FROM ap_invoices ai,
988: ap_invoice_lines ail
989: WHERE ai.vendor_id = cv_vendor_id
990: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
991: AND ai.payment_status_flag = 'Y'
992: AND NVL(ai.earliest_settlement_date,SYSDATE+1) <= SYSDATE

Line 1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;

1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

Line 1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

Line 1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

Line 1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:

Line 1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables

Line 1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

Line 1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1456: l_result BOOLEAN;
1457: l_calling_program VARCHAR2(1000);
1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

Line 1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1457: l_calling_program VARCHAR2(1000);
1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

Line 1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:

Line 1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables

Line 1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

Line 1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1471: l_max_dist_number

Line 1484: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;

1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);
1483:
1484: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;
1485: l_apply_amount_no_tax_incl NUMBER;
1486: l_ppay_ln_amt_remaining_no_tax NUMBER;
1487: l_prepay_tax_diff_amt NUMBER;
1488:

Line 1489: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1485: l_apply_amount_no_tax_incl NUMBER;
1486: l_ppay_ln_amt_remaining_no_tax NUMBER;
1487: l_prepay_tax_diff_amt NUMBER;
1488:
1489: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1490:
1491: l_api_name VARCHAR2(50);
1492:
1493: tax_exception EXCEPTION;

Line 1549: FROM AP_invoice_lines ail,

1545: ail.po_distribution_id,
1546: ail.rcv_transaction_id,
1547: ail.unit_meas_lookup_code,
1548: plt.matching_basis
1549: FROM AP_invoice_lines ail,
1550: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1551: po_line_locations pll,
1552: po_line_types_b plt --bug 5056269
1553: -- po_line_types_tl T --bug 5119694

Line 1825: FROM ap_invoice_lines

1821: NVL( ABS(SUM(pa_quantity)), 0 )
1822: INTO l_prepay_ln_s_quant_invoiced,
1823: l_prepay_ln_s_stat_amount,
1824: l_prepay_ln_s_pa_quantity
1825: FROM ap_invoice_lines
1826: WHERE prepay_invoice_id = p_prepay_invoice_id
1827: AND prepay_line_number = p_prepay_line_num;
1828:
1829: IF (l_ppay_ln_po_line_location_id IS NOT NULL OR

Line 1905: FROM ap_invoice_lines

1901: IF (P_calling_mode = 'PREPAYMENT APPLICATION') THEN
1902:
1903: SELECT NVL(MAX (line_number),0) + 1
1904: INTO l_prepay_ln_number
1905: FROM ap_invoice_lines
1906: WHERE invoice_id = p_invoice_id;
1907:
1908:
1909: -- ===========================================================

Line 1985: FROM ap_invoice_lines_all

1981:
1982: BEGIN
1983: SELECT NVL(included_tax_amount, 0)
1984: INTO l_inclusive_tax_amount
1985: FROM ap_invoice_lines_all
1986: WHERE invoice_id = p_invoice_id
1987: AND line_number = l_prepay_ln_number;
1988:
1989: EXCEPTION

Line 2531: UPDATE ap_invoice_lines_all ail

2527: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2528: END IF;
2529:
2530: BEGIN
2531: UPDATE ap_invoice_lines_all ail
2532: SET amount = l_apply_amount,
2533: base_amount = l_prepay_ln_base_amount
2534: WHERE ail.invoice_id = p_invoice_id
2535: AND ail.line_number = l_prepay_ln_number;

Line 2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2625: -- ==========================================================
2626: --Bug5224883
2627: -- Get the exculusive tax amount for the prepay appln line.
2628: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2630: WHERE ail.line_type_lookup_code='TAX'
2631: AND ail.invoice_id=p_invoice_id
2632: and aid.invoice_id=ail.invoice_id
2633: AND aid.invoice_line_number=ail.line_number

Line 2855: INSERT INTO AP_Invoice_Lines(

2851: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2852: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2853: END IF;
2854:
2855: INSERT INTO AP_Invoice_Lines(
2856: INVOICE_ID,
2857: LINE_NUMBER,
2858: LINE_TYPE_LOOKUP_CODE,
2859: REQUESTER_ID,

Line 3165: FROM ap_invoice_lines

3161: product_category,
3162: user_defined_fisc_class,
3163: purchasing_category_id,
3164: org_id
3165: FROM ap_invoice_lines
3166: WHERE invoice_id = p_prepay_invoice_id
3167: AND line_number = p_prepay_line_num;
3168:
3169: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3255: FROM ap_invoice_lines

3251:
3252: --Bug5224996 Added following select stmt
3253: SELECT invoice_includes_prepay_flag
3254: INTO l_invoice_includes_prepay_flag
3255: FROM ap_invoice_lines
3256: WHERE invoice_id=p_invoice_id
3257: AND line_number=p_line_number;
3258:
3259: FOR l_loop_counter IN nvl(p_prepay_dist_info.first,0) .. nvl(p_prepay_dist_info.last,0) LOOP

Line 4030: ap_invoice_lines ail,

4026: aid.amount,
4027: aid.quantity_invoiced,
4028: plt.matching_basis
4029: FROM ap_invoice_distributions aid,
4030: ap_invoice_lines ail,
4031: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4032: po_line_locations pll,
4033: po_line_types_b plt, --bug 5056269
4034: po_line_types_tl T

Line 4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;

4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4549: l_debug_info VARCHAR2(100);
4550: l_current_calling_sequence VARCHAR2(2000);
4551: l_calling_program VARCHAR2(1000);

Line 4572: FROM AP_INVOICE_LINES

4568: CURSOR C_PPAY_LINE_REC (CV_INVOICE_ID IN NUMBER,
4569: CV_LINE_NUM IN NUMBER)
4570: IS
4571: SELECT *
4572: FROM AP_INVOICE_LINES
4573: WHERE invoice_id = CV_Invoice_ID
4574: AND line_number = CV_line_num;
4575:
4576: BEGIN

Line 4651: l_dummy := AP_INVOICE_LINES_PKG.Discard_Inv_Line (

4647: -- The code should not do anything related to updating PO.
4648: -- We will address this during the Coding Stage.
4649:
4650: -- ==========================================================
4651: l_dummy := AP_INVOICE_LINES_PKG.Discard_Inv_Line (
4652: P_line_rec => l_prepay_line_rec,
4653: P_calling_mode => 'UNAPPLY_PREPAY',
4654: P_inv_cancellable => 'Y',
4655: P_last_updated_by => p_user_id,

Line 4875: ap_invoice_lines ail

4871: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
4872: (ail.invoice_id,
4873: ail.line_number)
4874: FROM ap_invoices ai,
4875: ap_invoice_lines ail
4876: WHERE ai.invoice_id = cv_prepay_invoice_id
4877: AND ail.invoice_id = ai.invoice_id
4878: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
4879: (ail.invoice_id,