VIEW: APPS.WSHFV_DELIVERY_DETAILS

Source

View Text - Preformatted

SELECT WDD.DELIVERY_DETAIL_ID , WDD.SOURCE_CODE, WDD.SOURCE_HEADER_ID, WDD.SOURCE_LINE_ID, WDD.SOURCE_HEADER_TYPE_ID, WDD.SOURCE_HEADER_TYPE_NAME SRC_HEADER_TYPE_NAME, WDD.CUST_PO_NUMBER, WDD.CUSTOMER_ID , PARTY.PARTY_NAME CUSTOMER_NAME , WDD.SOLD_TO_CONTACT_ID, CONTACT1.PERSON_FIRST_NAME||' '||CONTACT1.PERSON_LAST_NAME "SOLD_TO_CONTACT_NAME", WDD.ITEM_DESCRIPTION, WDD.SHIP_SET_ID , OS1.SET_NAME SHIP_SET_NAME, WDD.ARRIVAL_SET_ID, OS2.SET_NAME ARRIVAL_SET_NAME, WDD.TOP_MODEL_LINE_ID, WDD.ATO_LINE_ID, WDD.HOLD_CODE, '_LA:WDD.SHIP_MODEL_COMPLETE_FLAG:FND_LOOKUPS:YES_NO:MEANING', WDD.HAZARD_CLASS_ID, WDD.COUNTRY_OF_ORIGIN, WDD.CLASSIFICATION, LOC1.SOURCE_LOCATION_ID, LOC1.UI_LOCATION_CODE SHIP_FROM_LOCATION, WDD.ORGANIZATION_ID, LOC2.SOURCE_LOCATION_ID, LOC2.UI_LOCATION_CODE SHIP_TO_LOCATION, WDD.SHIP_TO_CONTACT_ID, CONTACT2.PERSON_FIRST_NAME||' '||CONTACT2.PERSON_LAST_NAME "SHIP_TO_CONTACT_NAME", LOC3.SOURCE_LOCATION_ID, LOC3.UI_LOCATION_CODE DELIVER_TO_LOCATION, WDD.DELIVER_TO_CONTACT_ID, CONTACT3.PERSON_FIRST_NAME||' '||CONTACT3.PERSON_LAST_NAME "DELIVER_TO_CONTACT_NAME", LOC4.SOURCE_LOCATION_ID, LOC4.UI_LOCATION_CODE INTMED_SHIP_TO_LOCATION, WDD.INTMED_SHIP_TO_CONTACT_ID, CONTACT4.PERSON_FIRST_NAME||' '||CONTACT4.PERSON_LAST_NAME "INTMED_SHIP_TO_CONTACT_NAME", WDD.SHIP_TOLERANCE_ABOVE, WDD.SHIP_TOLERANCE_BELOW, WDD.SRC_REQUESTED_QUANTITY, WDD.SRC_REQUESTED_QUANTITY_UOM, WDD.CANCELLED_QUANTITY, WDD.REQUESTED_QUANTITY, WDD.REQUESTED_QUANTITY_UOM, WDD.SHIPPED_QUANTITY, WDD.DELIVERED_QUANTITY, WDD.QUALITY_CONTROL_QUANTITY, WDD.CYCLE_COUNT_QUANTITY , WDD.MOVE_ORDER_LINE_ID ,MTRL.LINE_NUMBER MOVE_ORDER_LINE_NUMBER ,WDD.SUBINVENTORY ,SUBINV1.DESCRIPTION SUBINV_DESCRIPTION ,WDD.REVISION ,WDD.LOT_NUMBER ,WDD.RELEASED_STATUS ,'_LA:WDD.CUSTOMER_REQUESTED_LOT_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WDD.SERIAL_NUMBER ,WDD.LOCATOR_ID ,'_KF:INV:MTLL:MIL' ,WDD.DATE_REQUESTED ,WDD.DATE_SCHEDULED ,WDD.LOAD_SEQ_NUMBER ,'_LA:WDD.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING' ,WDD.CARRIER_ID ,'_LA:WDD.FREIGHT_TERMS_CODE:FND_LOOKUP_VALUES_VL:FREIGHT_TERMS:MEANING' ,'_LA:WDD.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING' ,'_LA:WDD.FOB_CODE:AR_LOOKUPS:FOB:MEANING' ,'_LA:WDD.DEP_PLAN_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WDD.CUSTOMER_PROD_SEQ ,WDD.CUSTOMER_DOCK_CODE ,WDD.NET_WEIGHT ,WDD.WEIGHT_UOM_CODE ,WDD.VOLUME ,WDD.VOLUME_UOM_CODE ,WDD.SHIPPING_INSTRUCTIONS ,WDD.PACKING_INSTRUCTIONS ,WDD.PROJECT_ID ,PROJ.NAME PROJECT_NAME ,WDD.TASK_ID ,PROJTASK.TASK_NUMBER ,WDD.ORG_ID ,WDD.OE_INTERFACED_FLAG ,WDD.MVT_STAT_STATUS ,WDD.TRACKING_NUMBER ,WDD.TRANSACTION_TEMP_ID ,WDD.CREATION_DATE ,WDD.CREATED_BY ,WDD.LAST_UPDATE_DATE ,WDD.LAST_UPDATED_BY ,WDD.LAST_UPDATE_LOGIN ,WDD.PROGRAM_APPLICATION_ID ,WDD.PROGRAM_ID ,WDD.PROGRAM_UPDATE_DATE ,WDD.REQUEST_ID ,WDD.MOVEMENT_ID ,MMS.MOVEMENT_TYPE ,MMS.MOVEMENT_STATUS ,WDD.SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DEL_DETAIL_ID ,WDD.INV_INTERFACED_FLAG ,WDD.SEAL_CODE ,WDD.MINIMUM_FILL_PERCENT ,WDD.MAXIMUM_VOLUME ,WDD.MAXIMUM_LOAD_WEIGHT ,WDD.MASTER_SERIAL_NUMBER ,WDD.GROSS_WEIGHT ,WDD.FILL_PERCENT ,WDD.CONTAINER_NAME ,WDD.CONTAINER_TYPE_CODE ,'_LA:WDD.CONTAINER_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WDD.PREFERRED_GRADE ,WDD.SRC_REQUESTED_QUANTITY2 ,WDD.SRC_REQUESTED_QUANTITY_UOM2 ,WDD.REQUESTED_QUANTITY2 ,WDD.SHIPPED_QUANTITY2 ,WDD.DELIVERED_QUANTITY2 ,WDD.CANCELLED_QUANTITY2 ,WDD.QUALITY_CONTROL_QUANTITY2 ,WDD.CYCLE_COUNT_QUANTITY2 ,WDD.REQUESTED_QUANTITY_UOM2 ,WDD.SUBLOT_NUMBER ,WDD.UNIT_PRICE ,WDD.CURRENCY_CODE ,WDD.UNIT_NUMBER ,WDD.FREIGHT_CLASS_CAT_ID ,WDD.COMMODITY_CODE_CAT_ID ,WDD.SOURCE_HEADER_NUMBER ,WDD.SOURCE_LINE_NUMBER ,WDD.SHIP_TO_SITE_USE_ID ,SITE_USE1.LOCATION SHIP_TO_LOCATION ,LOC2.ADDRESS1 SHIP_TO_SITE_USE_ADDRESS1, LOC2.ADDRESS2 SHIP_TO_SITE_USE_ADDRESS2, LOC2.ADDRESS3 SHIP_TO_SITE_USE_ADDRESS3, LOC2.ADDRESS4 SHIP_TO_SITE_USE_ADDRESS4, LOC2.CITY SHIP_TO_SITE_USE_CITY , LOC2.STATE SHIP_TO_SITE_USE_STATE , LOC2.POSTAL_CODE SHIP_TO_SITE_USE_POSTAL_CODE , LOC2.PROVINCE SHIP_TO_SITE_USE_PROVINCE, LOC2.COUNTY SHIP_TO_SITE_USE_COUNTY , LOC2.COUNTRY SHIP_TO_SITE_USE_COUNTRY ,WDD.DELIVER_TO_SITE_USE_ID ,SITE_USE2.LOCATION DEL_TO_SITE_USE_LOCATION ,LOC3.ADDRESS1 DEL_TO_SITE_USE_ADDRESS1, LOC3.ADDRESS2 DEL_TO_SITE_USE_ADDRESS2, LOC3.ADDRESS3 DEL_TO_SITE_USE_ADDRESS3, LOC3.ADDRESS4 DEL_TO_SITE_USE_ADDRESS4, LOC3.CITY DEL_TO_SITE_USE_CITY , LOC3.STATE DEL_TO_SITE_USE_STATE , LOC3.POSTAL_CODE DEL_TO_SITE_USE_POSTAL_CODE , LOC3.PROVINCE DEL_TO_SITE_USE_PROVINCE, LOC3.COUNTY DEL_TO_SITE_USE_COUNTY , LOC3.COUNTRY DEL_TO_SITE_USE_COUNTRY ,WDD.LPN_ID ,WLPN.LICENSE_PLATE_NUMBER ,'_LA:WDD.INSPECTION_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,WDD.ORIGINAL_SUBINVENTORY ,SUBINV2.DESCRIPTION ORIGINAL_SUBINV_DESCRIPTION ,'_LA:WDD.PICKABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING' ,'_DF:WSH:WSH_DELIVERY_DETAILS:WDD' ,'_DF:WSH:WSH_VEA_DELIVERY_DETAILS:WDD' ,WDD.INVENTORY_ITEM_ID , WDD.MASTER_CONTAINER_ITEM_ID ,WDD.DETAIL_CONTAINER_ITEM_ID , '_KF:INV:MSTK:MSI' , '_KF:INV:MSTK:MASTER_ITEM' , '_KF:INV:MSTK:DETAIL_ITEM' FROM WSH_DELIVERY_DETAILS WDD, MTL_SYSTEM_ITEMS MSI, MTL_CUSTOMER_ITEMS CUST_ITEM, MTL_SYSTEM_ITEMS MASTER_ITEM, MTL_SYSTEM_ITEMS DETAIL_ITEM, OE_SETS OS1, OE_SETS OS2, WSH_LOCATIONS LOC1, WSH_LOCATIONS LOC2, WSH_LOCATIONS LOC3, WSH_LOCATIONS LOC4, MTL_TXN_REQUEST_LINES MTRL, MTL_SECONDARY_INVENTORIES SUBINV1, MTL_SECONDARY_INVENTORIES SUBINV2, HZ_PARTIES CONTACT1 , HZ_PARTIES CONTACT2 , HZ_PARTIES CONTACT3 ,HZ_PARTIES CONTACT4 , HZ_CUST_ACCOUNTS CUSTACCT, HZ_PARTIES PARTY, HZ_CUST_SITE_USES_ALL SITE_USE1 , HZ_CUST_SITE_USES_ALL SITE_USE2 , PA_PROJECTS_ALL PROJ , PA_TASKS PROJTASK, MTL_ITEM_LOCATIONS MIL, MTL_MOVEMENT_STATISTICS MMS, WMS_LICENSE_PLATE_NUMBERS WLPN WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) AND WDD.CUSTOMER_ITEM_ID = CUST_ITEM.CUSTOMER_ITEM_ID(+) AND WDD.MASTER_CONTAINER_ITEM_ID = MASTER_ITEM.INVENTORY_ITEM_ID(+) AND WDD.ORGANIZATION_ID = MASTER_ITEM.ORGANIZATION_ID(+) AND WDD.DETAIL_CONTAINER_ITEM_ID = DETAIL_ITEM.INVENTORY_ITEM_ID(+) AND WDD.ORGANIZATION_ID = DETAIL_ITEM.ORGANIZATION_ID(+) AND '_SEC:WDD.ORGANIZATION_ID' is not null AND WDD.SHIP_SET_ID=OS1.SET_ID(+) AND WDD.ARRIVAL_SET_ID=OS2.SET_ID(+) AND WDD.SHIP_FROM_LOCATION_ID =LOC1.WSH_LOCATION_ID(+) AND WDD.SHIP_TO_LOCATION_ID =LOC2.WSH_LOCATION_ID(+) AND WDD.DELIVER_TO_LOCATION_ID =LOC3.WSH_LOCATION_ID(+) AND WDD.INTMED_SHIP_TO_LOCATION_ID =LOC4.WSH_LOCATION_ID(+) AND WDD.MOVE_ORDER_LINE_ID=MTRL.LINE_ID(+) AND WDD.SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+) AND WDD.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+) AND WDD.ORIGINAL_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+) AND WDD.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+) AND WDD.SOLD_TO_CONTACT_ID = CONTACT1.PARTY_ID(+) AND WDD.SHIP_TO_CONTACT_ID = CONTACT2.PARTY_ID(+) AND WDD.DELIVER_TO_CONTACT_ID = CONTACT3.PARTY_ID(+) AND WDD.INTMED_SHIP_TO_CONTACT_ID = CONTACT4.PARTY_ID(+) AND WDD.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+) AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+) AND WDD.SHIP_TO_SITE_USE_ID = SITE_USE1.SITE_USE_ID(+) AND WDD.DELIVER_TO_SITE_USE_ID = SITE_USE2.SITE_USE_ID(+) AND WDD.PROJECT_ID = PROJ.PROJECT_ID(+) AND WDD.TASK_ID = PROJTASK.TASK_ID(+) AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+) AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+) AND WDD.MOVEMENT_ID=MMS.MOVEMENT_ID(+) AND WDD.ORGANIZATION_ID=MMS.ORGANIZATION_ID(+) AND WDD.LPN_ID=WLPN.LPN_ID(+) AND NVL(WDD.LINE_DIRECTION, 'O') IN ('O', 'IO') with read only

