DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 254: FROM ap_invoice_distributions AID

250: 'AMOUNT_CORRECTION', 0, 'ITEM_TO_SERVICE_PO', 0,'ITEM_TO_SERVICE_RECEIPT', 0,
251: NVL( aid.corrected_quantity,0 ) + NVL( aid.quantity_invoiced,0 ))),0) /*Bug13691308*/
252: /*nvl(sum(nvl(quantity_invoiced,0)),0)-nvl(sum(nvl(price_correct_qty,0)),0)*/ --6509492
253: INTO p_billed_qty
254: FROM ap_invoice_distributions AID
255: WHERE AID.rcv_transaction_id = P_rcv_transaction_id --bug 7532498
256: AND AID.po_distribution_id = P_po_distribution_id
257: --BUGFIX:5641346
258: AND line_type_lookup_code NOT IN ('RETAINAGE','PREPAY');

Line 414: From ap_invoice_distributions_all aid,

410: Begin
411:
412: Select Nvl(Sum(aid.corrected_quantity), 0)
413: Into l_existing_corr_qty
414: From ap_invoice_distributions_all aid,
415: ap_invoice_lines_all ail
416: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
417: And ail.line_number = aid.invoice_line_number
418: And ail.match_type = 'QTY_CORRECTION'

Line 465: FROM ap_invoice_distributions_all

461:
462: -- Bug 5585744 , added the line_type_lookup_code condition
463: SELECT count(*)
464: INTO p_num_line_dists
465: FROM ap_invoice_distributions_all
466: WHERE invoice_id = P_invoice_id
467: AND invoice_line_number = P_invoice_line_number
468: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
469: AND prepay_distribution_id is NULL;

Line 474: FROM ap_invoice_distributions_all

470:
471: If (p_num_line_dists = 1 ) Then
472: SELECT invoice_distribution_id
473: INTO p_inv_distribution_id
474: FROM ap_invoice_distributions_all
475: WHERE invoice_id = P_invoice_id
476: AND invoice_line_number = P_invoice_line_number
477: AND line_type_lookup_code in ('ITEM', 'ACCRUAL')
478: AND prepay_distribution_id is NULL;

Line 510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

506:
507: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
508: l_match_mode VARCHAR2(8);
509: l_index po_distributions_all.po_distribution_id%TYPE;
510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
512: l_dist_tab ap_matching_pkg.dist_tab_type;
513: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
514: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;

Line 511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;

507: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
508: l_match_mode VARCHAR2(8);
509: l_index po_distributions_all.po_distribution_id%TYPE;
510: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
511: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
512: l_dist_tab ap_matching_pkg.dist_tab_type;
513: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;
514: l_corr_dist_tab ap_matching_pkg.corr_dist_tab_type;
515: l_inv_line_tab ap_invoice_corrections_pkg.line_tab_type;

Line 590: FROM ap_invoice_distributions

586: BEGIN
587:
588: SELECT invoice_distribution_id, dist_code_combination_id
589: INTO l_corr_inv_dist_id, l_dist_ccid
590: FROM ap_invoice_distributions
591: WHERE invoice_id = l_invoice_line_rec.corrected_inv_id
592: AND invoice_line_number = l_invoice_line_rec.corrected_line_number
593: AND po_distribution_id = l_invoice_line_rec.po_distribution_id
594: AND line_type_lookup_code in ('ITEM', 'ACCRUAL') /*Bug15980592*/

Line 921: FROM ap_invoice_distributions AID

917:
918: BEGIN
919: SELECT sum(amount)
920: INTO p_billed_amt
921: FROM ap_invoice_distributions AID
922: --Bug#10140824. Removed NVL condition with rcv_transaction_id
923: WHERE AID.rcv_transaction_id = P_rcv_transaction_id
924: AND AID.po_distribution_id = P_po_distribution_id
925: --Bugfix:5641346

Line 947: From ap_invoice_distributions_all

943: Begin
944:
945: Select amount
946: Into l_dist_amt
947: From ap_invoice_distributions_all
948: Where invoice_distribution_id = p_invoice_dist_id;
949:
950: Select Nvl(Sum(aid.amount), 0)
951: Into l_existing_corr_amt

Line 952: From ap_invoice_distributions_all aid,

948: Where invoice_distribution_id = p_invoice_dist_id;
949:
950: Select Nvl(Sum(aid.amount), 0)
951: Into l_existing_corr_amt
952: From ap_invoice_distributions_all aid,
953: ap_invoice_lines_all ail
954: Where aid.corrected_invoice_dist_id = p_invoice_dist_id
955: And ail.line_number = aid.invoice_line_number
956: And ail.match_type = 'LINE_CORRECTION'

Line 1074: from ap_invoice_distributions_all aid

1070: AND ail.line_type_lookup_code not in ('AWT','TAX')
1071: AND (ail.line_type_lookup_code <> 'PREPAY'
1072: OR nvl(ail.invoice_includes_prepay_flag,'N') = 'Y')
1073: AND not exists (select 'matched dists'
1074: from ap_invoice_distributions_all aid
1075: where aid.invoice_id = ail.invoice_id
1076: and aid.invoice_line_number = ail.line_number
1077: and aid.po_distribution_id is not null);
1078:

