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 794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

790:
791: /* Start of fix for bug8692604 */
792: /* SELECT SUM(NVL(aid.amount,0))
793: INTO l_invoice_amount_remaining
794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
795: WHERE ail.invoice_id = p_invoice_id
796: AND ail.invoice_id = aid.invoice_id
797: AND ail.line_number = aid.invoice_line_number
798: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 813: from ap_invoice_lines_all

809: ); */
810:
811: select sum(nvl(amount,0))
812: into l_invoice_amount_remaining
813: from ap_invoice_lines_all
814: where invoice_id = p_invoice_id
815: and line_type_lookup_code <> 'PREPAY';
816: /* End of fix for bug8692604 */
817:

Line 827: FROM ap_invoice_lines_all ail,

823:
824: -- Get the Prepay Amount Remaining
825: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
826: INTO l_prepay_amount_remaining
827: FROM ap_invoice_lines_all ail,
828: ap_invoice_distributions_all aid
829: WHERE ail.invoice_id = p_prepay_invoice_id
830: AND ail.line_number = p_prepay_line_num
831: AND ail.line_type_lookup_code = 'ITEM'

Line 865: FROM ap_invoice_lines_all ail,

861:
862: -- Get the Prepay Amount Remaining
863: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
864: INTO l_prepay_amount_remaining
865: FROM ap_invoice_lines_all ail,
866: ap_invoice_distributions_all aid
867: WHERE ail.invoice_id = p_prepay_invoice_id
868: AND ail.line_type_lookup_code = 'ITEM'
869: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 903: ap_invoice_lines ail,

899: -- Get the Prepay Amount Remaining
900: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
901: INTO l_prepay_amount_remaining
902: FROM ap_invoices ai,
903: ap_invoice_lines ail,
904: ap_invoice_distributions aid
905: WHERE ai.vendor_id = p_vendor_id
906: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
907: AND nvl(ai.earliest_settlement_date,sysdate+1) <= SYSDATE

Line 978: ap_invoice_lines_all ail

