DBA Data[Home] [Help]

APPS.PO_CHORD_WF1 dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 763: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,

759: * nvl(X_min_unit,1)/ nvl(X_base_min_unit,1)
760: )
761: * nvl(X_base_min_unit,1)) , 0)
762: INTO x_po_total_archive
763: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
764: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
765: WHERE PODA.po_header_id = x_po_header_id
766: AND POLLA.latest_external_flag (+) = 'Y'
767: AND PODA.latest_external_flag (+) = 'Y'

Line 814: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,

810: (nvl(PODA.quantity_ordered, 0) -
811: nvl(PODA.quantity_cancelled, 0)) *
812: nvl(POLLA.price_override, 0)))
813: INTO x_po_total_archive
814: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
815: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
816: WHERE PODA.po_header_id = x_po_header_id
817: AND POLLA.latest_external_flag (+) = 'Y'
818: AND PODA.latest_external_flag (+) = 'Y'