AP_OFR_PO_LINES_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
LINE_LOCATION_ID PO_HEADER_ID PO_LINE_ID VENDOR_ID PO_NUMBER ITEM_DESCRIPTION VENDOR_PRODUCT_NUM UNIT_OF_MEASURE UNIT_PRICE QUANTITY_ORDERED LINE_TOTAL QUANTITY_RECEIVED VALUE_RECEIVED QUANTITY_INVOICED VALUE_INVOICED SHIP_TO_ORGANIZATION_ID

Query

SQL_Statement

SELECT pos.line_location_id, pol.po_header_id, pol.po_line_id, poh.vendor_id, poh.segment1 po_number, pol.item_description, pol.vendor_product_num, (select inv.unit_of_measure from inv_units_of_measure inv where inv.uom_code = pos.uom_code) unit_of_measure, NVL (pol.unit_price, '0') unit_price, NVL (pol.quantity, '0') quantity_ordered, NVL (decode(pol.matching_basis, 'QUANTITY', pol.unit_price * pol.quantity, pol.amount), '0') line_total, NVL (pos.quantity_received, '0') quantity_received, NVL (decode(pol.matching_basis, 'QUANTITY', pos.quantity_received * pol.unit_price, pos.amount_received), '0') value_received, NVL (pos.quantity_billed, '0') quantity_invoiced, NVL (decode(pol.matching_basis, 'QUANTITY', pos.quantity_billed * pol.unit_price, pos.amount_billed) , '0') value_invoiced, pos.ship_to_organization_id FROM fusion.po_lines_all pol, fusion.po_headers_all poh, fusion.po_line_locations_all pos, fusion.hr_all_organization_units hou WHERE poh.po_header_id = pol.po_header_id AND pol.po_line_id = pos.po_line_id AND poh.billto_bu_id = hou.organization_id