[Home] [Help]
View: SO_LINES_SUMMARY_V
View Text
SELECT LINE.ROWID ROW_ID
, LINE.HEADER_ID
, LINE.LINE_NUMBER
, ITEM.ITEM_NUMBER ITEM
, ITEM.ORGANIZATION_ID
, LINE.ORDERED_QUANTITY
, UOM.UNIT_OF_MEASURE
, LINE.SELLING_PRICE
, NVL(LINE.SELLING_PRICE
, 0) * NVL(LINE.ORDERED_QUANTITY
, 0) EXTENDED_PRICE
, LINE.DATE_REQUESTED_CURRENT
, LINE.PROMISE_DATE
, LINE.SCHEDULE_DATE
FROM MTL_UNITS_OF_MEASURE UOM
, MTL_ITEM_FLEXFIELDS ITEM
, SO_LINES LINE
WHERE LINE.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND LINE.UNIT_CODE = UOM.UOM_CODE
Columns
| Name |
| ROW_ID |
| HEADER_ID |
| LINE_NUMBER |
| ITEM |
| ORGANIZATION_ID |
| ORDERED_QUANTITY |
| UNIT_OF_MEASURE |
| SELLING_PRICE |
| EXTENDED_PRICE |
| DATE_REQUESTED_CURRENT |
| PROMISE_DATE |
| SCHEDULE_DATE |
APPS.SO_LINES_SUMMARY_V