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 275: FROM ap_invoice_distributions D,

271: nvl(PD.rate,1)) -- po_rate
272: ,nvl(I.exchange_rate, 1) -- inv_rate
273: ,nvl(PLL.price_override,0) -- po_price
274: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
275: FROM ap_invoice_distributions D,
276: ap_invoices I,
277: po_distributions PD,
278: po_line_locations PLL,
279: po_lines PL,

Line 307: FROM ap_invoice_distributions D

303: x_variance_type IN VARCHAR2) IS
304: SELECT D.Invoice_Distribution_Id,
305: NVL(D.amount, 0),
306: NVL(D.base_amount, D.amount)
307: FROM ap_invoice_distributions D
308: WHERE D.related_id = x_invoice_distribution_id
309: AND D.line_type_lookup_code = x_variance_type;
310:
311:

Line 313: ap_invoice_distributions.invoice_distribution_id%TYPE;

309: AND D.line_type_lookup_code = x_variance_type;
310:
311:
312: l_invoice_distribution_id
313: ap_invoice_distributions.invoice_distribution_id%TYPE;
314: l_reversal_flag
315: ap_invoice_distributions.reversal_flag%TYPE;
316: l_distribution_line_number
317: ap_invoice_distributions.distribution_line_number%TYPE;

Line 315: ap_invoice_distributions.reversal_flag%TYPE;

311:
312: l_invoice_distribution_id
313: ap_invoice_distributions.invoice_distribution_id%TYPE;
314: l_reversal_flag
315: ap_invoice_distributions.reversal_flag%TYPE;
316: l_distribution_line_number
317: ap_invoice_distributions.distribution_line_number%TYPE;
318: l_dist_code_combination_id
319: ap_invoice_distributions.dist_code_combination_id%TYPE;

Line 317: ap_invoice_distributions.distribution_line_number%TYPE;

313: ap_invoice_distributions.invoice_distribution_id%TYPE;
314: l_reversal_flag
315: ap_invoice_distributions.reversal_flag%TYPE;
316: l_distribution_line_number
317: ap_invoice_distributions.distribution_line_number%TYPE;
318: l_dist_code_combination_id
319: ap_invoice_distributions.dist_code_combination_id%TYPE;
320: l_related_id
321: ap_invoice_distributions.related_id%TYPE;

Line 319: ap_invoice_distributions.dist_code_combination_id%TYPE;

315: ap_invoice_distributions.reversal_flag%TYPE;
316: l_distribution_line_number
317: ap_invoice_distributions.distribution_line_number%TYPE;
318: l_dist_code_combination_id
319: ap_invoice_distributions.dist_code_combination_id%TYPE;
320: l_related_id
321: ap_invoice_distributions.related_id%TYPE;
322: l_amount
323: ap_invoice_distributions.amount%TYPE;

Line 321: ap_invoice_distributions.related_id%TYPE;

317: ap_invoice_distributions.distribution_line_number%TYPE;
318: l_dist_code_combination_id
319: ap_invoice_distributions.dist_code_combination_id%TYPE;
320: l_related_id
321: ap_invoice_distributions.related_id%TYPE;
322: l_amount
323: ap_invoice_distributions.amount%TYPE;
324: l_base_amount
325: ap_invoice_distributions.base_amount%TYPE;

Line 323: ap_invoice_distributions.amount%TYPE;

319: ap_invoice_distributions.dist_code_combination_id%TYPE;
320: l_related_id
321: ap_invoice_distributions.related_id%TYPE;
322: l_amount
323: ap_invoice_distributions.amount%TYPE;
324: l_base_amount
325: ap_invoice_distributions.base_amount%TYPE;
326: l_ipv_distribution_id
327: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

Line 325: ap_invoice_distributions.base_amount%TYPE;

321: ap_invoice_distributions.related_id%TYPE;
322: l_amount
323: ap_invoice_distributions.amount%TYPE;
324: l_base_amount
325: ap_invoice_distributions.base_amount%TYPE;
326: l_ipv_distribution_id
327: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
328: l_erv_distribution_id
329: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;

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

