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.PO_VAL_LINES2 dependencies on MTL_CATEGORIES

Line 1691: FROM mtl_item_categories mic, mtl_categories mcs

1687: AND p_item_id_tbl(i) IS NOT NULL
1688: AND p_category_id_tbl(i) IS NOT NULL
1689: AND NOT EXISTS(
1690: SELECT 1
1691: FROM mtl_item_categories mic, mtl_categories mcs
1692: WHERE mic.category_id = mcs.category_id
1693: AND mic.category_set_id = x_category_set_id
1694: AND mic.category_id = p_category_id_tbl(i)
1695: AND mic.inventory_item_id = p_item_id_tbl(i)

Line 1733: FROM mtl_categories_vl mcs, mtl_category_set_valid_cats mcsvc

1729: AND p_item_id_tbl(i) IS NULL
1730: AND p_category_id_tbl(i) IS NOT NULL
1731: AND NOT EXISTS(
1732: SELECT 'Y'
1733: FROM mtl_categories_vl mcs, mtl_category_set_valid_cats mcsvc
1734: WHERE mcs.category_id = p_category_id_tbl(i)
1735: AND mcs.category_id = mcsvc.category_id
1736: AND mcsvc.category_set_id = x_category_set_id
1737: AND SYSDATE < NVL(mcs.disable_date, SYSDATE + 1)

Line 1774: FROM mtl_categories_vl mcs

1770: AND p_item_id_tbl(i) IS NULL
1771: AND p_category_id_tbl(i) IS NOT NULL
1772: AND NOT EXISTS(
1773: SELECT 1
1774: FROM mtl_categories_vl mcs
1775: WHERE mcs.category_id = p_category_id_tbl(i)
1776: AND SYSDATE < NVL(mcs.disable_date, SYSDATE + 1)
1777: AND mcs.enabled_flag = 'Y');
1778: