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.GMF_MIGRATION dependencies on IC_CLDR_DTL

Line 8894: ic_cldr_dtl b,

8890: c.period_id prior_period_id,
8891: c.period_end_date prior_period_end_date,
8892: c.closed_period_ind prior_period_closed_ind
8893: FROM sy_orgn_mst a,
8894: ic_cldr_dtl b,
8895: ic_cldr_dtl c,
8896: org_acct_periods d,
8897: hr_organization_information hoi,
8898: ic_whse_mst e,

Line 8895: ic_cldr_dtl c,

8891: c.period_end_date prior_period_end_date,
8892: c.closed_period_ind prior_period_closed_ind
8893: FROM sy_orgn_mst a,
8894: ic_cldr_dtl b,
8895: ic_cldr_dtl c,
8896: org_acct_periods d,
8897: hr_organization_information hoi,
8898: ic_whse_mst e,
8899: gl_ledgers f

Line 8912: FROM ic_cldr_dtl x

8908: AND c.period_end_date = d.schedule_close_date
8909: AND nvl(c.closed_period_ind, 1) = 3
8910: AND b.period_end_date = (
8911: SELECT MIN(x.period_end_date)
8912: FROM ic_cldr_dtl x
8913: WHERE a.orgn_code = x.orgn_code
8914: AND SYSDATE < x.period_end_date
8915: )
8916: AND c.period_end_date = (

Line 8918: FROM ic_cldr_dtl y

8914: AND SYSDATE < x.period_end_date
8915: )
8916: AND c.period_end_date = (
8917: SELECT MAX(y.period_end_date)
8918: FROM ic_cldr_dtl y
8919: WHERE a.orgn_code = y.orgn_code
8920: AND SYSDATE > y.period_end_Date
8921: );
8922: