View: FTE_PRC_VIEW_PRICE_UI_V

Product:	FTE - Transportation Execution
Description:	used to display rates for a delivery leg
Implementation/DBA Data:	APPS.FTE_PRC_VIEW_PRICE_UI_V

View Text

SELECT WFC.DELIVERY_DETAIL_ID AS ENTITY_ID
, NVL(WDA.PARENT_DELIVERY_DETAIL_ID
, WFC.DELIVERY_LEG_ID) AS PARENT_ENTITY_ID
, WFC.DELIVERY_LEG_ID AS DELIVERY_LEG_ID
, TO_CHAR(WFC.DELIVERY_DETAIL_ID) AS ENTITY_NAME
, MSIK.CONCATENATED_SEGMENTS AS ITEM_NAME
, FTE_FREIGHT_PRICING_UTIL.GET_LOOKUP_MEANING('CONTAINER_TYPE'
, MSIK.CONTAINER_TYPE_CODE) AS CONTAINER_TYPE
, DECODE(WDD.CONTAINER_FLAG
, 'Y'
, WDD.GROSS_WEIGHT
, NVL(WDD.NET_WEIGHT
, WDD.GROSS_WEIGHT)) ||' '||WDD.WEIGHT_UOM_CODE AS WEIGHT
, WDD.VOLUME||' '||WDD.VOLUME_UOM_CODE AS VOLUME
, WFC.TOTAL_AMOUNT||' '||WFC.CURRENCY_CODE AS PRICE
, WFC.CREATION_DATE AS CREATION_DATE
, WFC.CREATED_BY AS CREATED_BY
, WFC.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, WFC.LAST_UPDATED_BY AS LAST_UPDATED_BY
, WFC.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
, WFC.PROGRAM_APPLICATION_ID AS PROGRAM_APPLICATION_ID
, WFC.PROGRAM_ID AS PROGRAM_ID
, WFC.PROGRAM_UPDATE_DATE AS PROGRAM_UPDATE_DATE
, WFC.REQUEST_ID AS REQUEST_ID
FROM WSH_FREIGHT_COSTS WFC
, WSH_DELIVERY_DETAILS WDD
, MTL_SYSTEM_ITEMS_KFV MSIK
, WSH_DELIVERY_ASSIGNMENTS WDA
WHERE WFC.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WDD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND WDD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WFC.LINE_TYPE_CODE IN ('PRICE'
, 'SUMMARY')
AND WFC.CHARGE_SOURCE_CODE = 'PRICING_ENGINE' UNION SELECT WFC.DELIVERY_LEG_ID AS ENTITY_ID
, -1 AS PARENT_ENTITY_ID
, WFC.DELIVERY_LEG_ID AS DELIVERY_LEG_ID
, FTE_FREIGHT_PRICING_UTIL.GET_LOOKUP_MEANING('FTE_PRC_UI_COST_TYPE'
, 'DELIVERY_LEG_TOTAL') AS ENTITY_NAME
, NULL AS ITEM_NAME
, NULL AS CONTAINER_TYPE
, NULL AS WEIGHT
, NULL AS VOLUME
, WFC.TOTAL_AMOUNT||' '||WFC.CURRENCY_CODE AS PRICE
, WFC.CREATION_DATE AS CREATION_DATE
, WFC.CREATED_BY AS CREATED_BY
, WFC.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, WFC.LAST_UPDATED_BY AS LAST_UPDATED_BY
, WFC.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
, WFC.PROGRAM_APPLICATION_ID AS PROGRAM_APPLICATION_ID
, WFC.PROGRAM_ID AS PROGRAM_ID
, WFC.PROGRAM_UPDATE_DATE AS PROGRAM_UPDATE_DATE
, WFC.REQUEST_ID AS REQUEST_ID
FROM WSH_FREIGHT_COSTS WFC
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WFC.DELIVERY_LEG_ID = WDL.DELIVERY_LEG_ID
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND WFC.DELIVERY_DETAIL_ID IS NULL
AND WFC.LINE_TYPE_CODE = 'SUMMARY'
AND WFC.CHARGE_SOURCE_CODE = 'PRICING_ENGINE' UNION SELECT WFC.FREIGHT_COST_ID AS ENTITY_ID
, WFC.DELIVERY_DETAIL_ID AS PARENT_ENTITY_ID
, WFC.DELIVERY_LEG_ID AS DELIVERY_LEG_ID
, DECODE(WFCT.NAME
, 'PRICE'
, FTE_FREIGHT_PRICING_UTIL.GET_LOOKUP_MEANING('FTE_PRC_UI_COST_TYPE'
, 'PRICE')
, INITCAP(WFCT.NAME)) AS ENTITY_NAME
, NULL AS ITEM_NAME
, NULL AS CONTAINER_TYPE
, NULL AS WEIGHT
, NULL AS VOLUME
, DECODE(LINE_TYPE_CODE
, 'PRICE'
, ROUND(WFC.CHARGE_UNIT_VALUE*WFC.QUANTITY
, 2)
, WFC.TOTAL_AMOUNT)||' '||WFC.CURRENCY_CODE AS PRICE
, WFC.CREATION_DATE AS CREATION_DATE
, WFC.CREATED_BY AS CREATED_BY
, WFC.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, WFC.LAST_UPDATED_BY AS LAST_UPDATED_BY
, WFC.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
, WFC.PROGRAM_APPLICATION_ID AS PROGRAM_APPLICATION_ID
, WFC.PROGRAM_ID AS PROGRAM_ID
, WFC.PROGRAM_UPDATE_DATE AS PROGRAM_UPDATE_DATE
, WFC.REQUEST_ID AS REQUEST_ID
FROM WSH_FREIGHT_COSTS WFC
, WSH_FREIGHT_COST_TYPES WFCT
WHERE WFC.LINE_TYPE_CODE IN ('CHARGE'
, 'PRICE'
, 'DISCOUNT')
AND WFC.CHARGE_SOURCE_CODE = 'PRICING_ENGINE'
AND WFCT.FREIGHT_COST_TYPE_ID = WFC.FREIGHT_COST_TYPE_ID

Columns