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 8949: * (i.e ic_cldr_dtl) are maintained at Company level (and not *

8945: * It is observed that cursor "cur_orgn_periods" is fetching *
8946: * only warehouses under Orgn_codes which are same as co_code *
8947: * and is missing remaining warehouses under other orgn_codes *
8948: * witin the company. In 11i, as OPM inventory calendar periods *
8949: * (i.e ic_cldr_dtl) are maintained at Company level (and not *
8950: * at warehouse/orgn level), ic_cldr_dtl.orgn_code points to *
8951: * co_code. Hence Modified CURSOR cur_orgn_periods to join *
8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *
8953: * identifies all the organizations under the company and thus *

Line 8950: * at warehouse/orgn level), ic_cldr_dtl.orgn_code points to *

8946: * only warehouses under Orgn_codes which are same as co_code *
8947: * and is missing remaining warehouses under other orgn_codes *
8948: * witin the company. In 11i, as OPM inventory calendar periods *
8949: * (i.e ic_cldr_dtl) are maintained at Company level (and not *
8950: * at warehouse/orgn level), ic_cldr_dtl.orgn_code points to *
8951: * co_code. Hence Modified CURSOR cur_orgn_periods to join *
8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *
8953: * identifies all the organizations under the company and thus *
8954: * fetches all the warehouses under that company. *

Line 8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *

8948: * witin the company. In 11i, as OPM inventory calendar periods *
8949: * (i.e ic_cldr_dtl) are maintained at Company level (and not *
8950: * at warehouse/orgn level), ic_cldr_dtl.orgn_code points to *
8951: * co_code. Hence Modified CURSOR cur_orgn_periods to join *
8952: * ic_cldr_dtl.orgn_code to sy_orgn_mst.co_code, so that it *
8953: * identifies all the organizations under the company and thus *
8954: * fetches all the warehouses under that company. *
8955: * *
8956: * 11-Apr-2012 Uday Phadtare Bug 13942118. *

Line 9004: ic_cldr_dtl b,

9000: c.closed_period_ind prior_period_closed_ind,
9001: c.fiscal_year prior_fiscal_year, /* Bug 13045530 */
9002: c.period prior_period /* Bug 13045530 */
9003: FROM sy_orgn_mst a,
9004: ic_cldr_dtl b,
9005: ic_cldr_dtl c,
9006: org_acct_periods d,
9007: hr_organization_information hoi,
9008: ic_whse_mst e,

Line 9005: ic_cldr_dtl c,

9001: c.fiscal_year prior_fiscal_year, /* Bug 13045530 */
9002: c.period prior_period /* Bug 13045530 */
9003: FROM sy_orgn_mst a,
9004: ic_cldr_dtl b,
9005: ic_cldr_dtl c,
9006: org_acct_periods d,
9007: hr_organization_information hoi,
9008: ic_whse_mst e,
9009: gl_ledgers f

Line 9022: FROM ic_cldr_dtl x

9018: AND c.period_end_date = d.schedule_close_date
9019: AND nvl(c.closed_period_ind, 1) = 3
9020: AND b.period_end_date = (
9021: SELECT MIN(x.period_end_date)
9022: FROM ic_cldr_dtl x
9023: --WHERE a.orgn_code = x.orgn_code
9024: WHERE a.co_code = x.orgn_code -- Modified where condition as pr bug # 12372491
9025: AND SYSDATE < x.period_end_date
9026: )

Line 9029: FROM ic_cldr_dtl y

9025: AND SYSDATE < x.period_end_date
9026: )
9027: AND c.period_end_date = (
9028: SELECT MAX(y.period_end_date)
9029: FROM ic_cldr_dtl y
9030: --WHERE a.orgn_code = y.orgn_code
9031: WHERE a.co_code = y.orgn_code -- Modified where condition as pr bug # 12372491
9032: AND SYSDATE > y.period_end_Date
9033: );