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 1827: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

1823: SELECT WS_B.DISTRIBUTION_FUNCTION ,
1824: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
1825: INTO l_distribution_function,
1826: l_dist_st_based_on_parent_flag, l_ws_code
1827: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
1828: WHERE ws_b.ws_id = l_nw_items_list(z).WS_ID
1829: AND ws_b.not_valid_flag = l_not_valid_flag
1830: AND ws_b.ws_id = ws_a.ws_id(+);
1831:

Line 2731: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

2727: l_not_valid_flag VARCHAR2(1);
2728: cursor c_ws is
2729: select WS_B.WS_ID, 'INDIVIDUAL_ASSIGNED' DISTRIBUTE_TO, 'GROUP_OWNED' DISTRIBUTE_FROM , WS_B.DISTRIBUTION_FUNCTION ,
2730: WS_A.DIST_ST_BASED_ON_PARENT_FLAG, WS_B.WS_CODE
2731: from IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
2732: where ws_b.not_valid_flag = l_not_valid_flag
2733: and ws_b.ws_id = ws_a.ws_id(+);
2734:
2735: -- Audit Trail