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.AHL_OSP_QUERIES_PVT dependencies on WSH_DELIVERY_DETAILS

Line 1681: (select 1 from wsh_delivery_details where SOURCE_CODE = 'OE' and SOURCE_LINE_ID = OSPL.oe_ship_line_id);

1677: (oel.open_flag <> 'N' OR nvl(oel.flow_status_code, 'XXX') <> 'CLOSED') and
1678: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
1679: (p_lot_number is null or ospl.lot_number = p_lot_number) and
1680: not exists
1681: (select 1 from wsh_delivery_details where SOURCE_CODE = 'OE' and SOURCE_LINE_ID = OSPL.oe_ship_line_id);
1682:
1683: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1684: fnd_log.string(fnd_log.level_statement, l_debug_key||':','l_quant_ship_notbooked:'|| l_quant_ship_notbooked);
1685: END IF;

Line 1695: from wsh_delivery_details where

1691: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1692: (inventory_item_id, requested_quantity_uom, requested_quantity),0)
1693: ),0) into l_quant_notshippedout
1694:
1695: from wsh_delivery_details where
1696: organization_id = p_org_id and
1697: inventory_item_id = p_inventory_item_id and
1698: subinventory = p_subinventory_code and
1699: released_status in ('R','S','Y','C','B') and