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.

[Home] [Help]

APPS.IEU_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_WORK_SOURCES_B

Line 972: l_distribute_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

968: l_ws_id NUMBER;
969: l_ctr NUMBER := 0;
970:
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;

Line 973: l_distribute_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

969: l_ctr NUMBER := 0;
970:
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;

Line 974: l_distribution_function IEU_UWQM_WORK_SOURCES_B.DISTRIBUTION_FUNCTION%TYPE;

970:
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);

Line 976: l_ws_code IEU_UWQM_WORK_SOURCES_B.WS_CODE%TYPE;

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;
980: l_dist_items SYSTEM.WR_ITEM_DATA_NST;

Line 1499: from ieu_uwqm_work_sources_b

1495:
1496: BEGIN
1497: select ws_code
1498: into l_ws_code
1499: from ieu_uwqm_work_sources_b
1500: where ws_id = l_del_nw_item.ws_id;
1501: EXCEPTION
1502: WHEN OTHERS THEN
1503: l_ws_code := '';

Line 1721: from ieu_uwqm_work_sources_b

1717:
1718: BEGIN
1719: select ws_code
1720: into l_ws_code
1721: from ieu_uwqm_work_sources_b
1722: where ws_id = l_del_nw_item.ws_id;
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: l_ws_code := '';

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

Line 3041: from ieu_uwqm_work_sources_b

3037: /*
3038: begin
3039: select ws_code
3040: into l_ws_name
3041: from ieu_uwqm_work_sources_b
3042: where ws_id = l_curr_ws_id;
3043: exception
3044: when others then
3045: l_ws_name := '';

Line 3686: FROM ieu_uwqm_work_sources_b

3682: BEGIN
3683: l_not_valid_flag := 'N';
3684: SELECT ws_id
3685: INTO l_ws_id
3686: FROM ieu_uwqm_work_sources_b
3687: WHERE ws_code = p_dist_workitem_data(n).WORK_SOURCE
3688: -- AND nvl(not_valid_flag,'N') = 'N';
3689: AND nvl(not_valid_flag,'N') = l_not_valid_flag;
3690:

Line 4286: from IEU_UWQM_WORK_SOURCES_B WS_B

4282:
4283: /*
4284: cursor C1 is
4285: select WS_B.WS_ID, WS_B.DISTRIBUTE_TO, WS_B.DISTRIBUTE_FROM , WS_B.DISTRIBUTION_FUNCTION
4286: from IEU_UWQM_WORK_SOURCES_B WS_B
4287: where ws_b.not_valid_flag = 'N';
4288: */
4289:
4290: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

Line 4290: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

4286: from IEU_UWQM_WORK_SOURCES_B WS_B
4287: where ws_b.not_valid_flag = 'N';
4288: */
4289:
4290: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4291: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4292: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4293:
4294: -- Variables for Distribute_from

Line 4291: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

4287: where ws_b.not_valid_flag = 'N';
4288: */
4289:
4290: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4291: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4292: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4293:
4294: -- Variables for Distribute_from
4295:

Line 4292: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;

4288: */
4289:
4290: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
4291: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
4292: l_ws_id IEU_UWQM_WORK_SOURCES_B.WS_ID%TYPE;
4293:
4294: -- Variables for Distribute_from
4295:
4296: l_df_own_where_clause varchar2(4000);

Line 4429: from IEU_UWQM_WORK_SOURCES_B WS_B

4425: BEGIN
4426: l_not_valid_flag := 'N';
4427: select WS_B.WS_ID
4428: into l_ws_id
4429: from IEU_UWQM_WORK_SOURCES_B WS_B
4430: where ws_code = p_ws_det_list(i).ws_code
4431: -- and ws_b.not_valid_flag = 'N';
4432: and ws_b.not_valid_flag = l_not_valid_flag;
4433: EXCEPTION