View: WSH_CONSOL_BATCHES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_CONSOL_BATCHES_V

View Text

SELECT WCB.ROWID ROW_ID
, WCB.BATCH_ID
, WCB.CREATION_DATE
, WCB.CREATED_BY
, WCB.LAST_UPDATE_DATE
, WCB.LAST_UPDATED_BY
, WCB.LAST_UPDATE_LOGIN
, ORG.ORGANIZATION_CODE ORGANIZATION_CODE
, H_ORG_VL.NAME ORGANIZATION_NAME
, WCB.ORGANIZATION_ID ORGANIZATION_ID
, WCB.CONSOL_GROUPING_RULE_ID
, CGR.RULE_NAME
, WCB.CONSOL_SHIP_TO_LOCATION_ID
, WCST.UI_LOCATION_CODE CONSOL_SHIP_TO_LOCATION
, WCB.INTMED_SHIP_TO_LOCATION_ID
, WIST.UI_LOCATION_CODE INTMED_SHIP_TO_LOCATION
, WCB.ULTI_SHIP_TO_LOCATION_ID
, WUST.UI_LOCATION_CODE ULTI_SHIP_TO_LOCATION
, WCB.BATCH_ID PR_BATCH_ID
, WPB.NAME PR_BATCH_NAME
, WCB.ULTI_SHIP_TO_ZONE ZONE_ID
, WR.ZONE ZONE
, WCB.MODE_OF_TRANSPORT
, SL1.MEANING MODE_MEANING
, WCB.SERVICE_LEVEL
, SL2.MEANING SERVICE_LEVEL_MEANING
, WCB.FOB_CODE
, AL.MEANING FOB_MEANING
, WCB.FREIGHT_TERMS_CODE
, FLV.MEANING FREIGHT_TERMS_MEANING
, WCB.CARRIER_ID
, HP1.PARTY_NAME CARRIER_NAME
, WCB.CUSTOMER_ID
, SUBSTRB ( HP2.PARTY_NAME
, 1
, 50 ) CUSTOMER_NAME
, WCB.SHIP_TO_OVERIDE_FLAG
, WCB.DELIVERY_NAME_FROM
, WCB.DELIVERY_NAME_TO
, WCB.PICKUP_START_DAYS
, WCB.PICKUP_END_DAYS
, WCB.DROPOFF_START_DAYS
, WCB.DROPOFF_END_DAYS
, WCB.LOADING_SEQUENCE
, WCB.ULTI_SHIP_TO_REGION
, WCB.ULTI_SHIP_TO_ZIP_FROM
, WCB.ULTI_SHIP_TO_ZIP_TO
, WCB.INCL_STAGED_DEL_FLAG
, WCB.INCL_DEL_ASG_TRIPS_FLAG
, WCB.CR_TRIP_TO_ULTM_SHIP_TO
, WCB.ROUTE_TRIPS_FLAG
, WCB.RATE_TRIPS_FLAG
, WCB.TRIP_NAME_PREFIX
, WCB.MAX_TRIP_WEIGHT
, WCB.MAX_TRIP_WEIGHT_UOM
, UOM.UNIT_OF_MEASURE_TL AS MAX_WEIGHT_UOM_MEAINING
FROM WSH_CONSOL_BATCHES WCB
, MTL_PARAMETERS ORG
, MTL_UNITS_OF_MEASURE_VL UOM
, HR_ALL_ORGANIZATION_UNITS_VL H_ORG_VL
, WSH_CONSOL_GROUPING_RULES CGR
, WSH_LOCATIONS WCST
, WSH_LOCATIONS WIST
, WSH_LOCATIONS WUST
, WSH_PICKING_BATCHES WPB
, WSH_REGIONS_V WR
, WSH_LOOKUPS SL1
, WSH_LOOKUPS SL2
, AR_LOOKUPS AL
, FND_LOOKUP_VALUES_VL FLV
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, HZ_CUST_ACCOUNTS HCA
WHERE ORG.ORGANIZATION_ID = WCB.ORGANIZATION_ID
AND H_ORG_VL.ORGANIZATION_ID = WCB.ORGANIZATION_ID
AND CGR.CONSOL_GROUPING_RULE_ID = WCB.CONSOL_GROUPING_RULE_ID
AND WCST.WSH_LOCATION_ID (+) = WCB.CONSOL_SHIP_TO_LOCATION_ID
AND WIST.WSH_LOCATION_ID (+) = WCB.INTMED_SHIP_TO_LOCATION_ID
AND WUST.WSH_LOCATION_ID (+) = WCB.ULTI_SHIP_TO_LOCATION_ID
AND SL1.LOOKUP_CODE(+) = WCB.MODE_OF_TRANSPORT
AND SL1.LOOKUP_TYPE(+) = 'WSH_MODE_OF_TRANSPORT'
AND SL2.LOOKUP_CODE(+) = WCB.SERVICE_LEVEL
AND SL2.LOOKUP_TYPE(+) = 'WSH_SERVICE_LEVELS'
AND UOM.UOM_CLASS(+) = 'WEIGHT'
AND UOM.UOM_CODE(+) = WCB.MAX_TRIP_WEIGHT_UOM
AND AL.LOOKUP_CODE(+) = WCB.FOB_CODE
AND AL.LOOKUP_TYPE(+) = 'FOB'
AND FLV.LOOKUP_CODE(+) = WCB.FREIGHT_TERMS_CODE
AND FLV.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
AND FLV.VIEW_APPLICATION_ID (+) = 660
AND HP1.PARTY_ID (+) = WCB.CARRIER_ID
AND HCA.CUST_ACCOUNT_ID (+) = WCB.CUSTOMER_ID
AND HP2.PARTY_ID (+) = HCA.PARTY_ID
AND WPB.BATCH_ID (+) = WCB.BATCH_ID
AND WR.REGION_ID (+) = WCB.ULTI_SHIP_TO_ZONE

Columns