DBA Data[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 956: , po_distributions_archive_all poda

952: , poda.line_location_id
953: , poda.distribution_num
954: , poda.deliver_to_person_id
955: FROM po_line_locations_archive_all plla
956: , po_distributions_archive_all poda
957: WHERE plla.po_header_id = p_doc_id
958: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
959: FROM
960: po_line_locations_archive_all plla2

Line 967: FROM po_distributions_archive_all poda2

963: AND plla2.po_header_id = p_doc_id
964: AND plla2.revision_num <= p_doc_revision )
965: AND poda.line_location_id = plla.line_location_id
966: AND poda.revision_num = ( SELECT MAX(poda2.revision_num)
967: FROM po_distributions_archive_all poda2
968: WHERE poda2.po_distribution_id
969: = poda.po_distribution_id
970: AND poda2.line_location_id = plla.line_location_id
971: AND poda2.revision_num <= p_doc_revision )

Line 1721: , po_distributions_archive_all poda

1717: , poda.line_location_id
1718: , poda.distribution_num
1719: , poda.deliver_to_person_id
1720: FROM po_line_locations_archive_all plla
1721: , po_distributions_archive_all poda
1722: WHERE plla.po_release_id = p_doc_id
1723: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1724: FROM
1725: po_line_locations_archive_all plla2

Line 1732: FROM po_distributions_archive_all poda2

1728: AND plla2.po_release_id = p_doc_id
1729: AND plla2.revision_num <= p_doc_revision )
1730: AND poda.line_location_id = plla.line_location_id
1731: AND poda.revision_num = ( SELECT MAX(poda2.revision_num)
1732: FROM po_distributions_archive_all poda2
1733: WHERE poda2.po_distribution_id
1734: = poda.po_distribution_id
1735: AND poda2.line_location_id = plla.line_location_id
1736: AND poda2.revision_num <= p_doc_revision )