[Home] [Help]
112: UNION ALL
113: SELECT 'Exists'
114: FROM po_lines_gt pol, --
115: po_line_locations_gt pll, --
116: po_headers_gt potoapp --
118: AND pol.po_line_id = pll.po_line_id
119: AND pol.po_header_id = potoapp.po_header_id
120: AND potoapp.po_header_id = X_po_header_id
193: )
194: INTO X_current_amount
195: FROM po_lines_gt pol, --
196: po_line_locations_gt pll, --
197: po_headers_gt potoapp --
199: AND pol.po_line_id = pll.po_line_id
200: AND pol.po_header_id = potoapp.po_header_id
201: AND potoapp.po_header_id = X_po_header_id;