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_MATCHED_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 297: FROM ap_invoice_distributions D,

293: nvl(PD.rate,1)) -- po_rate
294: ,nvl(I.exchange_rate, 1) -- inv_rate
295: ,nvl(PLL.price_override,0) -- po_price
296: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
297: FROM ap_invoice_distributions D,
298: ap_invoices I,
299: po_distributions PD,
300: po_line_locations PLL,
301: po_lines PL,

Line 366: FROM ap_invoice_distributions D, --retainage release inv dists

362: nvl(retain_I.exchange_rate,1)) --bug 9242891 retained_inv_rate
363: ,nvl(I.exchange_rate, 1) -- inv_rate
364: ,nvl(PLL.price_override,0) -- po_price
365: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
366: FROM ap_invoice_distributions D, --retainage release inv dists
367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist
368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,

Line 367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist

363: ,nvl(I.exchange_rate, 1) -- inv_rate
364: ,nvl(PLL.price_override,0) -- po_price
365: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
366: FROM ap_invoice_distributions D, --retainage release inv dists
367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist
368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,
371: po_line_locations PLL,

Line 403: FROM ap_invoice_distributions D

399: x_variance_type IN VARCHAR2) IS
400: SELECT D.Invoice_Distribution_Id,
401: NVL(D.amount, 0),
402: NVL(D.base_amount, D.amount)
403: FROM ap_invoice_distributions D
404: WHERE D.related_id = x_invoice_distribution_id
405: AND D.line_type_lookup_code = x_variance_type;
406:
407:

Line 409: ap_invoice_distributions.invoice_distribution_id%TYPE;

405: AND D.line_type_lookup_code = x_variance_type;
406:
407:
408: l_invoice_distribution_id
409: ap_invoice_distributions.invoice_distribution_id%TYPE;
410: l_reversal_flag
411: ap_invoice_distributions.reversal_flag%TYPE;
412: l_distribution_line_number
413: ap_invoice_distributions.distribution_line_number%TYPE;

Line 411: ap_invoice_distributions.reversal_flag%TYPE;

407:
408: l_invoice_distribution_id
409: ap_invoice_distributions.invoice_distribution_id%TYPE;
410: l_reversal_flag
411: ap_invoice_distributions.reversal_flag%TYPE;
412: l_distribution_line_number
413: ap_invoice_distributions.distribution_line_number%TYPE;
414: l_dist_code_combination_id
415: ap_invoice_distributions.dist_code_combination_id%TYPE;

Line 413: ap_invoice_distributions.distribution_line_number%TYPE;

409: ap_invoice_distributions.invoice_distribution_id%TYPE;
410: l_reversal_flag
411: ap_invoice_distributions.reversal_flag%TYPE;
412: l_distribution_line_number
413: ap_invoice_distributions.distribution_line_number%TYPE;
414: l_dist_code_combination_id
415: ap_invoice_distributions.dist_code_combination_id%TYPE;
416: l_related_id
417: ap_invoice_distributions.related_id%TYPE;

Line 415: ap_invoice_distributions.dist_code_combination_id%TYPE;

411: ap_invoice_distributions.reversal_flag%TYPE;
412: l_distribution_line_number
413: ap_invoice_distributions.distribution_line_number%TYPE;
414: l_dist_code_combination_id
415: ap_invoice_distributions.dist_code_combination_id%TYPE;
416: l_related_id
417: ap_invoice_distributions.related_id%TYPE;
418: l_amount
419: ap_invoice_distributions.amount%TYPE;

Line 417: ap_invoice_distributions.related_id%TYPE;

413: ap_invoice_distributions.distribution_line_number%TYPE;
414: l_dist_code_combination_id
415: ap_invoice_distributions.dist_code_combination_id%TYPE;
416: l_related_id
417: ap_invoice_distributions.related_id%TYPE;
418: l_amount
419: ap_invoice_distributions.amount%TYPE;
420: l_base_amount
421: ap_invoice_distributions.base_amount%TYPE;

Line 419: ap_invoice_distributions.amount%TYPE;

415: ap_invoice_distributions.dist_code_combination_id%TYPE;
416: l_related_id
417: ap_invoice_distributions.related_id%TYPE;
418: l_amount
419: ap_invoice_distributions.amount%TYPE;
420: l_base_amount
421: ap_invoice_distributions.base_amount%TYPE;
422: l_ipv_distribution_id
423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

