6402: FROM wip_bis_prod_indicators
6403: WHERE transaction_date < trunc (p_max_backup_date);
6404:
6405:
6406: INSERT INTO wip_bis_prod_assy_yield_temp (
6407: organization_id,
6408: wip_entity_id,
6409: inventory_item_id,
6410: transaction_date,
6833: period_set_name,
6834: year,
6835: quarter,
6836: month
6837: FROM wip_bis_prod_assy_yield_temp;
6838:
6839: INSERT INTO wip_bis_prod_dept_yield (
6840: organization_id,
6841: wip_entity_id,
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;
6970: p_errmesg := '';
6971: