DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 469: l_index po_distributions_all.po_distribution_id%TYPE;

465: AND line_number = p_invoice_line_number;
466:
467: l_invoice_line_rec ap_invoice_lines%ROWTYPE;
468: l_match_mode VARCHAR2(8);
469: l_index po_distributions_all.po_distribution_id%TYPE;
470: l_dist_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
471: l_corr_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
472: l_dist_tab ap_matching_pkg.dist_tab_type;
473: l_othr_chrg_tab ap_othr_chrg_match_pkg.othr_chrg_match_tabtype;

Line 1081: po_distributions_all pd,

1077: decode(pll.matching_basis,'QUANTITY',sum(nvl(aid.quantity_invoiced,0))),
1078: decode(pll.matching_basis,'AMOUNT',sum(nvl(aid.amount,0))),
1079: pll.matching_basis
1080: from ap_invoice_distributions aid,
1081: po_distributions_all pd,
1082: po_line_locations pll
1083: where pll.line_location_id = p_po_line_location_id
1084: and pll.shipment_type <> 'PREPAYMENT'
1085: and aid.po_distribution_id = pd.po_distribution_id