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 CST_ELEMENTAL_COSTS

Line 148: -- Get the cost history for standard costing orgs from cst_elemental_costs

144: select FND_GLOBAL.USER_ID
145: into l_application_user_id
146: from sys.dual;
147:
148: -- Get the cost history for standard costing orgs from cst_elemental_costs
149: if (l_exists_sc_orgs = 1) then
150: eni_dbi_util_pkg.log('There are Standard Costing orgs, hence starting initial cost collection into stage table for them');
151:
152: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a

Line 195: from cst_elemental_costs cec,

191: cec.cost_element_id,
192: cec.standard_cost,
193: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
194: gsob.currency_code order by cec.cost_update_id desc) r
195: from cst_elemental_costs cec,
196: hr_organization_information hoi,
197: gl_sets_of_books gsob
198: where cec.organization_id = hoi.organization_id
199: and hoi.org_information_context = 'Accounting Information'

Line 356: FROM cst_elemental_costs cec;

352: to SYSDATE now and the cec table rows are not updated once inserted.
353: */
354: SELECT Max(COST_UPDATE_ID)
355: INTO l_processed_cost_id
356: FROM cst_elemental_costs cec;
357:
358: BIS_COLLECTION_UTILITIES.WRAPUP(
359: p_status => true,
360: p_period_from => l_start_date,

Line 364: p_attribute3 => 'cst_elemental_costs',

360: p_period_from => l_start_date,
361: p_period_to => l_end_date,
362: p_attribute1 => 'mtl_material_transactions',
363: p_attribute2 => l_processed_txn_id,
364: p_attribute3 => 'cst_elemental_costs',
365: p_attribute4 => l_processed_cost_id
366: );
367:
368: ELSE

Line 589: ,MAX(decode(brl.attribute3,'cst_elemental_costs' ,attribute4,NULL))

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
591: FROM bis_refresh_log brl
592: WHERE brl.object_name = 'eni_dbi_item_cost_f';
593:

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 709: -- Get the cost history for standard costing orgs from cst_elemental_costs

705: from mtl_parameters
706: where primary_cost_method <> 1
707: );
708:
709: -- Get the cost history for standard costing orgs from cst_elemental_costs
710: if (l_exists_sc_orgs = 1) then
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

Line 721: FROM cst_elemental_costs cec

717: **/
718: IF l_processed_cost_id IS NULL THEN
719: SELECT NVL( MAX( cost_update_id), 0)
720: INTO l_processed_cost_id
721: FROM cst_elemental_costs cec
722: WHERE cec.last_update_date < l_last_run_to_date;
723: END IF; -- l_processed_cost_id
724:
725: eni_dbi_util_pkg.log('Processing cst_elemental_costs.cost_update_id greater than ' || l_processed_cost_id);

Line 725: eni_dbi_util_pkg.log('Processing cst_elemental_costs.cost_update_id greater than ' || l_processed_cost_id);

721: FROM cst_elemental_costs cec
722: WHERE cec.last_update_date < l_last_run_to_date;
723: END IF; -- l_processed_cost_id
724:
725: eni_dbi_util_pkg.log('Processing cst_elemental_costs.cost_update_id greater than ' || l_processed_cost_id);
726:
727: insert /*+ append parallel(a) */ into eni_dbi_item_cost_stg a
728: (effective_date,
729: inventory_item_id,

Line 770: from cst_elemental_costs cec,

766: cec.cost_element_id,
767: cec.standard_cost,
768: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
769: gsob.currency_code order by cec.cost_update_id desc) r
770: from cst_elemental_costs cec,
771: hr_organization_information hoi,
772: gl_sets_of_books gsob
773: where cec.organization_id = hoi.organization_id
774: and hoi.org_information_context = 'Accounting Information'

Line 968: FROM cst_elemental_costs;

964:
965: --Bug: 4936377 Query the max cost update id from cec table
966: SELECT Max(COST_UPDATE_ID)
967: INTO l_processed_cost_id
968: FROM cst_elemental_costs;
969:
970: BIS_COLLECTION_UTILITIES.WRAPUP(
971: p_status => true,
972: p_period_from => l_last_run_to_date,

Line 976: p_attribute3 => 'cst_elemental_costs',

972: p_period_from => l_last_run_to_date,
973: p_period_to => sysdate,
974: p_attribute1 => 'mtl_material_transactions',
975: p_attribute2 => l_processed_txn_id,
976: p_attribute3 => 'cst_elemental_costs',
977: p_attribute4 => l_processed_cost_id
978: );
979: --execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_dbi_item_cost_stg';
980: --execute immediate 'TRUNCATE TABLE '||g_eni_schema||'.eni_currency_conv_rates_stg';