DBA Data[Home] [Help]

APPS.PO_CHORD_WF2 dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 591: po_line_locations_archive_all polla

587:
588: SELECT DISTINCT 'Y'
589: INTO x_lines_control.advance_amount
590: FROM po_line_locations_all poll,
591: po_line_locations_archive_all polla
592: WHERE poll.po_header_id = x_po_header_id
593: AND poll.payment_type = 'ADVANCE'
594: AND poll.line_location_id = polla.line_location_id (+)
595: AND polla.latest_external_flag (+) = 'Y'