DBA Data[Home] [Help]

APPS.AP_APPROVAL_MATCHED_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 5197: po_distributions_all POD

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'
5201: AND AIDI.po_distribution_id = POD.po_distribution_id