eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_PO_INTEGRATION_GRP dependencies on WSH_NEW_DELIVERIES

Line 100: FROM WSH_NEW_DELIVERIES WND

96:
97: /* find all deliveries for matching or non-matching shipments*/
98: cursor c_get_deliveries(l_shipment_header_id number) IS
99: select wnd.delivery_id,'Y' RATE_AVAILABLE_FLAG, 'Y' MATCHING_FLAG
100: FROM WSH_NEW_DELIVERIES WND
101: WHERE WND.RCV_SHIPMENT_HEADER_ID = l_shipment_header_id
102: AND WND.RCV_SHIPMENT_HEADER_ID is not null
103: union
104: select distinct wda.DELIVERY_ID, 'Y' RATE_AVAILABLE_FLAG,'N' MATCHING_FLAG

Line 208: FROM WSH_NEW_DELIVERIES WND,

204: WDD.REQUESTED_QUANTITY_UOM,
205: sum(nvl(wdd.received_quantity, nvl(wdd.shipped_quantity,
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,

Line 262: FROM WSH_NEW_DELIVERIES WND,

258: SELECT WDD.DELIVERY_DETAIL_ID PARENT_CONTAINER_ID,
259: WDD.CURRENCY_CODE PO_CURRENCY_CODE,
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,