323: ap_invoice_distributions.amount%TYPE;
324: l_base_amount
325: ap_invoice_distributions.base_amount%TYPE;
326: l_ipv_distribution_id
327: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
328: l_erv_distribution_id
329: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
330: l_line_type_lookup_code
331: ap_invoice_distributions.line_type_lookup_code%TYPE;

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

325: ap_invoice_distributions.base_amount%TYPE;
326: l_ipv_distribution_id
327: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
328: l_erv_distribution_id
329: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
330: l_line_type_lookup_code
331: ap_invoice_distributions.line_type_lookup_code%TYPE;
332:
333: l_po_variance_ccid NUMBER;

Line 331: ap_invoice_distributions.line_type_lookup_code%TYPE;

327: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
328: l_erv_distribution_id
329: ap_invoice_distributions.invoice_distribution_id%TYPE := -1;
330: l_line_type_lookup_code
331: ap_invoice_distributions.line_type_lookup_code%TYPE;
332:
333: l_po_variance_ccid NUMBER;
334: l_accrue_on_receipt_flag VARCHAR2(1);
335: l_destination_type VARCHAR2(25);

Line 347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;

343: l_variance_success BOOLEAN := FALSE;
344: l_po_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
345: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
346: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
350: l_uom_conv_rate NUMBER := NULL;
351: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;

Line 349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;

345: l_rtxn_uom PO_LINES.UNIT_MEAS_LOOKUP_CODE%TYPE;
346: l_match_option PO_LINE_LOCATIONS.MATCH_OPTION%TYPE;
347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
350: l_uom_conv_rate NUMBER := NULL;
351: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;

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

347: l_qty_invoiced AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE;
348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
350: l_uom_conv_rate NUMBER := NULL;
351: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
354: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
355: l_po_erv NUMBER := 0;

Line 356: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;

352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
354: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
355: l_po_erv NUMBER := 0;
356: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
357:
358: l_key_value NUMBER;
359: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;
360:

Line 359: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;

355: l_po_erv NUMBER := 0;
356: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
357:
358: l_key_value NUMBER;
359: l_max_dist_line_number AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER%TYPE;
360:
361: l_debug_loc VARCHAR2(30) := 'Exec_Matched_Variance_Checks';
362: l_curr_calling_sequence VARCHAR2(2000);
363: l_debug_info VARCHAR2(100);