Line 421: ap_invoice_distributions.base_amount%TYPE;

417: ap_invoice_distributions.related_id%TYPE;
418: l_amount
419: ap_invoice_distributions.amount%TYPE;
420: l_base_amount
421: ap_invoice_distributions.base_amount%TYPE;
422: l_ipv_distribution_id
423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
424: l_erv_distribution_id
425: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

Line 423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

419: ap_invoice_distributions.amount%TYPE;
420: l_base_amount
421: ap_invoice_distributions.base_amount%TYPE;
422: l_ipv_distribution_id
423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
424: l_erv_distribution_id
425: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
426: l_line_type_lookup_code
427: ap_invoice_distributions.line_type_lookup_code%TYPE;

Line 425: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

421: ap_invoice_distributions.base_amount%TYPE;
422: l_ipv_distribution_id
423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
424: l_erv_distribution_id
425: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
426: l_line_type_lookup_code
427: ap_invoice_distributions.line_type_lookup_code%TYPE;
428:
429: l_po_variance_ccid NUMBER;

Line 427: ap_invoice_distributions.line_type_lookup_code%TYPE;

423: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
424: l_erv_distribution_id
425: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
426: l_line_type_lookup_code
427: ap_invoice_distributions.line_type_lookup_code%TYPE;
428:
429: l_po_variance_ccid NUMBER;
430: l_accrue_on_receipt_flag VARCHAR2(1);
431: l_destination_type VARCHAR2(25);

Line 443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;

439: l_variance_success BOOLEAN := FALSE;
440: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
442: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;

Line 445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

441: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
442: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;

Line 447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;

443: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
450: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
451: l_po_erv NUMBER := 0;

Line 452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;

448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
450: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
451: l_po_erv NUMBER := 0;
452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
453:
454: l_key_value NUMBER;
455: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;
456:

Line 455: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;

451: l_po_erv NUMBER := 0;
452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
453:
454: l_key_value NUMBER;
455: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;
456:
457: l_debug_loc VARCHAR2(30) := 'Exec_Matched_Variance_Checks';
458: l_curr_calling_sequence VARCHAR2(2000);
459: l_debug_info VARCHAR2(2000);

