View: WSHFV_DELIVERIES

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Deliveries.
Implementation/DBA Data:	APPS.WSHFV_DELIVERIES

View Text

SELECT WND.DELIVERY_ID
, WND.NAME
, WND.ORGANIZATION_ID
, MPA.ORGANIZATION_CODE
, ORG.NAME
, WND.CREATION_DATE
, WND.CREATED_BY
, WND.LAST_UPDATE_DATE
, WND.LAST_UPDATED_BY
, WND.LAST_UPDATE_LOGIN
, '_LA:STATUS_CODE:WSH_LOOKUPS:DELIVERY_STATUS:MEANING'
, WND.CONFIRM_DATE
, WND.LOADING_SEQUENCE
, WND.CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HZP.PARTY_NUMBER CUSTOMER_NUMBER
, LOC1.SOURCE_LOCATION_ID
, LOC1.UI_LOCATION_CODE
, LOC2.SOURCE_LOCATION_ID
, LOC2.UI_LOCATION_CODE
, LOC3.SOURCE_LOCATION_ID
, LOC3.UI_LOCATION_CODE
, WND.WAYBILL
, WND.GROSS_WEIGHT
, WND.WEIGHT_UOM_CODE
, WND.VOLUME
, WND.VOLUME_UOM_CODE
, WND.ULTIMATE_DROPOFF_DATE
, WND.ASN_DATE_SENT
, WND.ASN_SEQ_NUMBER
, WND.LOADING_ORDER_FLAG
, WND.FREIGHT_TERMS_CODE
, WND.CURRENCY_CODE
, '_LA:PLANNED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WND.INITIAL_PICKUP_DATE
, LOC4.SOURCE_LOCATION_ID
, LOC4.UI_LOCATION_CODE
, LOC5.SOURCE_LOCATION_ID
, LOC5.UI_LOCATION_CODE
, '_LA:ACCEPTANCE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WND.ACCEPTED_BY
, WND.ACCEPTED_DATE
, WND.ACKNOWLEDGED_BY
, WND.CONFIRMED_BY
, WND.REASON_OF_TRANSPORT
, WND.DESCRIPTION
, WND.NET_WEIGHT
, WND.PORT_OF_DISCHARGE
, WND.PORT_OF_LOADING
, WND.ADDITIONAL_SHIPMENT_INFO
, WND.BOOKING_NUMBER
, WND.COD_AMOUNT
, WND.COD_CURRENCY_CODE
, WND.SERVICE_CONTRACT
, WND.COD_REMIT_TO
, WND.COD_CHARGE_PAID_BY
, WND.PROBLEM_CONTACT_REFERENCE
, WND.BILL_FREIGHT_TO
, WND.CARRIED_BY
, WND.DOCK_CODE
, WND.DELIVERY_TYPE
, WND.CARRIER_ID
, WND.NUMBER_OF_LPN
, '_LA:SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, '_LA:FOB_CODE:FND_LOOKUP_VALUES_VL:FOB:MEANING'
, '_DF:WSH:WSH_NEW_DELIVERIES:WND'
, '_DF:WSH:WSH_VEA_NEW_DELIVERIES:WND'
, '_DF:JG:JG_WSH_NEW_DELIVERIES:WND'
FROM WSH_NEW_DELIVERIES WND
, HR_ALL_ORGANIZATION_UNITS ORG
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_LOCATIONS LOC3
, WSH_LOCATIONS LOC4
, WSH_LOCATIONS LOC5
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS CUST_ACCT
, MTL_PARAMETERS MPA
WHERE WND.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND WND.CUSTOMER_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND CUST_ACCT.PARTY_ID = HZP.PARTY_ID(+)
AND WND.ULTIMATE_DROPOFF_LOCATION_ID =LOC1.WSH_LOCATION_ID
AND WND.INTMED_SHIP_TO_LOCATION_ID =LOC2.WSH_LOCATION_ID(+)
AND WND.POOLED_SHIP_TO_LOCATION_ID = LOC3.WSH_LOCATION_ID(+)
AND WND.INITIAL_PICKUP_LOCATION_ID = LOC4.WSH_LOCATION_ID
AND WND.FOB_LOCATION_ID = LOC5.WSH_LOCATION_ID(+)
AND WND.ORGANIZATION_ID = MPA.ORGANIZATION_ID(+)
AND '_SEC:WND.ORGANIZATION_ID' IS NOT NULL
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns