Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_CARRIER_SHIP_METHODS_V |
SELECT CSM.ROWID
, CSM.CARRIER_SHIP_METHOD_ID
, CSM.CARRIER_ID
, CSM.SHIP_METHOD_CODE
, FL.MEANING
, CSM.SERVICE_LEVEL
, CSM.ENABLED_FLAG
, CSM.ATTRIBUTE_CATEGORY
, CSM.ATTRIBUTE1
, CSM.ATTRIBUTE2
, CSM.ATTRIBUTE3
, CSM.ATTRIBUTE4
, CSM.ATTRIBUTE5
, CSM.ATTRIBUTE6
, CSM.ATTRIBUTE7
, CSM.ATTRIBUTE8
, CSM.ATTRIBUTE9
, CSM.ATTRIBUTE10
, CSM.ATTRIBUTE11
, CSM.ATTRIBUTE12
, CSM.ATTRIBUTE13
, CSM.ATTRIBUTE14
, CSM.ATTRIBUTE15
, CSM.CREATION_DATE
, CSM.CREATED_BY
, CSM.LAST_UPDATE_DATE
, CSM.LAST_UPDATED_BY
, CSM.LAST_UPDATE_LOGIN
, CSM.FREIGHT_CODE
, OFV.FREIGHT_CODE_TL
, CSM.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, CSM.CARRIER_SITE_ID
, CSM.WEB_ENABLED
, FL.START_DATE_ACTIVE
, FL.END_DATE_ACTIVE
FROM WSH_CARRIER_SHIP_METHODS CSM
, FND_LOOKUP_VALUES_VL FL
, ORG_FREIGHT_VL OFV
, MTL_PARAMETERS MP
WHERE FL.LOOKUP_TYPE = 'SHIP_METHOD'
AND FL.LOOKUP_CODE = CSM.SHIP_METHOD_CODE
AND FL.VIEW_APPLICATION_ID = 3
AND MP.ORGANIZATION_ID = CSM.ORGANIZATION_ID
AND OFV.ORGANIZATION_ID = CSM.ORGANIZATION_ID
AND OFV.FREIGHT_CODE = CSM.FREIGHT_CODE