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.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_WS_ASSCT_PROPS

Line 975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;

971: -- used for Distribution
972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;
975: l_dist_st_based_on_parent_flag IEU_UWQM_WS_ASSCT_PROPS.DIST_ST_BASED_ON_PARENT_FLAG%TYPE;
976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;
977: l_dist_bus_rules SYSTEM.DIST_BUS_RULES_NST;
978: l_work_item_status VARCHAR2(50);
979: l_work_item_status_id NUMBER;

Line 1861: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

1857: SELECT WS_B.DISTRIBUTION_FUNCTION ,
1858: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
1859: INTO l_distribution_function,
1860: l_dist_st_based_on_parent_flag, l_ws_code
1861: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
1862: WHERE ws_b.ws_id = l_nw_items_list(z).WS_ID
1863: AND ws_b.not_valid_flag = l_not_valid_flag
1864: AND ws_b.ws_id = ws_a.ws_id(+);
1865:

Line 2765: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

2761: l_not_valid_flag VARCHAR2(1);
2762: cursor c_ws is
2763: select WS_B.WS_ID, 'INDIVIDUAL_ASSIGNED' DISTRIBUTE_TO, 'GROUP_OWNED' DISTRIBUTE_FROM , WS_B.DISTRIBUTION_FUNCTION ,
2764: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
2765: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
2766: where ws_b.not_valid_flag = l_not_valid_flag
2767: and ws_b.ws_id = ws_a.ws_id(+);
2768:
2769: -- Audit Trail