CSE_PO_DETAILS_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
PO_HEADER_ID PO_NUMBER PO_LINE_ID PO_LINE_NUMBER PO_SHIPMENT_ID PO_SHIPMENT_NUMBER

Query

SQL_Statement
select ph.po_header_id po_header_id, ph.segment1 po_number , pl.po_line_id po_line_id, pl.line_num po_line_number, pll.line_location_id po_shipment_id, pll.shipment_num po_shipment_number from po_headers_all ph, po_lines_all pl, po_line_locations_all pll where pl.po_header_id = ph.po_header_id and pll.po_line_id = pl.po_line_id