Line 1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

1107: l_po_distribution_id NUMBER;
1108:
1109: TYPE dist_record_type is RECORD
1110: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1115: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);

Line 1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,

1108:
1109: TYPE dist_record_type is RECORD
1110: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1115: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);
1116:

Line 1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

1109: TYPE dist_record_type is RECORD
1110: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1115: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);
1116:
1117: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;

Line 1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,

1110: (po_distribution_id PO_DISTRIBUTIONS.po_distribution_id%TYPE, --Index Column
1111: total_dist_qty_invoiced AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1112: total_dist_qty_applied AP_INVOICE_DISTRIBUTIONS.quantity_invoiced%TYPE,
1113: total_dist_amt_invoiced AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1114: total_dist_amt_applied AP_INVOICE_DISTRIBUTIONS.amount%TYPE,
1115: matching_basis PO_LINE_LOCATIONS.matching_basis%TYPE);
1116:
1117: TYPE dist_tab_type IS TABLE OF dist_record_type INDEX BY BINARY_INTEGER;
1118:

Line 1130: FROM ap_invoice_distributions_v aid,

1126: SELECT aid.po_distribution_id,
1127: decode(pll.matching_basis,'QUANTITY',sum(nvl(aid.quantity_invoiced,0))),
1128: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1129: pll.matching_basis
1130: FROM ap_invoice_distributions_v aid,
1131: ap_invoices ai,
1132: po_line_locations pll
1133: WHERE pll.line_location_id = P_Po_Line_Location_Id
1134: AND pll.shipment_type <> 'PREPAYMENT'

Line 1145: from ap_invoice_distributions aid,

1141: select aid.po_distribution_id,
1142: decode(pll.matching_basis,'QUANTITY',sum(nvl(aid.quantity_invoiced,0))),
1143: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1144: pll.matching_basis
1145: from ap_invoice_distributions aid,
1146: po_distributions_all pd,
1147: po_line_locations pll
1148: where pll.line_location_id = p_po_line_location_id
1149: and pll.shipment_type <> 'PREPAYMENT'

Line 1364: FROM ap_invoice_distributions

1360:
1361: CURSOR C_Prepay_dists IS
1362: SELECT prepay_distribution_id,
1363: amount
1364: FROM ap_invoice_distributions
1365: WHERE invoice_id = p_invoice_id
1366: AND invoice_line_number = p_invoice_line_number
1367: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1368: AND prepay_distribution_id IS NOT NULL;

Line 1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;

1398: l_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1404: l_prepay_dist_id_list prepay_dist_id_list;
1405: l_recoup_amount_list recoup_amount_list;
1406:

Line 1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;

1399: l_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1400: l_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1401: l_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1402: TYPE PREPAY_DIST_ID_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.PREPAY_DISTRIBUTION_ID%TYPE INDEX BY PLS_INTEGER;
1403: TYPE RECOUP_AMOUNT_LIST IS TABLE OF AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE INDEX BY PLS_INTEGER;
1404: l_prepay_dist_id_list prepay_dist_id_list;
1405: l_recoup_amount_list recoup_amount_list;
1406:
1407: tax_exception EXCEPTION;

Line 1559: UPDATE ap_invoice_distributions

1555:
1556: CLOSE c_prepay_dists;
1557:
1558: FORALL i IN l_prepay_dist_id_list.first .. l_prepay_dist_id_list.last
1559: UPDATE ap_invoice_distributions
1560: SET prepay_amount_remaining = prepay_amount_remaining + l_recoup_amount_list(i)
1561: WHERE invoice_distribution_id = l_prepay_dist_id_list(i);
1562:
1563: l_debug_info := 'Update payment schedules with the tax on recouped distributions';

Line 1570: FROM ap_invoice_distributions aid,

1566: END IF;
1567:
1568: SELECT sum(aid.amount)
1569: INTO l_recouped_tax_amount
1570: FROM ap_invoice_distributions aid,
1571: ap_invoice_distributions aid1,
1572: ap_invoice_lines ail
1573: WHERE aid.invoice_id = p_invoice_id
1574: AND aid.invoice_line_number = p_invoice_line_number

Line 1571: ap_invoice_distributions aid1,

1567:
1568: SELECT sum(aid.amount)
1569: INTO l_recouped_tax_amount
1570: FROM ap_invoice_distributions aid,
1571: ap_invoice_distributions aid1,
1572: ap_invoice_lines ail
1573: WHERE aid.invoice_id = p_invoice_id
1574: AND aid.invoice_line_number = p_invoice_line_number
1575: AND ail.invoice_id = aid.invoice_id

Line 1661: FROM ap_invoice_distributions aid,

