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.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_CURRENCY_CONVERSIONS

Line 4414: select 1 into cnt from MSC_CURRENCY_CONVERSIONS

4410:
4411: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4412:
4413: Begin
4414: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4415: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4416: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4417: and rownum < 2;
4418:

Line 4427: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CURRENCY_CONVERSIONS');

4423: end;
4424:
4425:
4426: If (cnt = 0) then
4427: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CURRENCY_CONVERSIONS');
4428: End if;
4429:
4430:
4431: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc

Line 4431: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc

4427: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CURRENCY_CONVERSIONS');
4428: End if;
4429:
4430:
4431: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc
4432: USING (Select * from MSC_ST_CURRENCY_CONVERSIONS where sr_instance_id = MSC_CL_COLLECTION.v_instance_id) mst
4433: ON (mcc.from_currency = mst.from_currency
4434: AND mcc.to_currency = mst.to_currency
4435: AND mcc.conv_date = mst.conv_date

Line 5970: Delete from MSC_CURRENCY_CONVERSIONS

5966:
5967: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
5968:
5969: Loop
5970: Delete from MSC_CURRENCY_CONVERSIONS
5971: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)
5972: And rownum < v_pbs;
5973: Exit when sql%rowcount = 0;
5974: