APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 1026: , po_distributions_archive_all poda

1022: , poda.line_location_id
1023: , poda.distribution_num
1024: , poda.deliver_to_person_id
1025: FROM po_line_locations_archive_all plla
1026: , po_distributions_archive_all poda
1027: WHERE plla.po_header_id = p_doc_id
1028: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1029: FROM
1030: po_line_locations_archive_all plla2

Line 1037: FROM po_distributions_archive_all poda2

1033: AND plla2.po_header_id = p_doc_id
1034: AND plla2.revision_num <= p_doc_revision )
1035: AND poda.line_location_id = plla.line_location_id
1036: AND poda.revision_num = ( SELECT MAX(poda2.revision_num)
1037: FROM po_distributions_archive_all poda2
1038: WHERE poda2.po_distribution_id
1039: = poda.po_distribution_id
1040: AND poda2.line_location_id = plla.line_location_id
1041: AND poda2.revision_num <= p_doc_revision )

Line 1793: , po_distributions_archive_all poda

1789: , poda.line_location_id
1790: , poda.distribution_num
1791: , poda.deliver_to_person_id
1792: FROM po_line_locations_archive_all plla
1793: , po_distributions_archive_all poda
1794: WHERE plla.po_release_id = p_doc_id
1795: AND plla.revision_num = ( SELECT MAX(plla2.revision_num)
1796: FROM
1797: po_line_locations_archive_all plla2

Line 1804: FROM po_distributions_archive_all poda2

1800: AND plla2.po_release_id = p_doc_id
1801: AND plla2.revision_num <= p_doc_revision )
1802: AND poda.line_location_id = plla.line_location_id
1803: AND poda.revision_num = ( SELECT MAX(poda2.revision_num)
1804: FROM po_distributions_archive_all poda2
1805: WHERE poda2.po_distribution_id
1806: = poda.po_distribution_id
1807: AND poda2.line_location_id = plla.line_location_id
1808: AND poda2.revision_num <= p_doc_revision )