DBA Data[Home] [Help]

APPS.PO_CHORD_WF4 dependencies on PO_LINE_LOCATIONS_ALL

Line 521: PO_LINE_LOCATIONS_ALL POLL,

517: ))
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'

Line 545: PO_LINE_LOCATIONS_ALL POLL,

541: ))
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'

Line 594: PO_LINE_LOCATIONS_ALL POLL,

590: ))
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'

Line 617: PO_LINE_LOCATIONS_ALL POLL,

613: ))
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'