DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on WIP_BIS_PROD_DEPT_YIELD_TEMP

Line 6487: INSERT INTO wip_bis_prod_dept_yield_temp (

6483: FROM wip_bis_prod_assy_yield
6484: WHERE transaction_date < trunc (p_max_backup_date);
6485:
6486:
6487: INSERT INTO wip_bis_prod_dept_yield_temp (
6488: organization_id,
6489: wip_entity_id,
6490: inventory_item_id,
6491: operation_seq_num,

Line 6916: FROM wip_bis_prod_dept_yield_temp;

6912: period_set_name,
6913: year,
6914: quarter,
6915: month
6916: FROM wip_bis_prod_dept_yield_temp;
6917:
6918: p_errnum := 0;
6919: p_errmesg := '';
6920:

Line 6965: '.WIP_BIS_PROD_DEPT_YIELD_TEMP';

6961: proc_name := 'clear_temp_summary_tables';
6962: execute immediate 'truncate table ' || g_wip_schema ||
6963: '.WIP_BIS_PROD_INDICATORS_TEMP';
6964: execute immediate 'truncate table ' || g_wip_schema ||
6965: '.WIP_BIS_PROD_DEPT_YIELD_TEMP';
6966: execute immediate 'truncate table ' || g_wip_schema ||
6967: '.WIP_BIS_PROD_ASSY_YIELD_TEMP';
6968:
6969: p_errnum := 0;