1657: IF (p_invoice_line_number IS NOT NULL) THEN
1658:
1659: SELECT sum(aid.amount)
1660: INTO l_recouped_amount
1661: FROM ap_invoice_distributions aid,
1662: ap_invoice_lines ail
1663: WHERE aid.invoice_id = p_invoice_id
1664: AND aid.invoice_line_number = p_invoice_line_number
1665: AND ail.invoice_id = aid.invoice_id

Line 1674: FROM ap_invoice_distributions aid1

1670: OR (aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX') and
1671: aid.prepay_distribution_id IS NOT NULL)
1672: OR (aid.line_type_lookup_code IN ('TIPV','TRV','TERV')
1673: and aid.related_id IN (SELECT invoice_distribution_id
1674: FROM ap_invoice_distributions aid1
1675: WHERE aid1.invoice_id = aid.invoice_id
1676: AND aid1.invoice_line_number = aid.invoice_line_number
1677: AND aid1.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1678: AND aid1.prepay_distribution_id IS NOT NULL)

Line 1685: FROM ap_invoice_distributions aid,

1681: ELSE
1682:
1683: SELECT sum(aid.amount)
1684: INTO l_recouped_amount
1685: FROM ap_invoice_distributions aid,
1686: ap_invoice_lines ail
1687: WHERE aid.invoice_id = p_invoice_id
1688: AND ail.invoice_id = aid.invoice_id
1689: AND ail.line_number = aid.invoice_line_number

Line 1697: FROM ap_invoice_distributions aid1

1693: OR (aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX') and
1694: aid.prepay_distribution_id IS NOT NULL)
1695: OR (aid.line_type_lookup_code IN ('TIPV','TRV','TERV')
1696: and aid.related_id IN (SELECT invoice_distribution_id
1697: FROM ap_invoice_distributions aid1
1698: WHERE aid1.invoice_id = aid.invoice_id
1699: AND aid1.invoice_line_number = aid.invoice_line_number
1700: AND aid1.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1701: AND aid1.prepay_distribution_id IS NOT NULL)

Line 1724: FROM ap_invoice_distributions aid

1720: l_recouped_amount := 0;
1721:
1722: SELECT sum(aid.amount)
1723: INTO l_recouped_amount
1724: FROM ap_invoice_distributions aid
1725: WHERE aid.invoice_id = p_invoice_id
1726: AND aid.invoice_line_number = p_invoice_line_number
1727: AND aid.line_type_lookup_code = 'PREPAY'
1728: AND aid.prepay_distribution_id IN (SELECT aid1.invoice_distribution_id

Line 1729: FROM ap_invoice_distributions aid1

1725: WHERE aid.invoice_id = p_invoice_id
1726: AND aid.invoice_line_number = p_invoice_line_number
1727: AND aid.line_type_lookup_code = 'PREPAY'
1728: AND aid.prepay_distribution_id IN (SELECT aid1.invoice_distribution_id
1729: FROM ap_invoice_distributions aid1
1730: WHERE aid1.invoice_id = p_prepay_invoice_id
1731: AND aid1.invoice_line_number = p_prepay_line_number);
1732:
1733: RETURN(l_recouped_amount);

Line 1752: FROM ap_invoice_distributions aid

1748: l_recouped_tax_amount := 0;
1749:
1750: SELECT sum(aid.amount)
1751: INTO l_recouped_tax_amount
1752: FROM ap_invoice_distributions aid
1753: WHERE aid.invoice_id = p_invoice_id
1754: AND aid.invoice_line_number = p_invoice_line_number
1755: AND
1756: ((aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')

Line 1758: FROM ap_invoice_distributions aid1

1754: AND aid.invoice_line_number = p_invoice_line_number
1755: AND
1756: ((aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1757: and aid.prepay_distribution_id IN (SELECT aid1.invoice_distribution_id
1758: FROM ap_invoice_distributions aid1
1759: WHERE aid1.invoice_id = p_prepay_invoice_id
1760: AND aid1.invoice_line_number = p_prepay_line_number)
1761: ) OR
1762: (aid.line_type_lookup_code IN ('TIPV','TRV','TERV')

Line 1764: FROM ap_invoice_distributions aid2

1760: AND aid1.invoice_line_number = p_prepay_line_number)
1761: ) OR
1762: (aid.line_type_lookup_code IN ('TIPV','TRV','TERV')
1763: and aid.related_id IN (SELECT invoice_distribution_id
1764: FROM ap_invoice_distributions aid2
1765: WHERE aid2.invoice_id = aid.invoice_id
1766: AND aid2.invoice_line_number = aid.invoice_line_number
1767: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1768: AND aid2.prepay_distribution_id IN

Line 1770: FROM ap_invoice_distributions aid4

1766: AND aid2.invoice_line_number = aid.invoice_line_number
1767: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
1768: AND aid2.prepay_distribution_id IN
1769: (SELECT aid4.invoice_distribution_id
1770: FROM ap_invoice_distributions aid4
1771: WHERE aid4.invoice_id = p_prepay_invoice_id
1772: AND aid4.invoice_line_number = p_prepay_line_number)
1773: )
1774: )