Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_FREIGHT_COST_TYPES_V |
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'))