VIEW: APPS.WSH_FREIGHT_COST_TYPES_V

Source

View Text - Preformatted

SELECT FCT.ROWID, FCT.FREIGHT_COST_TYPE_ID, FCT.NAME, FCT.FREIGHT_COST_TYPE_CODE, WSHLU.MEANING , FCT.AMOUNT , FCT.CURRENCY_CODE , FCT.DESCRIPTION , FCT.START_DATE_ACTIVE, FCT.END_DATE_ACTIVE, FCT.ATTRIBUTE_CATEGORY , FCT.ATTRIBUTE1, FCT.ATTRIBUTE2 , FCT.ATTRIBUTE3 , FCT.ATTRIBUTE4 , FCT.ATTRIBUTE5 , FCT.ATTRIBUTE6 , FCT.ATTRIBUTE7 , FCT.ATTRIBUTE8, FCT.ATTRIBUTE9 , FCT.ATTRIBUTE10 , FCT.ATTRIBUTE11 , FCT.ATTRIBUTE12 , FCT.ATTRIBUTE13 , FCT.ATTRIBUTE14 , FCT.ATTRIBUTE15 , FCT.CREATION_DATE, FCT.CREATED_BY , FCT.LAST_UPDATE_DATE, FCT.LAST_UPDATED_BY, FCT.LAST_UPDATE_LOGIN, FCT.PROGRAM_APPLICATION_ID , FCT.PROGRAM_ID , FCT.PROGRAM_UPDATE_DATE, FCT.REQUEST_ID, FCT.CHARGE_MAP_FLAG FROM WSH_FREIGHT_COST_TYPES FCT,WSH_LOOKUPS WSHLU WHERE WSHLU.LOOKUP_TYPE = 'FREIGHT_COST_TYPE' AND WSHLU.LOOKUP_CODE = FCT.FREIGHT_COST_TYPE_CODE AND (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y' OR FCT.FREIGHT_COST_TYPE_CODE NOT IN ('FTEPRICE','FTECHARGE','FTESUMMARY','FTEDISCOUNT'))

View Text - HTML Formatted

SELECT FCT.ROWID
, FCT.FREIGHT_COST_TYPE_ID
, FCT.NAME
, FCT.FREIGHT_COST_TYPE_CODE
, WSHLU.MEANING
, FCT.AMOUNT
, FCT.CURRENCY_CODE
, FCT.DESCRIPTION
, FCT.START_DATE_ACTIVE
, FCT.END_DATE_ACTIVE
, FCT.ATTRIBUTE_CATEGORY
, FCT.ATTRIBUTE1
, FCT.ATTRIBUTE2
, FCT.ATTRIBUTE3
, FCT.ATTRIBUTE4
, FCT.ATTRIBUTE5
, FCT.ATTRIBUTE6
, FCT.ATTRIBUTE7
, FCT.ATTRIBUTE8
, FCT.ATTRIBUTE9
, FCT.ATTRIBUTE10
, FCT.ATTRIBUTE11
, FCT.ATTRIBUTE12
, FCT.ATTRIBUTE13
, FCT.ATTRIBUTE14
, FCT.ATTRIBUTE15
, FCT.CREATION_DATE
, FCT.CREATED_BY
, FCT.LAST_UPDATE_DATE
, FCT.LAST_UPDATED_BY
, FCT.LAST_UPDATE_LOGIN
, FCT.PROGRAM_APPLICATION_ID
, FCT.PROGRAM_ID
, FCT.PROGRAM_UPDATE_DATE
, FCT.REQUEST_ID
, FCT.CHARGE_MAP_FLAG
FROM WSH_FREIGHT_COST_TYPES FCT
, WSH_LOOKUPS WSHLU
WHERE WSHLU.LOOKUP_TYPE = 'FREIGHT_COST_TYPE'
AND WSHLU.LOOKUP_CODE = FCT.FREIGHT_COST_TYPE_CODE
AND (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y' OR FCT.FREIGHT_COST_TYPE_CODE NOT IN ('FTEPRICE'
, 'FTECHARGE'
, 'FTESUMMARY'
, 'FTEDISCOUNT'))