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 4276: select 1 into cnt from MSC_CURRENCY_CONVERSIONS

4272:
4273: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4274:
4275: Begin
4276: select 1 into cnt from MSC_CURRENCY_CONVERSIONS
4277: where (to_currency = MSC_CL_OTHER_PULL.G_MSC_HUB_CURR_CODE and
4278: conv_type = MSC_CL_OTHER_PULL.G_MSC_CURR_CONV_TYPE)
4279: and rownum < 2;
4280:

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

4285: end;
4286:
4287:
4288: If (cnt = 0) then
4289: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CURRENCY_CONVERSIONS');
4290: End if;
4291:
4292:
4293: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc

Line 4293: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc

4289: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE('MSC_CURRENCY_CONVERSIONS');
4290: End if;
4291:
4292:
4293: MERGE INTO MSC_CURRENCY_CONVERSIONS mcc
4294: USING (Select * from MSC_ST_CURRENCY_CONVERSIONS where sr_instance_id = MSC_CL_COLLECTION.v_instance_id) mst
4295: ON (mcc.from_currency = mst.from_currency
4296: AND mcc.to_currency = mst.to_currency
4297: AND mcc.conv_date = mst.conv_date

Line 4512: Delete from MSC_CURRENCY_CONVERSIONS

4508:
4509: v_pbs := TO_NUMBER(FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
4510:
4511: Loop
4512: Delete from MSC_CURRENCY_CONVERSIONS
4513: where conv_date > (sysdate + MSC_CL_OTHER_PULL.G_MSC_FUTURE_DAYS) or conv_date < (sysdate - MSC_CL_OTHER_PULL.G_MSC_PAST_DAYS)
4514: And rownum < v_pbs;
4515: Exit when sql%rowcount = 0;
4516: