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.ICX_CAT_FPI_UPGRADE dependencies on GL_SETS_OF_BOOKS

Line 1803: gl_sets_of_books gsb,

1799: gUpgradeUserId, sysdate, gUpgradeUserId,
1800: gUpgradeUserId, gUpgradeUserId, sysdate
1801: FROM icx_cat_item_prices p,
1802: mtl_system_items_kfv mi,
1803: gl_sets_of_books gsb,
1804: financials_system_params_all fsp,
1805: mtl_units_of_measure_tl muom
1806: WHERE p.inventory_item_id = mi.inventory_item_id
1807: AND p.org_id = fsp.org_id

Line 1954: gl_sets_of_books gsb,

1950: gUpgradeUserId, sysdate, gUpgradePhaseId,
1951: gUpgradeUserId, gUpgradeUserId, sysdate
1952: FROM mtl_system_items_kfv mi,
1953: mtl_item_categories mic,
1954: gl_sets_of_books gsb,
1955: financials_system_params_all fsp,
1956: --Bug#3581356
1957: --Since categories are already upgraded,
1958: --so join with icx_cat_categories_tl to get the valid category

Line 1967: --Add the join between gl_sets_of_books and

1963: AND mi.inventory_item_id = mic.inventory_item_id
1964: AND mic.organization_id = mi.organization_id
1965: --Bug#3581356
1966: --Join with icx_cat_categories_tl to get the valid category
1967: --Add the join between gl_sets_of_books and
1968: --financials_system_params_all
1969: AND fsp.set_of_books_id = gsb.set_of_books_id
1970: AND ictl.key = to_char(mic.category_id)
1971: AND ictl.language = xLanguage