Line 518: l_variance_success := AP_INVOICE_DISTRIBUTIONS_PKG.Calculate_Variance(

514: /*-----------------------------------------------------------------+
515: | Step 3 - Calculate Variance |
516: +-----------------------------------------------------------------*/
517:
518: l_variance_success := AP_INVOICE_DISTRIBUTIONS_PKG.Calculate_Variance(
519: l_invoice_distribution_id,
520: NULL,
521: l_amount,
522: l_base_amount,

Line 679: INSERT INTO ap_invoice_distributions (

675: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
676: p_invoice_id,
677: p_inv_line_number) + 1;
678:
679: INSERT INTO ap_invoice_distributions (
680: invoice_id,
681: invoice_line_number,
682: distribution_class,
683: invoice_distribution_id,

Line 779: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

775: pay_awt_group_id) -- bug8222382
776: (SELECT invoice_id,
777: invoice_line_number,
778: distribution_class,
779: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
780: l_Po_variance_ccid, -- dist_code_combination_id
781: SYSDATE, -- last_update_date
782: p_system_user, -- last_updated_by
783: accounting_date, -- accounting_date

Line 871: FROM ap_invoice_distributions

867: cancellation_flag ,
868: 'N', --rcv_charge_addition_flag
869: awt_group_id, -- bug6843734
870: pay_awt_group_id -- bug8222382
871: FROM ap_invoice_distributions
872: WHERE invoice_distribution_id = l_invoice_distribution_id );
873:
874:
875: ELSE

Line 890: UPDATE ap_invoice_distributions

886: -- Although IPV is not going to change, bipv might be
887: -- changed because of exchange rate changes
888: ------------------------------------------------------------
889:
890: UPDATE ap_invoice_distributions
891: SET base_amount = l_bipv,
892: last_updated_by = p_system_user,
893: last_update_login = fnd_global.login_id
894: WHERE invoice_distribution_id = l_ipv_distribution_id;

Line 925: INSERT INTO ap_invoice_distributions (

921: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
922: p_invoice_id,
923: p_inv_line_number) + 1;
924:
925: INSERT INTO ap_invoice_distributions (
926: invoice_id,
927: invoice_line_number,
928: distribution_class,
929: invoice_distribution_id,

Line 1025: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

1021: pay_awt_group_id) -- bug8222382
1022: (SELECT Invoice_Id, -- invoice_id
1023: Invoice_Line_Number, -- invoice_line_number
1024: distribution_class,
1025: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
1026: l_erv_ccid, -- dist_code_combination_id
1027: SYSDATE, -- last_update_date
1028: p_system_user, -- last_updated_by
1029: accounting_date, -- accounting_date

Line 1117: FROM ap_invoice_distributions

1113: cancellation_flag ,
1114: 'N', -- rcv_charge_addition_flag
1115: awt_group_id, -- bug6843734
1116: pay_awt_group_id -- bug8222382
1117: FROM ap_invoice_distributions
1118: WHERE invoice_distribution_id = l_invoice_distribution_id );
1119:
1120: ELSE
1121: -----------------------------------------------------------

Line 1135: UPDATE ap_invoice_distributions

1131: -- UPDATE the existing ERV line for newly calculated ERV
1132: -- because of exchange rate changes
1133: -------------------------------------------------------------
1134: BEGIN
1135: UPDATE ap_invoice_distributions
1136: SET base_amount = l_erv,
1137: last_updated_by = p_system_user,
1138: last_update_login = fnd_global.login_id
1139: WHERE invoice_distribution_id = l_erv_distribution_id;

Line 1156: DELETE ap_invoice_distributions

1152: -----------------------------------------------------------
1153: -- Existing ERV line - Delete
1154: -----------------------------------------------------------
1155: BEGIN
1156: DELETE ap_invoice_distributions
1157: WHERE invoice_distribution_id = l_erv_distribution_id;
1158: END;
1159:
1160: END IF; -- end of check l_erv_distribution_id <> -1 for Case B

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

1175: ---------------------------------------------------------------
1176: -- Update the parent line with related id and reduced base amt
1177: ---------------------------------------------------------------
1178:
1179: l_debug_info := 'Updating the amounts on ap_invoice_distributions';
1180: BEGIN
1181: UPDATE ap_invoice_distributions AID
1182: SET amount = l_amount, -- modified entered amt
1183: base_amount = l_base_amount, -- modified base amt

Line 1181: UPDATE ap_invoice_distributions AID

1177: ---------------------------------------------------------------
1178:
1179: l_debug_info := 'Updating the amounts on ap_invoice_distributions';
1180: BEGIN
1181: UPDATE ap_invoice_distributions AID
1182: SET amount = l_amount, -- modified entered amt
1183: base_amount = l_base_amount, -- modified base amt
1184: related_id = l_invoice_distribution_id,
1185: extra_po_erv = l_extra_po_erv,

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

1195: -- Clear the parent line with related id
1196: ---------------------------------------------------------------
1197: BEGIN
1198:
1199: l_debug_info := 'Updating the amounts and related_id on ap_invoice_distributions'||l_invoice_distribution_id;
1200: UPDATE ap_invoice_distributions AID
1201: SET amount = l_amount,
1202: base_amount = l_base_amount,
1203: related_id = NULL,

Line 1200: UPDATE ap_invoice_distributions AID

1196: ---------------------------------------------------------------
1197: BEGIN
1198:
1199: l_debug_info := 'Updating the amounts and related_id on ap_invoice_distributions'||l_invoice_distribution_id;
1200: UPDATE ap_invoice_distributions AID
1201: SET amount = l_amount,
1202: base_amount = l_base_amount,
1203: related_id = NULL,
1204: extra_po_erv = l_extra_po_erv,

Line 1338: FROM ap_invoice_distributions D,

1334: ,nvl(PLL.price_override, 0) -- l_po_price
1335: ,RSL.item_id -- l_rtxn_item_id
1336: ,PL.unit_meas_lookup_code -- l_po_uom
1337: ,PLL.match_option -- l_match_option
1338: FROM ap_invoice_distributions D,
1339: po_distributions_ap_v PD,
1340: rcv_transactions RTXN,
1341: rcv_shipment_lines RSL,
1342: po_lines PL,

Line 1360: ap_invoice_distributions.invoice_distribution_id%TYPE;

1356: ORDER BY D.po_distribution_id, D.invoice_line_number, D.distribution_line_number;
1357:
1358:
1359: l_invoice_distribution_id
1360: ap_invoice_distributions.invoice_distribution_id%TYPE;
1361: l_distribution_line_number
1362: ap_invoice_distributions.distribution_line_number%TYPE;
1363: l_invoice_line_number
1364: ap_invoice_distributions.invoice_line_number%TYPE;

Line 1362: ap_invoice_distributions.distribution_line_number%TYPE;

1358:
1359: l_invoice_distribution_id
1360: ap_invoice_distributions.invoice_distribution_id%TYPE;
1361: l_distribution_line_number
1362: ap_invoice_distributions.distribution_line_number%TYPE;
1363: l_invoice_line_number
1364: ap_invoice_distributions.invoice_line_number%TYPE;
1365:
1366: l_prev_po_dist_id NUMBER(15) := -1;

Line 1364: ap_invoice_distributions.invoice_line_number%TYPE;

1360: ap_invoice_distributions.invoice_distribution_id%TYPE;
1361: l_distribution_line_number
1362: ap_invoice_distributions.distribution_line_number%TYPE;
1363: l_invoice_line_number
1364: ap_invoice_distributions.invoice_line_number%TYPE;
1365:
1366: l_prev_po_dist_id NUMBER(15) := -1;
1367: l_po_dist_id NUMBER(15);
1368: l_po_qty NUMBER;

Line 1496: UPDATE ap_invoice_distributions

1492: || 'line_number' || to_char(l_invoice_line_number);
1493: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
1494: END IF;
1495:
1496: UPDATE ap_invoice_distributions
1497: SET quantity_variance = decode(nvl(quantity_variance,0)+l_qv,0,
1498: NULL,nvl(quantity_variance,0)+l_qv),
1499: base_quantity_variance = decode(nvl(base_quantity_variance,0)
1500: +l_bqv, 0, NULL,

Line 1516: UPDATE ap_invoice_distributions_all aid

1512:
1513: l_qv_ratio := l_qv_upd/l_amount_upd;
1514: l_base_qv_ratio := l_base_qv_upd/l_base_amount_upd;
1515:
1516: UPDATE ap_invoice_distributions_all aid
1517: SET quantity_variance = ap_utilities_pkg.ap_round_currency
1518: (aid.amount * l_qv_ratio, p_inv_currency_code)
1519: ,base_quantity_variance = ap_utilities_pkg.ap_round_currency
1520: (aid.base_amount * l_base_qv_ratio, p_base_currency_code)

Line 1602: FROM ap_invoice_distributions D,

1598: ,NVL(PD.accrue_on_receipt_flag,'N') -- l_accrue_on_receipt_flag
1599: ,nvl(PD.amount_ordered,0)
1600: - nvl(PD.amount_cancelled,0) -- l_po_amt
1601: ,PLL.match_option -- l_match_option
1602: FROM ap_invoice_distributions D,
1603: po_distributions_ap_v PD,
1604: rcv_transactions RTXN,
1605: rcv_shipment_lines RSL,
1606: po_lines PL,

Line 1623: ap_invoice_distributions.invoice_distribution_id%TYPE;

1619: AND RTXN.shipment_line_id = RSL.shipment_line_id(+)
1620: ORDER BY D.po_distribution_id, D.invoice_line_number, D.distribution_line_number;
1621:
1622: l_invoice_distribution_id
1623: ap_invoice_distributions.invoice_distribution_id%TYPE;
1624: l_distribution_line_number
1625: ap_invoice_distributions.distribution_line_number%TYPE;
1626: l_invoice_line_number
1627: ap_invoice_distributions.invoice_line_number%TYPE;

Line 1625: ap_invoice_distributions.distribution_line_number%TYPE;

1621:
1622: l_invoice_distribution_id
1623: ap_invoice_distributions.invoice_distribution_id%TYPE;
1624: l_distribution_line_number
1625: ap_invoice_distributions.distribution_line_number%TYPE;
1626: l_invoice_line_number
1627: ap_invoice_distributions.invoice_line_number%TYPE;
1628:
1629: l_prev_po_dist_id NUMBER(15) := -1;

Line 1627: ap_invoice_distributions.invoice_line_number%TYPE;

1623: ap_invoice_distributions.invoice_distribution_id%TYPE;
1624: l_distribution_line_number
1625: ap_invoice_distributions.distribution_line_number%TYPE;
1626: l_invoice_line_number
1627: ap_invoice_distributions.invoice_line_number%TYPE;
1628:
1629: l_prev_po_dist_id NUMBER(15) := -1;
1630: l_po_dist_id NUMBER(15);
1631: l_po_amt NUMBER;

Line 1643: AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE;

1639: l_update_dist_num NUMBER;
1640: l_po_dist_av NUMBER;
1641: l_po_dist_bav NUMBER;
1642: l_key_value
1643: AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE;
1644:
1645: -- TAV
1646: l_inv_dist_id_upd NUMBER;
1647: l_av_upd NUMBER;

Line 1752: UPDATE ap_invoice_distributions

1748: || 'line_number' || to_char(l_invoice_line_number);
1749: AP_Debug_Pkg.Print(g_debug_mode, l_debug_info );
1750: END IF;
1751:
1752: UPDATE ap_invoice_distributions
1753: SET amount_variance = decode(nvl(amount_variance,0)+l_av,0,
1754: NULL,nvl(amount_variance,0)+l_av),
1755: base_amount_variance = decode(nvl(base_amount_variance,0)
1756: +l_bav, 0, NULL,

Line 1772: UPDATE ap_invoice_distributions_all aid

1768:
1769: l_av_ratio := l_av_upd/l_amount_upd;
1770: l_base_av_ratio := l_base_av_upd/l_base_amount_upd;
1771:
1772: UPDATE ap_invoice_distributions_all aid
1773: SET amount_variance = ap_utilities_pkg.ap_round_currency
1774: (aid.amount * l_av_ratio, p_inv_currency_code)
1775: ,base_amount_variance = ap_utilities_pkg.ap_round_currency
1776: (aid.base_amount * l_base_av_ratio, p_base_currency_code)

Line 1953: FROM ap_invoice_distributions AID2

1949: 'MAX SHIP AMOUNT',
1950: 'MAX RATE AMOUNT',
1951: 'MAX TOTAL AMOUNT'))
1952: OR EXISTS (SELECT 'Unapproved matched dist'
1953: FROM ap_invoice_distributions AID2
1954: WHERE AID2.invoice_id = I.invoice_id
1955: AND AID2.invoice_line_number = L.line_number
1956: AND nvl(AID2.match_status_flag, 'X') <> 'A'))
1957: AND I.invoice_id = p_invoice_id

Line 3522: UPDATE ap_invoice_distributions AID

3518:
3519: l_curr_calling_sequence := 'AP_APPROVAL_MATCHED_PKG.'||l_debug_loc||'<-'||
3520: p_calling_sequence;
3521:
3522: UPDATE ap_invoice_distributions AID
3523: SET final_match_flag = p_final_match_flag
3524: WHERE AID.invoice_id = p_invoice_id -- Bug 3489536
3525: AND AID.po_distribution_id IN
3526: (SELECT PD.po_distribution_id

Line 3650: FROM ap_invoice_distributions AID,

3646:
3647: CURSOR Final_Match_Release_Cur IS
3648: SELECT PD.line_location_id,
3649: 'CANT CLOSE PO'
3650: FROM ap_invoice_distributions AID,
3651: ap_holds AH,
3652: po_distributions_ap_v PD,
3653: po_line_locations PLL --Bug 3489536
3654: WHERE AH.invoice_id = p_invoice_id

Line 3666: FROM ap_invoice_distributions AID,

3662: GROUP BY PD.line_location_id
3663: UNION
3664: SELECT PD.line_location_id,
3665: 'CANT TRY PO CLOSE'
3666: FROM ap_invoice_distributions AID,
3667: ap_holds AH,
3668: po_distributions_ap_v PD,
3669: po_line_locations PLL --Bug 3489536
3670: WHERE AH.invoice_id = p_invoice_id

Line 3698: ap_invoice_distributions AID,

3694: PD.po_release_id),
3695: PH.segment1,
3696: MAX(aid.accounting_date) Accounting_date
3697: FROM po_distributions_ap_v PD,
3698: ap_invoice_distributions AID,
3699: po_line_locations PLL,
3700: po_headers PH,
3701: po_releases PR
3702: WHERE AID.invoice_id = p_invoice_id

Line 5195: FROM ap_invoice_distributions AIDF,

5191: BEGIN
5192:
5193: SELECT nvl(sum(nvl(AIDF.amount,0)),0)
5194: INTO l_freight_total
5195: FROM ap_invoice_distributions AIDF,
5196: ap_invoice_distributions AIDI,
5197: po_distributions_all POD
5198: WHERE AIDF.charge_applicable_to_dist_id = AIDI.invoice_distribution_id
5199: AND AIDF.line_type_lookup_code = 'FREIGHT'

Line 5196: ap_invoice_distributions AIDI,

5192:
5193: SELECT nvl(sum(nvl(AIDF.amount,0)),0)
5194: INTO l_freight_total
5195: FROM ap_invoice_distributions AIDF,
5196: ap_invoice_distributions AIDI,
5197: po_distributions_all POD
5198: WHERE AIDF.charge_applicable_to_dist_id = AIDI.invoice_distribution_id
5199: AND AIDF.line_type_lookup_code = 'FREIGHT'
5200: AND AIDI.line_type_lookup_code = 'ITEM'

Line 5438: FROM ap_invoice_distributions D, po_distributions_ap_v PD

5434: END IF;
5435:
5436: SELECT SUM( NVL(D.base_amount, 0))
5437: INTO p_rate_amt_var
5438: FROM ap_invoice_distributions D, po_distributions_ap_v PD
5439: WHERE D.po_distribution_id = PD.po_distribution_id
5440: AND PD.line_location_id = p_line_location_id
5441: AND D.invoice_id = p_invoice_id
5442: AND D.line_type_lookup_code = 'ERV';

Line 5455: FROM ap_invoice_distributions D

5451: END IF;
5452:
5453: SELECT SUM(NVL(D.base_amount, 0))
5454: INTO p_rate_amt_var
5455: FROM ap_invoice_distributions D
5456: WHERE D.rcv_transaction_id = p_rcv_transaction_id
5457: AND D.invoice_id = p_invoice_id
5458: AND D.line_type_lookup_code = 'ERV';
5459:

Line 5602: FROM ap_invoice_distributions D

5598: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),
5599: nvl(D.base_amount,(D.amount * DECODE(I.exchange_rate, null,
5600: PD.rate, I.exchange_rate)))))
5601: INTO p_ship_base_amt_var
5602: FROM ap_invoice_distributions D
5603: , po_distributions_ap_v PD
5604: , ap_invoices I
5605: , ap_invoice_lines L --Bug6824860
5606: WHERE D.po_distribution_id = PD.po_distribution_id