Line 702: l_variance_success := AP_INVOICE_DISTRIBUTIONS_PKG.Calculate_Variance(

698: /*-----------------------------------------------------------------+
699: | Step 3 - Calculate Variance |
700: +-----------------------------------------------------------------*/
701:
702: l_variance_success := AP_INVOICE_DISTRIBUTIONS_PKG.Calculate_Variance(
703: l_invoice_distribution_id,
704: NULL,
705: l_amount,
706: l_base_amount,

Line 865: INSERT INTO ap_invoice_distributions (

861: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
862: p_invoice_id,
863: p_inv_line_number) + 1;
864:
865: INSERT INTO ap_invoice_distributions (
866: invoice_id,
867: invoice_line_number,
868: distribution_class,
869: invoice_distribution_id,

Line 968: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

964: )
965: (SELECT invoice_id,
966: invoice_line_number,
967: distribution_class,
968: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
969: l_Po_variance_ccid, -- dist_code_combination_id
970: SYSDATE, -- last_update_date
971: p_system_user, -- last_updated_by
972: accounting_date, -- accounting_date

Line 1063: FROM ap_invoice_distributions

1059: awt_group_id, -- bug6843734
1060: pay_awt_group_id, -- bug8222382
1061: 'N', --Bug#11067286
1062: income_tax_region --bug 12908372
1063: FROM ap_invoice_distributions
1064: WHERE invoice_distribution_id = l_invoice_distribution_id );
1065:
1066:
1067: ELSE

Line 1082: UPDATE ap_invoice_distributions

1078: -- Although IPV is not going to change, bipv might be
1079: -- changed because of exchange rate changes
1080: ------------------------------------------------------------
1081:
1082: UPDATE ap_invoice_distributions
1083: SET base_amount = l_bipv,
1084: amount = l_ipv, --Introduced for bug# 9252266
1085: last_updated_by = p_system_user,
1086: last_update_login = fnd_global.login_id

Line 1118: INSERT INTO ap_invoice_distributions (

1114: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
1115: p_invoice_id,
1116: p_inv_line_number) + 1;
1117:
1118: INSERT INTO ap_invoice_distributions (
1119: invoice_id,
1120: invoice_line_number,
1121: distribution_class,
1122: invoice_distribution_id,

Line 1221: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

1217: )
1218: (SELECT Invoice_Id, -- invoice_id
1219: Invoice_Line_Number, -- invoice_line_number
1220: distribution_class,
1221: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
1222: l_erv_ccid, -- dist_code_combination_id
1223: SYSDATE, -- last_update_date
1224: p_system_user, -- last_updated_by
1225: accounting_date, -- accounting_date

Line 1316: FROM ap_invoice_distributions

1312: awt_group_id, -- bug6843734
1313: pay_awt_group_id, -- bug8222382
1314: 'N', /*Bug#11067286 */
1315: income_tax_region --bug 12908372
1316: FROM ap_invoice_distributions
1317: WHERE invoice_distribution_id = l_invoice_distribution_id );
1318:
1319: ELSE
1320: -----------------------------------------------------------

Line 1334: UPDATE ap_invoice_distributions

1330: -- UPDATE the existing ERV line for newly calculated ERV
1331: -- because of exchange rate changes
1332: -------------------------------------------------------------
1333: BEGIN
1334: UPDATE ap_invoice_distributions
1335: SET base_amount = l_erv,
1336: last_updated_by = p_system_user,
1337: last_update_login = fnd_global.login_id
1338: WHERE invoice_distribution_id = l_erv_distribution_id;

Line 1355: DELETE ap_invoice_distributions

1351: -----------------------------------------------------------
1352: -- Existing ERV line - Delete
1353: -----------------------------------------------------------
1354: BEGIN
1355: DELETE ap_invoice_distributions
1356: WHERE invoice_distribution_id = l_erv_distribution_id;
1357: END;
1358:
1359: END IF; -- end of check l_erv_distribution_id <> -1 for Case B

Line 1378: l_debug_info := 'Updating the amounts on ap_invoice_distributions';

1374: ---------------------------------------------------------------
1375: -- Update the parent line with related id and reduced base amt
1376: ---------------------------------------------------------------
1377:
1378: l_debug_info := 'Updating the amounts on ap_invoice_distributions';
1379: BEGIN
1380: UPDATE ap_invoice_distributions AID
1381: SET amount = l_amount, -- modified entered amt
1382: base_amount = l_base_amount, -- modified base amt

Line 1380: UPDATE ap_invoice_distributions AID

1376: ---------------------------------------------------------------
1377:
1378: l_debug_info := 'Updating the amounts on ap_invoice_distributions';
1379: BEGIN
1380: UPDATE ap_invoice_distributions AID
1381: SET amount = l_amount, -- modified entered amt
1382: base_amount = l_base_amount, -- modified base amt
1383: related_id = l_invoice_distribution_id, -- Bug 12660674 (revert 9318619)
1384: extra_po_erv = l_extra_po_erv,

Line 1398: l_debug_info := 'Updating the amounts and related_id on ap_invoice_distributions'||l_invoice_distribution_id;

1394: -- Clear the parent line with related id
1395: ---------------------------------------------------------------
1396: BEGIN
1397:
1398: l_debug_info := 'Updating the amounts and related_id on ap_invoice_distributions'||l_invoice_distribution_id;
1399: UPDATE ap_invoice_distributions AID
1400: SET amount = l_amount,
1401: base_amount = l_base_amount,
1402: related_id = NULL,

Line 1399: UPDATE ap_invoice_distributions AID

1395: ---------------------------------------------------------------
1396: BEGIN
1397:
1398: l_debug_info := 'Updating the amounts and related_id on ap_invoice_distributions'||l_invoice_distribution_id;
1399: UPDATE ap_invoice_distributions AID
1400: SET amount = l_amount,
1401: base_amount = l_base_amount,
1402: related_id = NULL,
1403: extra_po_erv = l_extra_po_erv,

Line 1557: FROM ap_invoice_distributions D,

1553: ,nvl(PLL.price_override, 0) -- l_po_price
1554: ,RSL.item_id -- l_rtxn_item_id
1555: ,PL.unit_meas_lookup_code -- l_po_uom
1556: ,PLL.match_option -- l_match_option
1557: FROM ap_invoice_distributions D,
1558: po_distributions_ap_v PD,
1559: rcv_transactions RTXN,
1560: rcv_shipment_lines RSL,
1561: po_lines PL,

Line 1578: (select 1 from ap_invoice_distributions_all aid1

1574: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
1575:
1576: --9564576 Added the below condition
1577: AND exists
1578: (select 1 from ap_invoice_distributions_all aid1
1579: where NVL(aid1.match_status_flag , 'N') <> 'A'
1580: and aid1.invoice_id=D.invoice_id /*Bug 15968233*/
1581: and aid1.po_distribution_id = PD.po_distribution_id
1582: and aid1.line_type_lookup_code IN ('ITEM' , 'ACCRUAL')

Line 1588: ap_invoice_distributions.invoice_distribution_id%TYPE;

1584: ORDER BY D.po_distribution_id, D.invoice_line_number, D.distribution_line_number;
1585:
1586:
1587: l_invoice_distribution_id
1588: ap_invoice_distributions.invoice_distribution_id%TYPE;
1589: l_distribution_line_number
1590: ap_invoice_distributions.distribution_line_number%TYPE;
1591: l_invoice_line_number
1592: ap_invoice_distributions.invoice_line_number%TYPE;

Line 1590: ap_invoice_distributions.distribution_line_number%TYPE;

1586:
1587: l_invoice_distribution_id
1588: ap_invoice_distributions.invoice_distribution_id%TYPE;
1589: l_distribution_line_number
1590: ap_invoice_distributions.distribution_line_number%TYPE;
1591: l_invoice_line_number
1592: ap_invoice_distributions.invoice_line_number%TYPE;
1593:
1594: l_prev_po_dist_id NUMBER(15) := -1;

Line 1592: ap_invoice_distributions.invoice_line_number%TYPE;

1588: ap_invoice_distributions.invoice_distribution_id%TYPE;
1589: l_distribution_line_number
1590: ap_invoice_distributions.distribution_line_number%TYPE;
1591: l_invoice_line_number
1592: ap_invoice_distributions.invoice_line_number%TYPE;
1593:
1594: l_prev_po_dist_id NUMBER(15) := -1;
1595: l_po_dist_id NUMBER(15);
1596: l_po_qty NUMBER;

Line 1724: UPDATE ap_invoice_distributions

1720: || 'line_number' || to_char(l_invoice_line_number);
1721: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
1722: END IF;
1723:
1724: UPDATE ap_invoice_distributions
1725: SET quantity_variance = decode(nvl(quantity_variance,0)+l_qv,0,
1726: NULL,nvl(quantity_variance,0)+l_qv),
1727: base_quantity_variance = decode(nvl(base_quantity_variance,0)
1728: +l_bqv, 0, NULL,

Line 1744: UPDATE ap_invoice_distributions_all aid

1740:
1741: l_qv_ratio := l_qv_upd/l_amount_upd;
1742: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1743:
1744: UPDATE ap_invoice_distributions_all aid
1745: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1746: (aid.amount * l_qv_ratio, p_inv_currency_code)
1747: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1748: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)

Line 1830: FROM ap_invoice_distributions D,

1826: ,NVL(PD.accrue_on_receipt_flag,'N') -- l_accrue_on_receipt_flag
1827: ,nvl(PD.amount_ordered,0)
1828: - nvl(PD.amount_cancelled,0) -- l_po_amt
1829: ,PLL.match_option -- l_match_option
1830: FROM ap_invoice_distributions D,
1831: po_distributions_ap_v PD,
1832: rcv_transactions RTXN,
1833: rcv_shipment_lines RSL,
1834: po_lines PL,

Line 1851: ap_invoice_distributions.invoice_distribution_id%TYPE;

1847: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
1848: ORDER BY D.po_distribution_id, D.invoice_line_number, D.distribution_line_number;
1849:
1850: l_invoice_distribution_id
1851: ap_invoice_distributions.invoice_distribution_id%TYPE;
1852: l_distribution_line_number
1853: ap_invoice_distributions.distribution_line_number%TYPE;
1854: l_invoice_line_number
1855: ap_invoice_distributions.invoice_line_number%TYPE;

Line 1853: ap_invoice_distributions.distribution_line_number%TYPE;

1849:
1850: l_invoice_distribution_id
1851: ap_invoice_distributions.invoice_distribution_id%TYPE;
1852: l_distribution_line_number
1853: ap_invoice_distributions.distribution_line_number%TYPE;
1854: l_invoice_line_number
1855: ap_invoice_distributions.invoice_line_number%TYPE;
1856:
1857: l_prev_po_dist_id NUMBER(15) := -1;

Line 1855: ap_invoice_distributions.invoice_line_number%TYPE;

1851: ap_invoice_distributions.invoice_distribution_id%TYPE;
1852: l_distribution_line_number
1853: ap_invoice_distributions.distribution_line_number%TYPE;
1854: l_invoice_line_number
1855: ap_invoice_distributions.invoice_line_number%TYPE;
1856:
1857: l_prev_po_dist_id NUMBER(15) := -1;
1858: l_po_dist_id NUMBER(15);
1859: l_po_amt NUMBER;

Line 1871: AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE;

1867: l_update_dist_num NUMBER;
1868: l_po_dist_av NUMBER;
1869: l_po_dist_bav NUMBER;
1870: l_key_value
1871: AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE;
1872:
1873: -- TAV
1874: l_inv_dist_id_upd NUMBER;
1875: l_av_upd NUMBER;

Line 1980: UPDATE ap_invoice_distributions

1976: || 'line_number' || to_char(l_invoice_line_number);
1977: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
1978: END IF;
1979:
1980: UPDATE ap_invoice_distributions
1981: SET amount_variance = decode(nvl(amount_variance,0)+l_av,0,
1982: NULL,nvl(amount_variance,0)+l_av),
1983: base_amount_variance = decode(nvl(base_amount_variance,0)
1984: +l_bav, 0, NULL,

Line 2000: UPDATE ap_invoice_distributions_all aid

1996:
1997: l_av_ratio := l_av_upd/l_amount_upd;
1998: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1999:
2000: UPDATE ap_invoice_distributions_all aid
2001: SET amount_variance = ap_utilities_pkg.ap_round_currency
2002: (aid.amount * l_av_ratio, p_inv_currency_code)
2003: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
2004: (aid.base_amount * l_base_av_ratio, p_base_currency_code)

Line 2181: FROM ap_invoice_distributions AID2

2177: 'MAX SHIP AMOUNT',
2178: 'MAX RATE AMOUNT',
2179: 'MAX TOTAL AMOUNT'))
2180: OR EXISTS (SELECT 'Unapproved matched dist'
2181: FROM ap_invoice_distributions AID2
2182: WHERE AID2.invoice_id = I.invoice_id
2183: AND AID2.invoice_line_number = L.line_number
2184: AND nvl(AID2.match_status_flag, 'X') <> 'A'))
2185: AND I.invoice_id = p_invoice_id

Line 3965: UPDATE ap_invoice_distributions AID

3961:
3962: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3963: p_calling_sequence;
3964:
3965: UPDATE ap_invoice_distributions AID
3966: SET final_match_flag = p_final_match_flag
3967: WHERE AID.invoice_id = p_invoice_id -- Bug 3489536
3968: AND AID.po_distribution_id IN
3969: (SELECT PD.po_distribution_id

Line 4093: FROM ap_invoice_distributions AID,

4089:
4090: CURSOR Final_Match_Release_Cur IS
4091: SELECT PD.line_location_id,
4092: 'CANT CLOSE PO'
4093: FROM ap_invoice_distributions AID,
4094: ap_holds AH,
4095: po_distributions_ap_v PD,
4096: po_line_locations PLL --Bug 3489536
4097: WHERE AH.invoice_id = p_invoice_id

Line 4109: FROM ap_invoice_distributions AID,

4105: GROUP BY PD.line_location_id
4106: UNION
4107: SELECT PD.line_location_id,
4108: 'CANT TRY PO CLOSE'
4109: FROM ap_invoice_distributions AID,
4110: ap_holds AH,
4111: po_distributions_ap_v PD,
4112: po_line_locations PLL --Bug 3489536
4113: WHERE AH.invoice_id = p_invoice_id

Line 4141: ap_invoice_distributions AID,

4137: PD.po_release_id),
4138: PH.segment1,
4139: MAX(aid.accounting_date) Accounting_date
4140: FROM po_distributions_ap_v PD,
4141: ap_invoice_distributions AID,
4142: po_line_locations PLL,
4143: po_headers PH,
4144: po_releases PR
4145: WHERE AID.invoice_id = p_invoice_id

Line 5617: FROM ap_invoice_distributions AIDF,

5613: BEGIN
5614:
5615: SELECT nvl(sum(nvl(AIDF.amount,0)),0)
5616: INTO l_freight_total
5617: FROM ap_invoice_distributions AIDF,
5618: ap_invoice_distributions AIDI,
5619: po_distributions_all POD
5620: WHERE AIDF.charge_applicable_to_dist_id = AIDI.invoice_distribution_id
5621: AND AIDF.line_type_lookup_code = 'FREIGHT'

Line 5618: ap_invoice_distributions AIDI,

5614:
5615: SELECT nvl(sum(nvl(AIDF.amount,0)),0)
5616: INTO l_freight_total
5617: FROM ap_invoice_distributions AIDF,
5618: ap_invoice_distributions AIDI,
5619: po_distributions_all POD
5620: WHERE AIDF.charge_applicable_to_dist_id = AIDI.invoice_distribution_id
5621: AND AIDF.line_type_lookup_code = 'FREIGHT'
5622: AND AIDI.line_type_lookup_code = 'ITEM'

Line 5860: FROM ap_invoice_distributions D, po_distributions_ap_v PD

5856: END IF;
5857:
5858: SELECT SUM( NVL(D.base_amount, 0))
5859: INTO p_rate_amt_var
5860: FROM ap_invoice_distributions D, po_distributions_ap_v PD
5861: WHERE D.po_distribution_id = PD.po_distribution_id
5862: AND PD.line_location_id = p_line_location_id
5863: AND D.invoice_id = p_invoice_id
5864: AND D.line_type_lookup_code = 'ERV';

Line 5877: FROM ap_invoice_distributions D

5873: END IF;
5874:
5875: SELECT SUM(NVL(D.base_amount, 0))
5876: INTO p_rate_amt_var
5877: FROM ap_invoice_distributions D
5878: WHERE D.rcv_transaction_id = p_rcv_transaction_id
5879: AND D.invoice_id = p_invoice_id
5880: AND D.line_type_lookup_code = 'ERV';
5881:

Line 6015: FROM ap_invoice_distributions D

6011: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),
6012: nvl(D.base_amount,D.amount/*,(D.amount * DECODE(I.exchange_rate, null,
6013: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6014: INTO p_ship_base_amt_var
6015: FROM ap_invoice_distributions D
6016: , po_distributions_ap_v PD
6017: , ap_invoices I
6018: , ap_invoice_lines L --Bug6824860
6019: WHERE D.po_distribution_id = PD.po_distribution_id

Line 6036: FROM ap_invoice_distributions D

6032: WHERE RT.transaction_id=p_rcv_transaction_id;
6033:
6034: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6035: INTO p_ship_base_amt_var
6036: FROM ap_invoice_distributions D
6037: , ap_invoices I
6038: , ap_invoice_lines L
6039: ,rcv_transactions RT
6040: WHERE D.rcv_transaction_id = RT.transaction_id

Line 6073: FROM ap_invoice_distributions D

6069: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),
6070: nvl(D.base_amount,D.amount/*,(D.amount * DECODE(I.exchange_rate, null,
6071: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6072: INTO p_ship_base_amt_var
6073: FROM ap_invoice_distributions D
6074: , po_distributions_ap_v PD
6075: , ap_invoices I
6076: , ap_invoice_lines L --Bug6824860
6077: WHERE D.po_distribution_id = PD.po_distribution_id

Line 6094: FROM ap_invoice_distributions D

6090: WHERE RT.transaction_id=p_rcv_transaction_id;
6091:
6092: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6093: INTO p_ship_base_amt_var
6094: FROM ap_invoice_distributions D
6095: , ap_invoices I
6096: , ap_invoice_lines L
6097: ,rcv_transactions RT
6098: WHERE D.rcv_transaction_id = RT.transaction_id

Line 6607: from ap_invoice_distributions aid,

6603:
6604: l_hold_required := 'N';
6605:
6606: For rec_part_funds_check in (select distinct aid.po_distribution_id
6607: from ap_invoice_distributions aid,
6608: ap_invoice_lines ail
6609: where ail.po_line_location_id =l_line_location_id
6610: and ail.invoice_id = P_INVOICE_ID
6611: and ail.invoice_id = aid.invoice_id