[Home] [Help]
416: -- truncate the Log table
417: l_stmt_num := 10;
418: IF truncate_table
419: ( l_isc_schema
420: , 'ISC_FS_INV_USG_LOG'
421: , l_err_msg ) <> 0 THEN
422: LOGGER( l_proc_name, l_stmt_num, l_err_msg );
423: RAISE l_exception;
424: END IF;
429: be extracted. We will access OPI_DBI_CONC_PROG_RUN_LOG to obtain these upper boundaries. The
430: incremental load will use these boundaries as starting points. */
431:
432: l_stmt_num := 20;
433: INSERT INTO ISC_FS_INV_USG_LOG
434: (
435: ORGANIZATION_ID
436: ,FROM_TRANSACTION_ID
437: ,TO_TRANSACTION_ID
599: and cpp.forecast_rule_id is not null) /* Do not include subinventories that
600: have forecast rules defined */
601: ) sec
602: ,mtl_material_transactions mmt
603: ,ISC_FS_INV_USG_LOG bound /* Obtain the transaction boundaries from our log table */
604: ,mtl_transaction_accounts mta
605: WHERE
606: mmt.organization_id = sec.organization_id
607: and mmt.SUBINVENTORY_CODE = sec.SECONDARY_INVENTORY_NAME
806: stores the lower transaction id. At the end of the collection we will swith the from and
807: to boundaries.) */
808:
809: l_stmt_num := 5;
810: MERGE INTO ISC_FS_INV_USG_LOG bivlog USING
811: (
812: /* This select statement has changed due to OPI changes in its Boundaries log table */
813: SELECT
814: from_to_txn.BOUND_LEVEL_ENTITY_ID organization_id
965: and cpp.forecast_rule_id is not null) /* Do not include subinventories that
966: have forecast rules defined */
967: ) sec,
968: mtl_material_transactions mmt
969: ,ISC_FS_INV_USG_LOG bound /* Obtain the transaction boundaries from our log table */
970: WHERE
971: mmt.organization_id = sec.organization_id
972: AND mmt.SUBINVENTORY_CODE = sec.SECONDARY_INVENTORY_NAME
973: AND mmt.TRANSACTION_ACTION_ID = sec.TRANSACTION_ACTION_ID
1118:
1119: BIS_COLLECTION_UTILITIES.LOG( 'Currency conversion table truncated', 1 );
1120:
1121: l_stmt_num := 90;
1122: UPDATE ISC_FS_INV_USG_LOG
1123: SET from_transaction_id = to_transaction_id,to_transaction_id = from_transaction_id;
1124:
1125: COMMIT;
1126: