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.OKC_XPRT_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 8144: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;

8140:
8141: j BINARY_INTEGER :=0;
8142: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
8143: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
8144: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
8145: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
8146:
8147: l_article_id NUMBER;
8148: l_article_version_id NUMBER;

Line 8145: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;

8141: j BINARY_INTEGER :=0;
8142: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
8143: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
8144: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
8145: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
8146:
8147: l_article_id NUMBER;
8148: l_article_version_id NUMBER;
8149: l_article_title VARCHAR2(2000);

Line 8176: FROM mtl_system_items_vl

8172: --
8173: CURSOR l_get_item_details_csr (p_item_id NUMBER, p_org_id NUMBER) IS
8174: SELECT concatenated_segments,
8175: description
8176: FROM mtl_system_items_vl
8177: WHERE inventory_item_id = p_item_id
8178: AND organization_id = p_org_id;
8179:
8180: --