DBA Data[Home] [Help]

APPS.PO_CHORD_WF5 dependencies on PO_DISTRIBUTIONS_ALL

Line 237: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL

233: nvl(X_min_unit,1))) * nvl(X_min_unit,1) /
234: nvl(X_base_min_unit,1))
235: * nvl(X_base_min_unit,1) , 0)
236: INTO x_release_total
237: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL
238: WHERE POLL.po_release_id = x_po_release_id
239: AND POLL.shipment_type in ('SCHEDULED','BLANKET')
240: AND POLL.line_location_id = POD.line_location_id;
241:

Line 285: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL

281: (nvl(POD.quantity_ordered, 0) -
282: nvl(POD.quantity_cancelled, 0)) *
283: nvl(POLL.price_override, 0))
284: INTO x_release_total
285: FROM PO_DISTRIBUTIONS_ALL POD, PO_LINE_LOCATIONS_ALL POLL
286: WHERE POLL.po_release_id = x_po_release_id
287: AND POLL.shipment_type in ('SCHEDULED','BLANKET')
288: AND POLL.line_location_id = POD.line_location_id;
289: EXCEPTION