[Home] [Help]
APPS.PO_CHORD_WF2 dependencies on PO_LINE_LOCATIONS_ALL
Line 590: FROM po_line_locations_all poll,
586: -- SQL Join: line_location_id
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 (+)