select pha.segment1 po_number,
pv.vendor_name,
pv.segment1 supplier_num,
pha.currency_code,
pla.line_num,
plla.shipment_num,
pla.item_description,
pla.unit_price,
plla.quantity,
plla.quantity_received,
plla.quantity_billed,
rt.transaction_type,
rt.transaction_date
from gl.gl_je_headers h,
gl.gl_je_lines l,
gl.gl_code_combinations gcc,
gl.gl_import_references gir,
apps.xla_ae_lines xal,
apps.xla_distribution_links xdl,
po.rcv_receiving_sub_ledger rrsl,
po.rcv_transactions rt,
po.po_headers_all pha,
po.po_lines_all pla,
po.po_line_locations_all plla,
apps.po_vendors pv
where h.je_header_id = l.je_header_id
and l.code_combination_id = gcc.code_combination_id
and gcc.segment1 = '801'
--and gcc.segment2 in ('21200101', '21200201')
and gcc.segment2 = '21200201'
and l.je_header_id = gir.je_header_id
and l.je_line_num = gir.je_line_num
and gir.gl_sl_link_id = xal.gl_sl_link_id
and xal.ae_header_id = xdl.ae_header_id
and xal.ae_line_num = xdl.ae_line_num
and xdl.source_distribution_id_num_1 = rrsl.rcv_sub_ledger_id
and rrsl.rcv_transaction_id = rt.transaction_id
and rt.po_header_id = pha.po_header_id
and rt.po_header_id = pla.po_header_id
and rt.po_line_id = pla.po_line_id
and pla.po_header_id = plla.po_header_id
and pla.po_line_id = plla.po_line_id
and pha.vendor_id = pv.vendor_id
and h.ledger_id = 2041 --UTSC
and h.je_source = 'Cost Management'
and h.je_category = 'Receiving'
and h.status = 'P'
and h.period_name in ('MAR-08', 'FEB-08')
