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.FII_RECONVERSION_PKG dependencies on FII_AR_REVENUE_B

Line 926: -- FII_AR_REVENUE_B within the passed date range and they are not yet cached

922: 'FII_RECONV_CACHE_RATE_STEP', NULL
923: , 'PROD_NAME', p_ar_name));
924:
925: -- Insert rates to FII_RECONV_RATES based on the transactions of
926: -- FII_AR_REVENUE_B within the passed date range and they are not yet cached
927: INSERT INTO FII_RECONV_RATES
928: ( REQUEST_ID, RATE_DATE_ID, RATE_DATE, FROM_CURRENCY
929: , PRIMARY_RATE, SECONDARY_RATE)
930: (SELECT DISTINCT

Line 941: FROM FII_AR_REVENUE_B ar

937: , t.report_date, p_secondary_rate_type))
938: FROM FII_TIME_DAY t, GL_LEDGERS_PUBLIC_V sob
939: WHERE t.report_date_julian BETWEEN p_from_date_id and p_to_date_id
940: AND EXISTS (SELECT /*+ parallel(ar) */ 'This date has AR transaction'
941: FROM FII_AR_REVENUE_B ar
942: WHERE ar.gl_date_id = t.report_date_julian
943: AND ar.ledger_id = sob.ledger_id)
944: AND NOT EXISTS (SELECT 'This rate has been cached'
945: FROM FII_RECONV_RATES r

Line 1978: -- It will reconvert global amounts for the AR base table FII_AR_REVENUE_B.

1974: -- PROCEDURE
1975: -- reconvert_ar()
1976: --
1977: -- DESCRIPTION:
1978: -- It will reconvert global amounts for the AR base table FII_AR_REVENUE_B.
1979: PROCEDURE reconvert_ar( errbuf IN OUT NOCOPY VARCHAR2
1980: , retcode IN OUT NOCOPY VARCHAR2
1981: , p_request_id IN NUMBER
1982: , p_user_id IN NUMBER

Line 2020: -- 5.2 Update FII_AR_REVENUE_B for the different reconverted global amounts

2016: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
2017: , 'PROD_NAME', p_product_name));
2018:
2019: --
2020: -- 5.2 Update FII_AR_REVENUE_B for the different reconverted global amounts
2021: --
2022: l_process_step := 'UPDATE_AR_B';
2023: UPDATE /*+ parallel(ar) */ FII_AR_REVENUE_B ar
2024: SET ( PRIM_AMOUNT_G, SEC_AMOUNT_G, LAST_UPDATE_DATE

Line 2023: UPDATE /+ parallel(ar) / FII_AR_REVENUE_B ar