Query : Purchase Order

select
PHA.PO_HEADER_ID, PHA.SEGMENT1, PHA.CREATION_DATE, PHA.VENDOR_ID, PHA.DOCUMENT_STATUS,
PLA.PO_LINE_ID, PLA.LINE_NUM, PLA.ITEM_ID, PLA.CATEGORY_ID, PLA.ITEM_DESCRIPTION, PLA.UOM_CODE, PLA.UNIT_PRICE, PLA.QUANTITY, PLA.PURCHASE_BASIS, PLA.MATCHING_BASIS,
PDA.PO_DISTRIBUTION_ID, PDA.CODE_COMBINATION_ID, PDA.QUANTITY_ORDERED, PDA.QUANTITY_DELIVERED, PDA.QUANTITY_BILLED, PDA.REQ_DISTRIBUTION_ID


from
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_DISTRIBUTIONS_ALL PDA


where
pha.po_header_id = pla.po_header_id and
pla.po_header_id = pda.po_header_id and
pha.po_header_id = pda.po_header_id and
PLA.UOM_CODE is null
and pha.segment1 like '1%'
and PHA.DOCUMENT_STATUS = 'OPEN'

order by pha.creation_date