DBA Data[Home] [Help]

APPS.PO_CHORD_WF5 dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 260: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,

256: nvl(X_min_unit,1))) * nvl(X_min_unit,1) /
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)

Line 301: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,

297: (nvl(PODA.quantity_ordered, 0) -
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)