SELECT jeh.*
FROM gl_import_references gli
, xla_ae_lines xll
, xla_ae_headers xlh
, xla_distribution_links xld
, gl_je_lines gl
, po_lines_all pol
, po_line_locations_all pll
, po_distributions_all pod
WHERE 1=1
AND pod.line_location_id = pll.line_location_id
AND pll.po_line_id = pol.po_line_id
AND pol.po_header_id = poh.po_header_id
and gli.gl_sl_link_table = xll.gl_sl_link_table
AND gli.gl_sl_link_id = xll.gl_sl_link_id
AND xll.ae_header_id = xlh.ae_header_id
AND xld.ae_header_id = xlh.ae_header_id
AND jel.je_header_id = gli.je_header_id
AND jel.je_line_num = gli.je_line_num
AND xld.source_distribution_id_num_1 = pod.po_distribution_id
AND xld.source_distribution_type = 'PO_DISTRIBUTIONS_ALL'
AND xll.gl_sl_link_table = 'XLAJEL'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment