PO_SCO_LINE_LOCATIONS_V

Details

  • Schema: FUSION

  • Object owner: PO

  • Object type: VIEW

Columns

Name

LINE_LOCATION_ID

PO_HEADER_ID

PO_LINE_ID

PRICING_QUANTITY

PRICING_UOM_CODE

UOM_CODE

QUANTITY

Query

SQL_Statement

SELECT

PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID LINE_LOCATION_ID,

PO_LINE_LOCATIONS_ALL.PO_HEADER_ID PO_HEADER_ID,

PO_LINE_LOCATIONS_ALL.PO_LINE_ID PO_LINE_ID,

PO_LINE_LOCATIONS_ALL.QUANTITY PRICING_QUANTITY,

PO_LINE_LOCATIONS_ALL.UOM_CODE PRICING_UOM_CODE,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_CODE UOM_CODE,

PO_LINE_LOCATIONS_ALL.SHIPPING_UOM_QUANTITY QUANTITY

FROM

PO_LINE_LOCATIONS_ALL