VIEW: APPS.WSH_CONSOL_BATCHES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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