VIEW: APPS.WSH_CARRIER_SHIP_METHODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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