APPS.FTE_FPA_UTIL dependencies on WSH_TRIP_STOPS

Line 249: WSH_TRIP_STOPS WT,

245: SELECT nvl(WFC.TOTAL_AMOUNT,0),
246: WFC.CURRENCY_CODE
247: FROM
248: WSH_DELIVERY_LEGS WDL ,
249: WSH_TRIP_STOPS WT,
250: WSH_FREIGHT_COSTS WFC
251: WHERE
252: WT.STOP_ID = WDL.PICK_UP_STOP_ID
253: AND WFC.DELIVERY_LEG_ID = WDL.DELIVERY_LEG_ID

Line 1229: WSH_TRIP_STOPS WTS,

1225: FROM
1226: WSH_DELIVERY_DETAILS WDD,
1227: WSH_DELIVERY_ASSIGNMENTS WDA,
1228: WSH_DELIVERY_LEGS WDL,
1229: WSH_TRIP_STOPS WTS,
1230: WSH_TRIPS WT
1231: WHERE
1232: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1233: AND (WDA.DELIVERY_ID = WDL.DELIVERY_ID OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)

Line 1264: WSH_TRIP_STOPS WTS,

1260: FROM
1261: WSH_DELIVERY_DETAILS WDD,
1262: WSH_DELIVERY_ASSIGNMENTS WDA,
1263: WSH_DELIVERY_LEGS WDL,
1264: WSH_TRIP_STOPS WTS,
1265: WSH_TRIPS WT,
1266: MTL_ITEM_CATEGORIES MIC,
1267: MTL_CATEGORIES_KFV C,
1268: MTL_CATEGORY_SETS S

Line 1561: WSH_TRIP_STOPS WTS,

1557: FROM
1558: WSH_DELIVERY_DETAILS WDD,
1559: WSH_DELIVERY_ASSIGNMENTS WDA,
1560: WSH_DELIVERY_LEGS WDL,
1561: WSH_TRIP_STOPS WTS,
1562: WSH_TRIPS WT,
1563: WSH_DOCUMENT_INSTANCES WDI
1564: WHERE
1565: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID

Line 1591: WSH_TRIP_STOPS WTS,

1587: FROM
1588: WSH_DELIVERY_DETAILS WDD,
1589: WSH_DELIVERY_ASSIGNMENTS WDA,
1590: WSH_DELIVERY_LEGS WDL,
1591: WSH_TRIP_STOPS WTS,
1592: WSH_TRIPS WT
1593: WHERE
1594: WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
1595: AND (WDA.DELIVERY_ID = WDL.DELIVERY_ID OR WDA.PARENT_DELIVERY_ID = WDL.DELIVERY_ID)

Line 1626: WSH_TRIP_STOPS WTS,

1622: FROM
1623: WSH_DELIVERY_DETAILS WDD,
1624: WSH_DELIVERY_ASSIGNMENTS WDA,
1625: WSH_DELIVERY_LEGS WDL,
1626: WSH_TRIP_STOPS WTS,
1627: WSH_TRIPS WT,
1628: MTL_ITEM_CATEGORIES MIC,
1629: MTL_CATEGORIES_KFV C,
1630: MTL_CATEGORY_SETS S