APPS.WIP_PROD_INDICATORS dependencies on WIP_BIS_EFF_TEMP

Line 2765: populate_eff_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);-- for bug 3280647

2761: -- manipulation. Now we don't need to join to the
2762: -- entire WIT, but only the specialized temp tables.
2763:
2764: -- efficiency table -- indicator = WIP_EFFICIENCY = 1
2765: populate_eff_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);-- for bug 3280647
2766: --populate_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);
2767: Commit;
2768: -- utilization tabe - indicator = WIP_UTILIZATION = 2
2769: populate_temp_table ('WIP_BIS_UTZ_TEMP', 2, p_group_id);

Line 2766: --populate_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);

2762: -- entire WIT, but only the specialized temp tables.
2763:
2764: -- efficiency table -- indicator = WIP_EFFICIENCY = 1
2765: populate_eff_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);-- for bug 3280647
2766: --populate_temp_table ('WIP_BIS_EFF_TEMP', 1, p_group_id);
2767: Commit;
2768: -- utilization tabe - indicator = WIP_UTILIZATION = 2
2769: populate_temp_table ('WIP_BIS_UTZ_TEMP', 2, p_group_id);
2770: commit;

Line 2845: wip_bis_eff_temp wit

2841: wit.request_id,
2842: wit.program_application_id,
2843: sysdate
2844: from wip_entities we,
2845: wip_bis_eff_temp wit
2846: where we.wip_entity_id = wit.wip_entity_id
2847: and we.organization_id = wit.organization_id
2848: and wit.indicator_type = WIP_EFFICIENCY
2849: and not exists (

Line 3625: '.WIP_BIS_EFF_TEMP';

3621: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3622: '.WIP_BIS_MNRA_TEMP';
3623:
3624: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3625: '.WIP_BIS_EFF_TEMP';
3626:
3627: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3628: '.WIP_BIS_UTZ_TEMP';
3629:

Line 3727: '.WIP_BIS_EFF_TEMP';

3723: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3724: '.WIP_BIS_MNRA_TEMP';
3725:
3726: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3727: '.WIP_BIS_EFF_TEMP';
3728:
3729: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3730: '.WIP_BIS_UTZ_TEMP';
3731:

Line 5973: insert into WIP_BIS_EFF_TEMP(

5969: proc_name VARCHAR2(20) ;
5970:
5971: BEGIN
5972: proc_name := 'populate_temp_table';
5973: insert into WIP_BIS_EFF_TEMP(
5974: group_id,
5975: organization_id,
5976: wip_entity_id,
5977: operation_seq_num,

Line 6139: wip_bis_eff_temp wit

6135: sysdate
6136: FROM wip_entities we,
6137: wip_bis_yld_temp wit3,
6138: wip_bis_utz_temp wit2,
6139: wip_bis_eff_temp wit
6140: WHERE
6141: wit2.organization_id = wit.organization_id
6142: AND wit2.department_id = wit.department_id
6143: AND wit2.resource_id = wit.resource_id