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

Line 1071: FROM wsh_delivery_details

1067: -- get wdd requested quantity with line detail level
1068: BEGIN
1069: SELECT nvl(sum(requested_quantity), 0) , nvl(sum(requested_quantity2), 0)
1070: INTO l_wdd_primary_quantity, l_wdd_secondary_quantity
1071: FROM wsh_delivery_details
1072: WHERE source_line_id = p_demand_source_line_id
1073: AND delivery_detail_id = p_demand_source_line_detail
1074: AND nvl(project_id, -99) = nvl(p_project_id, -99)
1075: AND nvl(task_id, -99) = nvl(p_task_id, -99);

Line 1608: FROM wsh_delivery_details wdd

1604: SELECT nvl((Sum(wdd.picked_quantity)),0), wdd.requested_quantity_uom
1605: ,nvl((Sum(wdd.picked_quantity2)),0)
1606: INTO l_wdd_picked_qty, l_wdd_uom_code
1607: ,l_wdd_picked_qty2
1608: FROM wsh_delivery_details wdd
1609: WHERE wdd.source_line_id = p_demand_source_line_id
1610: AND wdd.released_status IN ('Y','C')
1611: AND NOT EXISTS
1612: (