DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_V

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'