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.WMS_WAVE_PLANNING_PVT dependencies on BOM_DEPT_RES_INSTANCES

Line 6957: from BOM_DEPT_RES_INSTANCES

6953: if (p_24hrs = 1) then
6954: print_debug('P_24HRS = 1 ===> available 24 hrs', l_debug);
6955: select count(*)
6956: into l_instance_count
6957: from BOM_DEPT_RES_INSTANCES
6958: WHERE resource_id = p_resource_id
6959: and department_id = p_dept_id;
6960:
6961: l_temp_capacity := wms_wave_planning_pvt.get_resource_capacity(wst,

Line 7609: OR (SELECT Count(1) FROM BOM_DEPT_RES_INSTANCES WHERE resource_id= bdr.resource_id AND department_id=bdr.department_id) > 0);*/

7605: and wwp.department_id=v_department_id
7606: and wwp.department_id=bdr.department_id
7607: and wwlp.resource_type=bdr.resource_code
7608: AND (bdr.AVAILABLE_24_HOURS_FLAG=2
7609: OR (SELECT Count(1) FROM BOM_DEPT_RES_INSTANCES WHERE resource_id= bdr.resource_id AND department_id=bdr.department_id) > 0);*/
7610:
7611: TYPE ITEM_TBL IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7612:
7613: x_item_tbl ITEM_TBL;