DBA Data[Home] [Help]

APPS.FTE_PO_INTEGRATION_GRP dependencies on WSH_FREIGHT_COSTS

Line 135: FROM WSH_FREIGHT_COSTS WFC

131: WHERE tmp.DELIVERY_ID = WDL.DELIVERY_ID
132: AND ( NVL(WDL.REPRICE_REQUIRED,'N') = 'Y'
133: OR NOT EXISTS
134: (SELECT WFC.DELIVERY_LEG_ID
135: FROM WSH_FREIGHT_COSTS WFC
136: WHERE WFC.DELIVERY_LEG_ID = WDL.DELIVERY_LEG_ID
137: AND WDL.DELIVERY_LEG_ID IS NOT NULL
138: AND WFC.LINE_TYPE_CODE = 'SUMMARY'
139: AND WFC.CHARGE_SOURCE_CODE= 'PRICING_ENGINE'

Line 210: WSH_FREIGHT_COSTS WFC,

206: NVL(wdd.picked_quantity, wdd.requested_quantity)))) TOTAL_SHIP_QTY,
207: SUM(TOTAL_AMOUNT) TOTAL_COST
208: FROM WSH_NEW_DELIVERIES WND,
209: WSH_DELIVERY_LEGS WDL,
210: WSH_FREIGHT_COSTS WFC,
211: WSH_DELIVERY_DETAILS WDD,
212: WSH_DELIVERY_ASSIGNMENTS_V WDA,
213: WSH_TRIPS WT,
214: WSH_TRIP_STOPS WTS1,

Line 264: WSH_FREIGHT_COSTS WFC,

260: WFC.CURRENCY_CODE,
261: SUM(TOTAL_AMOUNT) TOTAL_COST
262: FROM WSH_NEW_DELIVERIES WND,
263: WSH_DELIVERY_LEGS WDL,
264: WSH_FREIGHT_COSTS WFC,
265: WSH_DELIVERY_DETAILS WDD,
266: WSH_DELIVERY_ASSIGNMENTS_V WDA,
267: WSH_TRIPS WT,
268: WSH_TRIP_STOPS WTS1,