View: OEFV_SHIPMENT_LINES

View Text

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'
, '_DF:OE:SO_LINE_DETAILS:SO_LINE_DETAILS' -- RESOLVED FK RESOLUTIONS
, '_KF:INV:MSTK:INV_ITEM' /* INV_ITEM_NUMBER */
, LINE.LINE_NUMBER
, '_LA:DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, DELIVERY.NAME
, DEPARTURE.NAME
, '_KF:INV:MSTK:MASTER_ITEM'
, '_KF:INV:MSTK:DETAIL_ITEM'
, ORG.ORGANIZATION_NAME -- NEED ORG.ORGANIZATION_CODE ??
, CUST_ITEM.CUSTOMER_ITEM_NUMBER
, SITE_USE.LOCATION
, CONTACT.FIRST_NAME||' '||CONTACT.LAST_NAME
, TERM.NAME -- ID
, DETAIL.LINE_DETAIL_ID
, DETAIL.INVENTORY_ITEM_ID
, DETAIL.LINE_ID
, DETAIL.DEMAND_CLASS_CODE
, SUBINV.SECONDARY_INVENTORY_NAME
, 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 --
, MTL_ITEM_REVISIONS REVISION
, MTL_LOT_NUMBERS LOT
, MTL_SECONDARY_INVENTORIES SUBINV
, MTL_SYSTEM_ITEMS INV_ITEM
, MTL_SYSTEM_ITEMS MASTER_ITEM
, MTL_SYSTEM_ITEMS DETAIL_ITEM
, MTL_CUSTOMER_ITEMS CUST_ITEM
, ORG_ORGANIZATION_DEFINITIONS ORG
, WSH_DELIVERIES DELIVERY
, WSH_DEPARTURES DEPARTURE
, RA_CONTACTS CONTACT
, RA_TERMS TERM
, RA_SITE_USES_ALL SITE_USE
WHERE DETAIL.LINE_ID = LINE.LINE_ID AND LINE.SHIP_TO_SITE_USE_ID = SITE_USE.SITE_USE_ID(+) AND DETAIL.INVENTORY_ITEM_ID = INV_ITEM.INVENTORY_ITEM_ID AND NVL(DETAIL.WAREHOUSE_ID
, FND_PROFILE.VALUE_SPECIFIC('SO_ORGANIZATION_ID')) = INV_ITEM.ORGANIZATION_ID -- AND DETAIL.REVISION = REVISION.REVISION(+) AND DETAIL.SUBINVENTORY = SUBINV.SECONDARY_INVENTORY_NAME(+) AND DETAIL.WAREHOUSE_ID = SUBINV.ORGANIZATION_ID(+) AND DETAIL.LOT_NUMBER = LOT.LOT_NUMBER(+) AND DETAIL.DELIVERY_ID = DELIVERY.DELIVERY_ID(+) AND DETAIL.DEPARTURE_ID = DEPARTURE.DEPARTURE_ID(+) AND DETAIL.CUSTOMER_ITEM_ID = CUST_ITEM.CUSTOMER_ITEM_ID(+) AND DETAIL.MASTER_CONTAINER_ITEM_ID = MASTER_ITEM.INVENTORY_ITEM_ID(+) AND DETAIL.WAREHOUSE_ID = MASTER_ITEM.ORGANIZATION_ID(+) AND DETAIL.DETAIL_CONTAINER_ITEM_ID = DETAIL_ITEM.INVENTORY_ITEM_ID(+) AND DETAIL.WAREHOUSE_ID = DETAIL_ITEM.ORGANIZATION_ID(+) AND DETAIL.WAREHOUSE_ID = ORG.ORGANIZATION_ID(+) AND LINE.SHIP_TO_CONTACT_ID = CONTACT.CONTACT_ID(+) AND LINE.TERMS_ID = TERM.TERM_ID(+) WITH READ ONLY

Columns