Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT -- REGULAR ATTRIBUTES DETAIL.QUANTITY
, DETAIL.UNIT_CODE
, '_LA:REQUIRED_FOR_REVENUE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, DETAIL.LOAD_SEQ_NUMBER
, '_LA:SCHEDULE_STATUS_CODE:SO_LOOKUPS:RESERVATION_RESULT_TYPE:MEANING'
, DETAIL.SCHEDULE_DATE
, DETAIL.LATEST_ACCEPTABLE_DATE
, '_LA:INCLUDED_ITEM_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:SHIPPABLE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:TRANSACTABLE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:RESERVABALE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, DETAIL.LOT_NUMBER
, DETAIL.REVISION
, '_LA:SHIPMENT_PRIORITY_CODE:SO_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:SHIP_METHOD_CODE:SO_LOOKUPS:SHIPPING_METHOD:MEANING' --
, CARRIER_NAME
, '_LA:DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, '_DF:OE:SO_LINE_DETAILS:DETAIL' -- ID
, DETAIL.LINE_DETAIL_ID
, DETAIL.INVENTORY_ITEM_ID
, DETAIL.LINE_ID
, DETAIL.SUBINVENTORY
, DETAIL.DELIVERY_ID
, DETAIL.DEPARTURE_ID
, DETAIL.MASTER_CONTAINER_ITEM_ID
, DETAIL.DETAIL_CONTAINER_ITEM_ID
, DETAIL.WAREHOUSE_ID
, DETAIL.CUSTOMER_ITEM_ID
, LINE.SHIP_TO_SITE_USE_ID
, LINE.SHIP_TO_CONTACT_ID
, LINE.TERMS_ID -- WHO
, DETAIL.LAST_UPDATE_DATE
, DETAIL.LAST_UPDATED_BY
, DETAIL.CREATION_DATE
, DETAIL.CREATED_BY
FROM SO_LINE_DETAILS DETAIL
, SO_LINES_ALL LINE
WHERE DETAIL.LINE_ID = LINE.LINE_ID WITH READ ONLY