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 ENI_DBI_ITEM_COST_F

Line 102: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_f';

98: THEN NULL;
99: END IF;
100:
101: eni_dbi_util_pkg.log('Truncating the cost staging, rates staging and cost fact tables');
102: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_f';
103: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
104: execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';
105:
106: l_start_date := trunc (bis_common_parameters.get_global_start_date);

Line 116: p_object_name => 'eni_dbi_item_cost_f',

112: **/
113: eni_dbi_util_pkg.log('The date range for Initial cost collection is ' || l_start_date || ' to ' || l_end_date);
114:
115: if BIS_COLLECTION_UTILITIES.SETUP(
116: p_object_name => 'eni_dbi_item_cost_f',
117: p_parallel => 1) = false then
118: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
119: end if;
120:

Line 292: insert /+ append parallel(a) / into eni_dbi_item_cost_f a

288: l_report_missing_rate := report_missing_rate();
289:
290: IF (l_report_missing_rate = 0) THEN -- initial collection completed normally.
291:
292: insert /*+ append parallel(a) */ into eni_dbi_item_cost_f a
293: (effective_date,
294: inventory_item_id,
295: organization_id,
296: item_cost,

Line 578: p_object_name => 'eni_dbi_item_cost_f',

574: END IF;
575:
576:
577: if BIS_COLLECTION_UTILITIES.SETUP(
578: p_object_name => 'eni_dbi_item_cost_f',
579: p_parallel => 1) = false then
580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;
582:

Line 583: l_last_run_to_date_char := BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f');

579: p_parallel => 1) = false then
580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;
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: **/

Line 584: l_last_run_to_date := trunc(fnd_date.displayDT_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('eni_dbi_item_cost_f')));

580: RAISE_APPLICATION_ERROR(-20000,o_error_msg);
581: end if;
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))

Line 592: WHERE brl.object_name = 'eni_dbi_item_cost_f';

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');
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);

Line 627: insert into /+ append parallel(a) +/ eni_dbi_item_cost_f

623:
624: l_report_missing_Rate := report_missing_rate();
625:
626: IF (l_report_missing_rate = 0) THEN -- initial collection completed normally.
627: insert into /*+ append parallel(a) +*/ eni_dbi_item_cost_f
628: (effective_date,
629: inventory_item_id,
630: organization_id,
631: item_cost,

Line 878: merge into eni_dbi_item_cost_f old_costs

874:
875: eni_dbi_util_pkg.log('Checking if any missing conversion rates are present');
876: l_report_missing_rate := report_missing_rate();
877: IF (l_report_missing_rate = 0) THEN -- initial collection completed normally.
878: merge into eni_dbi_item_cost_f old_costs
879: using
880: (select
881: edicstg.effective_date,
882: edicstg.inventory_item_id,