APPS.WIP_PROD_INDICATORS dependencies on WIP_BIS_UTZ_TEMP

Line 2769: populate_temp_table ('WIP_BIS_UTZ_TEMP', 2, p_group_id);

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;
2771: -- yield table - indicator = WIP_YIELD = 3
2772: populate_temp_table ('WIP_BIS_YLD_TEMP', 3, p_group_id);
2773:

Line 2886: from wip_bis_utz_temp wit

2882:
2883: update/*+ PARALLEL*/ wip_bis_prod_indicators wbpi
2884: set (wbpi.APPLIED_HOURS_UTZ, wbpi.AVAILABLE_HOURS) =
2885: ( select wit.applied_units_utz, wit.available_units
2886: from wip_bis_utz_temp wit
2887: where wit.organization_id = wbpi.organization_id
2888: and wit.wip_entity_id = wbpi.wip_entity_id
2889: and wit.operation_seq_num = wbpi.operation_seq_num
2890: and wit.department_id = wbpi.department_id

Line 3008: wip_bis_utz_temp wit

3004: wit.request_id,
3005: wit.program_application_id,
3006: sysdate
3007: from wip_entities we,
3008: wip_bis_utz_temp wit
3009: where we.wip_entity_id = wit.wip_entity_id
3010: and we.organization_id = wit.organization_id
3011: and wit.indicator_type = WIP_UTILIZATION
3012: and not exists (

Line 3351: FROM wip_bis_utz_temp

3347: FROM (SELECT distinct organization_id,
3348: resource_id,
3349: department_id,
3350: transaction_date
3351: FROM wip_bis_utz_temp
3352: WHERE process_phase = WIP_UTZ_PHASE_TWO
3353: AND indicator_type = WIP_UTILIZATION) wit_distinct;
3354:
3355: -- Note that from Populate_Utilization, we know that

Line 3400: FROM wip_bis_utz_temp

3396: department_id,
3397: resource_id,
3398: transaction_date,
3399: count (*) net_occurances
3400: FROM wip_bis_utz_temp
3401: WHERE indicator_type = WIP_UTILIZATION
3402: AND process_phase = WIP_UTZ_PHASE_TWO
3403: GROUP BY organization_id,
3404: department_id,

Line 3628: '.WIP_BIS_UTZ_TEMP';

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:
3630: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3631: '.WIP_BIS_YLD_TEMP';
3632:

Line 3730: '.WIP_BIS_UTZ_TEMP';

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:
3732: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_wip_schema ||
3733: '.WIP_BIS_YLD_TEMP';
3734:

Line 6138: wip_bis_utz_temp wit2,

6134: wit.program_application_id,
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