APPS.PO_CHORD_WF4 dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 522: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

518: INTO x_dist_control.amount_ordered_change
519: FROM PO_DISTRIBUTIONS_ALL POD,
520: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
521: PO_LINE_LOCATIONS_ALL POLL,
522: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
523: WHERE POD.po_header_id = x_po_header_id
524: AND POD.po_distribution_id = PODA.po_distribution_id (+)
525: AND PODA.latest_external_flag (+) = 'Y'
526: AND POD.distribution_type <> 'AGREEMENT'

Line 546: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

542: INTO x_dist_control.amount_ordered_change
543: FROM PO_DISTRIBUTIONS_ALL POD,
544: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
545: PO_LINE_LOCATIONS_ALL POLL,
546: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
547: WHERE POD.po_header_id = x_po_header_id
548: AND POD.po_distribution_id = PODA.po_distribution_id (+)
549: AND PODA.latest_external_flag (+) = 'Y'
550: AND POD.distribution_type <> 'AGREEMENT'

Line 595: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

591: INTO x_dist_control.amount_ordered_change
592: FROM PO_DISTRIBUTIONS_ALL POD,
593: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
594: PO_LINE_LOCATIONS_ALL POLL,
595: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
596: WHERE POD.po_release_id = x_po_release_id
597: AND POD.po_distribution_id = PODA.po_distribution_id (+)
598: AND PODA.latest_external_flag (+) = 'Y'
599: AND POD.line_location_id = POLL.line_location_id -- Bug 5071741

Line 618: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

614: INTO x_dist_control.amount_ordered_change
615: FROM PO_DISTRIBUTIONS_ALL POD,
616: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA,
617: PO_LINE_LOCATIONS_ALL POLL,
618: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
619: WHERE POD.po_release_id = x_po_release_id
620: AND POD.po_distribution_id = PODA.po_distribution_id (+)
621: AND PODA.latest_external_flag (+) = 'Y'
622: AND POD.line_location_id = POLL.line_location_id -- Bug 5071741