View Text - HTML Formatted

SELECT WDD.DELIVERY_DETAIL_ID
, WDD.SOURCE_CODE
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.SOURCE_HEADER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME SRC_HEADER_TYPE_NAME
, WDD.CUST_PO_NUMBER
, WDD.CUSTOMER_ID
, PARTY.PARTY_NAME CUSTOMER_NAME
, WDD.SOLD_TO_CONTACT_ID
, CONTACT1.PERSON_FIRST_NAME||' '||CONTACT1.PERSON_LAST_NAME "SOLD_TO_CONTACT_NAME"
, WDD.ITEM_DESCRIPTION
, WDD.SHIP_SET_ID
, OS1.SET_NAME SHIP_SET_NAME
, WDD.ARRIVAL_SET_ID
, OS2.SET_NAME ARRIVAL_SET_NAME
, WDD.TOP_MODEL_LINE_ID
, WDD.ATO_LINE_ID
, WDD.HOLD_CODE
, '_LA:WDD.SHIP_MODEL_COMPLETE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.HAZARD_CLASS_ID
, WDD.COUNTRY_OF_ORIGIN
, WDD.CLASSIFICATION
, LOC1.SOURCE_LOCATION_ID
, LOC1.UI_LOCATION_CODE SHIP_FROM_LOCATION
, WDD.ORGANIZATION_ID
, LOC2.SOURCE_LOCATION_ID
, LOC2.UI_LOCATION_CODE SHIP_TO_LOCATION
, WDD.SHIP_TO_CONTACT_ID
, CONTACT2.PERSON_FIRST_NAME||' '||CONTACT2.PERSON_LAST_NAME "SHIP_TO_CONTACT_NAME"
, LOC3.SOURCE_LOCATION_ID
, LOC3.UI_LOCATION_CODE DELIVER_TO_LOCATION
, WDD.DELIVER_TO_CONTACT_ID
, CONTACT3.PERSON_FIRST_NAME||' '||CONTACT3.PERSON_LAST_NAME "DELIVER_TO_CONTACT_NAME"
, LOC4.SOURCE_LOCATION_ID
, LOC4.UI_LOCATION_CODE INTMED_SHIP_TO_LOCATION
, WDD.INTMED_SHIP_TO_CONTACT_ID
, CONTACT4.PERSON_FIRST_NAME||' '||CONTACT4.PERSON_LAST_NAME "INTMED_SHIP_TO_CONTACT_NAME"
, WDD.SHIP_TOLERANCE_ABOVE
, WDD.SHIP_TOLERANCE_BELOW
, WDD.SRC_REQUESTED_QUANTITY
, WDD.SRC_REQUESTED_QUANTITY_UOM
, WDD.CANCELLED_QUANTITY
, WDD.REQUESTED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM
, WDD.SHIPPED_QUANTITY
, WDD.DELIVERED_QUANTITY
, WDD.QUALITY_CONTROL_QUANTITY
, WDD.CYCLE_COUNT_QUANTITY
, WDD.MOVE_ORDER_LINE_ID
, MTRL.LINE_NUMBER MOVE_ORDER_LINE_NUMBER
, WDD.SUBINVENTORY
, SUBINV1.DESCRIPTION SUBINV_DESCRIPTION
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.RELEASED_STATUS
, '_LA:WDD.CUSTOMER_REQUESTED_LOT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.SERIAL_NUMBER
, WDD.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, WDD.DATE_REQUESTED
, WDD.DATE_SCHEDULED
, WDD.LOAD_SEQ_NUMBER
, '_LA:WDD.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WDD.CARRIER_ID
, '_LA:WDD.FREIGHT_TERMS_CODE:FND_LOOKUP_VALUES_VL:FREIGHT_TERMS:MEANING'
, '_LA:WDD.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING'
, '_LA:WDD.FOB_CODE:AR_LOOKUPS:FOB:MEANING'
, '_LA:WDD.DEP_PLAN_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.CUSTOMER_PROD_SEQ
, WDD.CUSTOMER_DOCK_CODE
, WDD.NET_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, WDD.SHIPPING_INSTRUCTIONS
, WDD.PACKING_INSTRUCTIONS
, WDD.PROJECT_ID
, PROJ.NAME PROJECT_NAME
, WDD.TASK_ID
, PROJTASK.TASK_NUMBER
, WDD.ORG_ID
, WDD.OE_INTERFACED_FLAG
, WDD.MVT_STAT_STATUS
, WDD.TRACKING_NUMBER
, WDD.TRANSACTION_TEMP_ID
, WDD.CREATION_DATE
, WDD.CREATED_BY
, WDD.LAST_UPDATE_DATE
, WDD.LAST_UPDATED_BY
, WDD.LAST_UPDATE_LOGIN
, WDD.PROGRAM_APPLICATION_ID
, WDD.PROGRAM_ID
, WDD.PROGRAM_UPDATE_DATE
, WDD.REQUEST_ID
, WDD.MOVEMENT_ID
, MMS.MOVEMENT_TYPE
, MMS.MOVEMENT_STATUS
, WDD.SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DEL_DETAIL_ID
, WDD.INV_INTERFACED_FLAG
, WDD.SEAL_CODE
, WDD.MINIMUM_FILL_PERCENT
, WDD.MAXIMUM_VOLUME
, WDD.MAXIMUM_LOAD_WEIGHT
, WDD.MASTER_SERIAL_NUMBER
, WDD.GROSS_WEIGHT
, WDD.FILL_PERCENT
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, '_LA:WDD.CONTAINER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.PREFERRED_GRADE
, WDD.SRC_REQUESTED_QUANTITY2
, WDD.SRC_REQUESTED_QUANTITY_UOM2
, WDD.REQUESTED_QUANTITY2
, WDD.SHIPPED_QUANTITY2
, WDD.DELIVERED_QUANTITY2
, WDD.CANCELLED_QUANTITY2
, WDD.QUALITY_CONTROL_QUANTITY2
, WDD.CYCLE_COUNT_QUANTITY2
, WDD.REQUESTED_QUANTITY_UOM2
, WDD.SUBLOT_NUMBER
, WDD.UNIT_PRICE
, WDD.CURRENCY_CODE
, WDD.UNIT_NUMBER
, WDD.FREIGHT_CLASS_CAT_ID
, WDD.COMMODITY_CODE_CAT_ID
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_LINE_NUMBER
, WDD.SHIP_TO_SITE_USE_ID
, SITE_USE1.LOCATION SHIP_TO_LOCATION
, LOC2.ADDRESS1 SHIP_TO_SITE_USE_ADDRESS1
, LOC2.ADDRESS2 SHIP_TO_SITE_USE_ADDRESS2
, LOC2.ADDRESS3 SHIP_TO_SITE_USE_ADDRESS3
, LOC2.ADDRESS4 SHIP_TO_SITE_USE_ADDRESS4
, LOC2.CITY SHIP_TO_SITE_USE_CITY
, LOC2.STATE SHIP_TO_SITE_USE_STATE
, LOC2.POSTAL_CODE SHIP_TO_SITE_USE_POSTAL_CODE
, LOC2.PROVINCE SHIP_TO_SITE_USE_PROVINCE
, LOC2.COUNTY SHIP_TO_SITE_USE_COUNTY
, LOC2.COUNTRY SHIP_TO_SITE_USE_COUNTRY
, WDD.DELIVER_TO_SITE_USE_ID
, SITE_USE2.LOCATION DEL_TO_SITE_USE_LOCATION
, LOC3.ADDRESS1 DEL_TO_SITE_USE_ADDRESS1
, LOC3.ADDRESS2 DEL_TO_SITE_USE_ADDRESS2
, LOC3.ADDRESS3 DEL_TO_SITE_USE_ADDRESS3
, LOC3.ADDRESS4 DEL_TO_SITE_USE_ADDRESS4
, LOC3.CITY DEL_TO_SITE_USE_CITY
, LOC3.STATE DEL_TO_SITE_USE_STATE
, LOC3.POSTAL_CODE DEL_TO_SITE_USE_POSTAL_CODE
, LOC3.PROVINCE DEL_TO_SITE_USE_PROVINCE
, LOC3.COUNTY DEL_TO_SITE_USE_COUNTY
, LOC3.COUNTRY DEL_TO_SITE_USE_COUNTRY
, WDD.LPN_ID
, WLPN.LICENSE_PLATE_NUMBER
, '_LA:WDD.INSPECTION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.ORIGINAL_SUBINVENTORY
, SUBINV2.DESCRIPTION ORIGINAL_SUBINV_DESCRIPTION
, '_LA:WDD.PICKABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_DELIVERY_DETAILS:WDD'
, '_DF:WSH:WSH_VEA_DELIVERY_DETAILS:WDD'
, WDD.INVENTORY_ITEM_ID
, WDD.MASTER_CONTAINER_ITEM_ID
, WDD.DETAIL_CONTAINER_ITEM_ID
, '_KF:INV:MSTK:MSI'
, '_KF:INV:MSTK:MASTER_ITEM'
, '_KF:INV:MSTK:DETAIL_ITEM'
FROM WSH_DELIVERY_DETAILS WDD
, MTL_SYSTEM_ITEMS MSI
, MTL_CUSTOMER_ITEMS CUST_ITEM
, MTL_SYSTEM_ITEMS MASTER_ITEM
, MTL_SYSTEM_ITEMS DETAIL_ITEM
, OE_SETS OS1
, OE_SETS OS2
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_LOCATIONS LOC3
, WSH_LOCATIONS LOC4
, MTL_TXN_REQUEST_LINES MTRL
, MTL_SECONDARY_INVENTORIES SUBINV1
, MTL_SECONDARY_INVENTORIES SUBINV2
, HZ_PARTIES CONTACT1
, HZ_PARTIES CONTACT2
, HZ_PARTIES CONTACT3
, HZ_PARTIES CONTACT4
, HZ_CUST_ACCOUNTS CUSTACCT
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL SITE_USE1
, HZ_CUST_SITE_USES_ALL SITE_USE2
, PA_PROJECTS_ALL PROJ
, PA_TASKS PROJTASK
, MTL_ITEM_LOCATIONS MIL
, MTL_MOVEMENT_STATISTICS MMS
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WDD.CUSTOMER_ITEM_ID = CUST_ITEM.CUSTOMER_ITEM_ID(+)
AND WDD.MASTER_CONTAINER_ITEM_ID = MASTER_ITEM.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MASTER_ITEM.ORGANIZATION_ID(+)
AND WDD.DETAIL_CONTAINER_ITEM_ID = DETAIL_ITEM.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = DETAIL_ITEM.ORGANIZATION_ID(+)
AND '_SEC:WDD.ORGANIZATION_ID' IS NOT NULL
AND WDD.SHIP_SET_ID=OS1.SET_ID(+)
AND WDD.ARRIVAL_SET_ID=OS2.SET_ID(+)
AND WDD.SHIP_FROM_LOCATION_ID =LOC1.WSH_LOCATION_ID(+)
AND WDD.SHIP_TO_LOCATION_ID =LOC2.WSH_LOCATION_ID(+)
AND WDD.DELIVER_TO_LOCATION_ID =LOC3.WSH_LOCATION_ID(+)
AND WDD.INTMED_SHIP_TO_LOCATION_ID =LOC4.WSH_LOCATION_ID(+)
AND WDD.MOVE_ORDER_LINE_ID=MTRL.LINE_ID(+)
AND WDD.SUBINVENTORY = SUBINV1.SECONDARY_INVENTORY_NAME(+)
AND WDD.ORGANIZATION_ID = SUBINV1.ORGANIZATION_ID(+)
AND WDD.ORIGINAL_SUBINVENTORY = SUBINV2.SECONDARY_INVENTORY_NAME(+)
AND WDD.ORGANIZATION_ID = SUBINV2.ORGANIZATION_ID(+)
AND WDD.SOLD_TO_CONTACT_ID = CONTACT1.PARTY_ID(+)
AND WDD.SHIP_TO_CONTACT_ID = CONTACT2.PARTY_ID(+)
AND WDD.DELIVER_TO_CONTACT_ID = CONTACT3.PARTY_ID(+)
AND WDD.INTMED_SHIP_TO_CONTACT_ID = CONTACT4.PARTY_ID(+)
AND WDD.CUSTOMER_ID = CUSTACCT.CUST_ACCOUNT_ID(+)
AND CUSTACCT.PARTY_ID = PARTY.PARTY_ID(+)
AND WDD.SHIP_TO_SITE_USE_ID = SITE_USE1.SITE_USE_ID(+)
AND WDD.DELIVER_TO_SITE_USE_ID = SITE_USE2.SITE_USE_ID(+)
AND WDD.PROJECT_ID = PROJ.PROJECT_ID(+)
AND WDD.TASK_ID = PROJTASK.TASK_ID(+)
AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+)
AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+)
AND WDD.MOVEMENT_ID=MMS.MOVEMENT_ID(+)
AND WDD.ORGANIZATION_ID=MMS.ORGANIZATION_ID(+)
AND WDD.LPN_ID=WLPN.LPN_ID(+)
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY