APPS.PO_CHORD_WF1 dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 764: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

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'
768: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')

Line 815: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

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'
819: AND POLLA.shipment_type in ('STANDARD','PLANNED','BLANKET')