APPS.WIP_PROD_INDICATORS dependencies on WIP_BIS_YLD_TEMP

Line 2772: populate_temp_table ('WIP_BIS_YLD_TEMP', 3, p_group_id);

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:
2774: commit;
2775:
2776: -- Phase I: Move records that have utilization, yield and

Line 2941: from wip_bis_yld_temp wit

2937:
2938: update wip_bis_prod_indicators wbpi
2939: set (wbpi.TOTAL_QUANTITY, wbpi.SCRAp_QUANTITY) =
2940: ( select wit.total_quantity, wit.scrap_quantity
2941: from wip_bis_yld_temp wit
2942: where wit.organization_id = wbpi.organization_id
2943: and wit.wip_entity_id = wbpi.wip_entity_id
2944: and wit.operation_seq_num = wbpi.operation_seq_num
2945: and wit.department_id = wbpi.department_id

Line 3047: from wip_bis_yld_temp wit

3043:
3044: update wip_bis_prod_indicators wbpi
3045: set (wbpi.total_quantity, wbpi.scrap_quantity) =
3046: ( select wit.total_quantity, wit.scrap_quantity
3047: from wip_bis_yld_temp wit
3048: where wit.organization_id = wbpi.organization_id
3049: and wit.wip_entity_id = wbpi.wip_entity_id
3050: and wit.operation_seq_num = wbpi.operation_seq_num
3051: and wit.department_id = wbpi.department_id

Line 3116: wip_bis_yld_temp wit

3112: wit.request_id,
3113: wit.program_application_id,
3114: sysdate
3115: from wip_entities we,
3116: wip_bis_yld_temp wit
3117: where we.wip_entity_id = wit.wip_entity_id
3118: and we.organization_id = wit.organization_id
3119: and wit.indicator_type = WIP_YIELD
3120: and wit.process_phase = WIP_RES_YIELD

Line 3253: wip_bis_yld_temp wit

3249: wit.request_id,
3250: wit.program_application_id,
3251: sysdate
3252: FROM wip_entities we,
3253: wip_bis_yld_temp wit
3254: WHERE we.wip_entity_id = wit.wip_entity_id
3255: AND we.organization_id = wit.organization_id
3256: AND wit.indicator_type = WIP_YIELD
3257: AND wit.process_phase = WIP_DEPT_YIELD;

Line 3631: '.WIP_BIS_YLD_TEMP';

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:
3633: IF g_debug = 1 THEN
3634: fnd_file.put_line(fnd_file.log, 'After Stage 9 Phase I');
3635: END IF ;

Line 3733: '.WIP_BIS_YLD_TEMP';

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:
3735:
3736: p_errnum := 0;
3737: p_errmesg := '';

Line 6137: wip_bis_yld_temp wit3,

6133: wit.request_id,
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