DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on WIP_BIS_PROD_INDICATORS_TEMP

Line 6304: INSERT INTO wip_bis_prod_indicators_temp (

6300: END IF;
6301:
6302: -- simply back up the entire summary tables
6303:
6304: INSERT INTO wip_bis_prod_indicators_temp (
6305: organization_id,
6306: wip_entity_id,
6307: inventory_item_id,
6308: operation_seq_num,

Line 6758: FROM wip_bis_prod_indicators_temp;

6754: quarter,
6755: month,
6756: indicator_type,
6757: share_from_dept_id
6758: FROM wip_bis_prod_indicators_temp;
6759:
6760: INSERT INTO wip_bis_prod_assy_yield (
6761: organization_id,
6762: wip_entity_id,

Line 6963: '.WIP_BIS_PROD_INDICATORS_TEMP';

6959:
6960: BEGIN
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';