974: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
975: (ail.invoice_id,
976: ail.line_number)
977: FROM ap_invoices_all ai,
978: ap_invoice_lines_all ail
979: WHERE ai.invoice_id = cv_prepay_invoice_id
980: AND ail.invoice_id = ai.invoice_id
981: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
982: (ail.invoice_id,

Line 1002: ap_invoice_lines ail

998: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
999: (ail.invoice_id,
1000: ail.line_number)
1001: FROM ap_invoices ai,
1002: ap_invoice_lines ail
1003: WHERE ai.vendor_id = cv_vendor_id
1004: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1005: AND ai.payment_status_flag = 'Y'
1006: AND NVL(ai.earliest_settlement_date,SYSDATE+1) <= SYSDATE

Line 1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;

1451: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1452: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1453:
1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1452: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1453:
1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

Line 1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

Line 1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

Line 1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:

Line 1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables

Line 1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

Line 1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1478: l_result BOOLEAN;
1479: l_calling_program VARCHAR2(1000);
1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

Line 1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1479: l_calling_program VARCHAR2(1000);
1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

Line 1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:

Line 1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables

Line 1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables
1492: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

Line 1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables
1492: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1493: l_max_dist_number

Line 1506: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;

1502:
1503: l_debug_info VARCHAR2(4000);
1504: l_current_calling_sequence VARCHAR2(2000);
1505:
1506: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;
1507: l_apply_amount_no_tax_incl NUMBER;
1508: l_ppay_ln_amt_remaining_no_tax NUMBER;
1509: l_prepay_tax_diff_amt NUMBER;
1510:

Line 1511: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1507: l_apply_amount_no_tax_incl NUMBER;
1508: l_ppay_ln_amt_remaining_no_tax NUMBER;
1509: l_prepay_tax_diff_amt NUMBER;
1510:
1511: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1512:
1513: l_api_name VARCHAR2(50);
1514:
1515: tax_exception EXCEPTION;

Line 1575: FROM AP_invoice_lines ail,

1571: ail.po_distribution_id,
1572: ail.rcv_transaction_id,
1573: ail.unit_meas_lookup_code,
1574: plt.matching_basis
1575: FROM AP_invoice_lines ail,
1576: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
1577: po_line_locations pll,
1578: po_line_types_b plt --bug 5056269
1579: -- po_line_types_tl T --bug 5119694

Line 1894: FROM ap_invoice_lines

1890: NVL( ABS(SUM(pa_quantity)), 0 )
1891: INTO l_prepay_ln_s_quant_invoiced,
1892: l_prepay_ln_s_stat_amount,
1893: l_prepay_ln_s_pa_quantity
1894: FROM ap_invoice_lines
1895: WHERE prepay_invoice_id = p_prepay_invoice_id
1896: AND prepay_line_number = p_prepay_line_num;
1897:
1898: IF (l_ppay_ln_po_line_location_id IS NOT NULL OR

Line 1982: FROM ap_invoice_lines

1978: IF (P_calling_mode = 'PREPAYMENT APPLICATION') THEN
1979:
1980: SELECT NVL(MAX (line_number),0) + 1
1981: INTO l_prepay_ln_number
1982: FROM ap_invoice_lines
1983: WHERE invoice_id = p_invoice_id;
1984:
1985:
1986: -- ===========================================================

Line 2065: FROM ap_invoice_lines_all

2061:
2062: BEGIN
2063: SELECT NVL(included_tax_amount, 0)
2064: INTO l_inclusive_tax_amount
2065: FROM ap_invoice_lines_all
2066: WHERE invoice_id = p_invoice_id
2067: AND line_number = l_prepay_ln_number;
2068:
2069: EXCEPTION

Line 2794: UPDATE ap_invoice_lines_all ail

2790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2791: END IF;
2792:
2793: BEGIN
2794: UPDATE ap_invoice_lines_all ail
2795: SET amount = l_apply_amount,
2796: base_amount = l_prepay_ln_base_amount
2797: WHERE ail.invoice_id = p_invoice_id
2798: AND ail.line_number = l_prepay_ln_number;

Line 2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2888: -- ==========================================================
2889: --Bug5224883
2890: -- Get the exculusive tax amount for the prepay appln line.
2891: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2893: WHERE ail.line_type_lookup_code='TAX'
2894: AND ail.invoice_id=p_invoice_id
2895: and aid.invoice_id=ail.invoice_id
2896: AND aid.invoice_line_number=ail.line_number

Line 3139: INSERT INTO AP_Invoice_Lines(

3135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3136: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3137: END IF;
3138:
3139: INSERT INTO AP_Invoice_Lines(
3140: INVOICE_ID,
3141: LINE_NUMBER,
3142: LINE_TYPE_LOOKUP_CODE,
3143: REQUESTER_ID,

Line 3451: FROM ap_invoice_lines

3447: user_defined_fisc_class,
3448: purchasing_category_id,
3449: org_id,
3450: pay_awt_group_id --Bug 9058369
3451: FROM ap_invoice_lines
3452: WHERE invoice_id = p_prepay_invoice_id
3453: AND line_number = p_prepay_line_num;
3454:
3455: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3541: FROM ap_invoice_lines

3537:
3538: --Bug5224996 Added following select stmt
3539: SELECT invoice_includes_prepay_flag
3540: INTO l_invoice_includes_prepay_flag
3541: FROM ap_invoice_lines
3542: WHERE invoice_id=p_invoice_id
3543: AND line_number=p_line_number;
3544:
3545: FOR l_loop_counter IN nvl(p_prepay_dist_info.first,0) .. nvl(p_prepay_dist_info.last,0) LOOP

Line 4196: ap_invoice_lines ail,

4192: aid.amount,
4193: aid.quantity_invoiced,
4194: plt.matching_basis
4195: FROM ap_invoice_distributions aid,
4196: ap_invoice_lines ail,
4197: po_lines pl, /* Amount Based Matching. PO related tables and conditions */
4198: po_line_locations pll,
4199: po_line_types_b plt, --bug 5056269
4200: po_line_types_tl T

Line 4765: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;

4761: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4762: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4763: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4764: l_ppay_apply_amt_in_pay_curr NUMBER;
4765: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4766: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4767: l_debug_info VARCHAR2(4000); --Changed length from 100 to 4000 (8534097)
4768: l_current_calling_sequence VARCHAR2(2000);
4769: l_calling_program VARCHAR2(1000);

Line 4790: FROM AP_INVOICE_LINES

4786: CURSOR C_PPAY_LINE_REC (CV_INVOICE_ID IN NUMBER,
4787: CV_LINE_NUM IN NUMBER)
4788: IS
4789: SELECT *
4790: FROM AP_INVOICE_LINES
4791: WHERE invoice_id = CV_Invoice_ID
4792: AND line_number = CV_line_num;
4793:
4794: BEGIN

Line 4885: l_dummy := AP_INVOICE_LINES_PKG.Discard_Inv_Line (

4881: -- The code should not do anything related to updating PO.
4882: -- We will address this during the Coding Stage.
4883:
4884: -- ==========================================================
4885: l_dummy := AP_INVOICE_LINES_PKG.Discard_Inv_Line (
4886: P_line_rec => l_prepay_line_rec,
4887: P_calling_mode => 'UNAPPLY_PREPAY',
4888: P_inv_cancellable => 'Y',
4889: P_last_updated_by => p_user_id,

Line 5109: ap_invoice_lines ail

5105: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
5106: (ail.invoice_id,
5107: ail.line_number)
5108: FROM ap_invoices ai,
5109: ap_invoice_lines ail
5110: WHERE ai.invoice_id = cv_prepay_invoice_id
5111: AND ail.invoice_id = ai.invoice_id
5112: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
5113: (ail.invoice_id,