APPS.WIP_PROD_INDICATORS dependencies on WIP_INDICATORS_TEMP_S

Line 239: select wip_indicators_temp_s.nextval into x_group_id

235: x_userid := p_userid ;
236: end if;
237:
238: IF p_group_id IS NULL THEN
239: select wip_indicators_temp_s.nextval into x_group_id
240: from sys.dual ;
241: ELSE
242: x_group_id := p_group_id ;
243: END IF;

Line 756: select wip_indicators_temp_s.nextval into x_group_id

752: end if;
753:
754:
755: IF p_group_id IS NULL THEN
756: select wip_indicators_temp_s.nextval into x_group_id
757: from sys.dual ;
758: ELSE
759: x_group_id := p_group_id ;
760: END IF;

Line 977: select wip_indicators_temp_s.nextval into x_group_id

973: x_userid := p_userid ;
974: end if;
975:
976: IF p_group_id IS NULL THEN
977: select wip_indicators_temp_s.nextval into x_group_id
978: from sys.dual ;
979: ELSE
980: x_group_id := p_group_id ;
981: END IF;

Line 1491: select wip_indicators_temp_s.nextval into x_group_id

1487: end if;
1488:
1489:
1490: IF p_group_id IS NULL THEN
1491: select wip_indicators_temp_s.nextval into x_group_id
1492: from sys.dual ;
1493: ELSE
1494: x_group_id := p_group_id ;
1495: END IF;

Line 3318: -- wip_indicators_temp's UTILIZATION rows and computing the

3314: l_wit_utz_size := 0;
3315: proc_name := 'Move_Utz_Info';
3316:
3317: -- The original insert into wip_bis_prod_indicators was using
3318: -- wip_indicators_temp's UTILIZATION rows and computing the
3319: -- measure available_hours as:
3320: -- sum (((mnra.to_time-mnra.from_time)/3600)*mnra.capacity_units)
3321: -- for 4 attributes:
3322: -- 1. organization_id

Line 4156: select wip_indicators_temp_s.nextval into x_group_id

4152: end if;
4153:
4154:
4155: IF p_group_id IS NULL THEN
4156: select wip_indicators_temp_s.nextval into x_group_id
4157: from sys.dual ;
4158: ELSE
4159: x_group_id := p_group_id ;
4160: END IF;

Line 4624: select wip_indicators_temp_s.nextval into x_group_id

4620: end if;
4621:
4622:
4623: IF p_group_id IS NULL THEN
4624: select wip_indicators_temp_s.nextval into x_group_id
4625: from sys.dual ;
4626: ELSE
4627:
4628: x_group_id := p_group_id ;