430:
431: /* Insert MMT data into staging */
432: l_stmt_num := 20;
433:
434: INSERT /*+ APPEND parallel(stg) */ INTO OPI_DBI_JOBS_TXN_MMT_STG stg
435: (transaction_id
436: , organization_id
437: , inventory_item_id
438: , transaction_date
724: 31,2,
725: 32,2,
726: 30,3) ETL_TYPE_ID
727: from
728: OPI_DBI_JOBS_TXN_MMT_STG mmt,
729: mtl_material_txn_allocations mmta,
730: mtl_system_items_b msi,
731: OPI_DBI_RUN_LOG_CURR log
732: where
1202: gtv.transaction_date,
1203: gtv.accounted_flag
1204: ) GTV,
1205: GME_MATERIAL_DETAILS MTL_DTL,
1206: OPI_DBI_JOBS_TXN_MMT_STG MMT_STG,
1207: mtl_system_items_b msi
1208: where
1209: GTV.organization_id = MTL_DTL.organization_id and
1210: GTV.doc_id = MTL_DTL.batch_id and
4008: --{
4009: --execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';
4010: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOB_MTL_STD_QTY_TMP';
4011: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_STG';
4012: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_TXN_MMT_STG';
4013: execute immediate 'truncate table ' || l_opi_schema || '.opi_dbi_muv_conv_rates';
4014: --}
4015: END IF;
4016: