DBA Data[Home] [Help]

APPS.OKC_XPRT_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 7817: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;

7813:
7814: j BINARY_INTEGER :=0;
7815: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
7816: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
7817: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
7818: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
7819:
7820: l_article_id NUMBER;
7821: l_article_version_id NUMBER;

Line 7818: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;

7814: j BINARY_INTEGER :=0;
7815: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
7816: l_rule_description okc_xprt_rule_hdrs_all.rule_description%TYPE;
7817: l_item_name MTL_SYSTEM_ITEMS_VL.concatenated_segments%TYPE;
7818: l_item_description MTL_SYSTEM_ITEMS_VL.description%TYPE;
7819:
7820: l_article_id NUMBER;
7821: l_article_version_id NUMBER;
7822: l_article_title VARCHAR2(2000);

Line 7849: FROM mtl_system_items_vl

7845: --
7846: CURSOR l_get_item_details_csr (p_item_id NUMBER, p_org_id NUMBER) IS
7847: SELECT concatenated_segments,
7848: description
7849: FROM mtl_system_items_vl
7850: WHERE inventory_item_id = p_item_id
7851: AND organization_id = p_org_id;
7852:
7853: --