DBA Data[Home] [Help]

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 5001: FROM po_distributions_archive_all poad

4997: quantity_ordered )=
4998: (SELECT
4999: amount_ordered,
5000: quantity_ordered
5001: FROM po_distributions_archive_all poad
5002: WHERE poad.po_distribution_id =pod.po_distribution_id
5003: AND poad.latest_external_flag ='Y')
5004: WHERE pod.line_location_id IN
5005: (SELECT poll.line_location_id

Line 5376: FROM po_distributions_archive_all

5372: AND (p_po_enc_flag = 'Y' AND pod.encumbered_flag = 'N')
5373: -- <13503748: Edit without unreserve ER END>
5374: AND (p_po_enc_flag ='Y'
5375: OR NOT EXISTS (SELECT 'exists archive'
5376: FROM po_distributions_archive_all
5377: WHERE po_distribution_id =pod.po_distribution_id)
5378: )
5379:
5380: );

Line 5496: FROM po_distributions_archive_all

5492: AND poll.line_location_id = gt.index_num1 -- lowestentityid i.e.
5493: AND poll.po_line_id = pol.po_line_id
5494: AND gt.char1 <> po_document_cancel_pvt.c_doc_type_PA
5495: AND ((NOT EXISTS (SELECT 'exists archive'
5496: FROM po_distributions_archive_all
5497: WHERE po_distribution_id =pod.po_distribution_id)
5498: AND Nvl(poll.approved_flag,'N')<>'Y')
5499: OR EXISTS (SELECT 'change exists'
5500: FROM po_line_locations_archive_all poall