VIEW: APPS.WSHFV_DELIVERIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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