eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENI_DBI_UCO_LOAD_PKG dependencies on BIS_REFRESH_LOG

Line 341: Store the max transaction_id from mmt into bis_refresh_log table

337: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
338: COMMIT;
339:
340: /* Bug: 4956685
341: Store the max transaction_id from mmt into bis_refresh_log table
342: We are simply picking the max transaction id as the end date is defaulted
343: to SYSDATE now and the mmt table rows are not updated once inserted.
344: */
345: SELECT Max(TRANSACTION_ID)

Line 350: Store the max cost_update_id from cec into bis_refresh_log table

346: INTO l_processed_txn_id
347: FROM MTL_MATERIAL_TRANSACTIONS mmt;
348:
349: /* Bug: 4936377
350: Store the max cost_update_id from cec into bis_refresh_log table
351: We are simply picking the max cost update id as the end date is defaulted
352: to SYSDATE now and the cec table rows are not updated once inserted.
353: */
354: SELECT Max(COST_UPDATE_ID)

Line 586: Fetch the last Processed transaction id and cost update id from bis refresh log table.

582:
583: l_last_run_to_date_char := BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f');
584: l_last_run_to_date := trunc(fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f')));
585: /** Bug: 4956685, 4936377
586: Fetch the last Processed transaction id and cost update id from bis refresh log table.
587: **/
588: SELECT MAX(decode(brl.attribute1,'mtl_material_transactions',attribute2,NULL))
589: ,MAX(decode(brl.attribute3,'cst_elemental_costs' ,attribute4,NULL))
590: INTO l_processed_txn_id, l_processed_cost_id

Line 591: FROM bis_refresh_log brl

587: **/
588: SELECT MAX(decode(brl.attribute1,'mtl_material_transactions',attribute2,NULL))
589: ,MAX(decode(brl.attribute3,'cst_elemental_costs' ,attribute4,NULL))
590: INTO l_processed_txn_id, l_processed_cost_id
591: FROM bis_refresh_log brl
592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');

Line 596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);

592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');

Line 597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);

593:
594: eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
595: eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
596: eni_dbi_util_pkg.log('Last processed transaction_id from mtl_material_transactions table as stored in bis_refresh_log table is:' || l_processed_txn_id);
597: eni_dbi_util_pkg.log('Last processed cost update_id from cst_elemental_costs table as stored in bis_refresh_log table is:' || l_processed_cost_id);
598:
599: --eni_dbi_util_pkg.log('End Period of last cost collection was ' || to_char(l_last_run_to_date));
600: --eni_dbi_util_pkg.log('Incremental cost collection will collect records on and after the above date');
601: select FND_GLOBAL.USER_ID

Line 715: Bug: 4936377 If the last Processed cost id cannot be queried from bis_refresh_log table compute it

711: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting incremental cost collection for them');
712:
713: -- Inserting the changed records into stage
714: /**
715: Bug: 4936377 If the last Processed cost id cannot be queried from bis_refresh_log table compute it
716: from cec table.
717: **/
718: IF l_processed_cost_id IS NULL THEN
719: SELECT NVL( MAX( cost_update_id), 0)

Line 792: Bug: 4956685 If the last Processed txn id cannot be queried from bis_refresh_log table compute it

788: eni_dbi_util_pkg.log('There are Avg/LIFO/FIFO Costing orgs, hence starting incremental cost collection for them');
789:
790: -- Inserting the changed records into stage
791: /**
792: Bug: 4956685 If the last Processed txn id cannot be queried from bis_refresh_log table compute it
793: from mmt table.
794: **/
795: IF l_processed_txn_id IS NULL THEN
796: SELECT NVL( MAX( transaction_id), 0)