DBA Data[Home] [Help]

APPS.PO_CHORD_WF5 dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 261: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

257: nvl(X_base_min_unit,1))
258: * nvl(X_base_min_unit,1) , 0)
259: INTO x_release_total_archive
260: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
261: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
262: WHERE PODA.po_header_id = (SELECT po_header_id
263: FROM po_releases
264: WHERE po_release_id = x_po_release_id)
265: AND POLLA.po_header_id = PODA.po_header_id

Line 302: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

298: nvl(PODA.quantity_cancelled, 0)) *
299: nvl(POLLA.price_override, 0))
300: INTO x_release_total_archive
301: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
302: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
303: WHERE PODA.po_header_id = (SELECT po_header_id
304: FROM po_releases
305: WHERE po_release_id = x_po_release_id)
306: AND POLLA.po_header_id = PODA.po_header_id