DBA Data[Home] [Help]

APPS.QA_ERES_PKG dependencies on MTL_CATEGORY_SETS_B

Line 60: FROM mtl_categories_kfv MCK, MTL_CATEGORY_SETS_B CSET

56: IS
57: x_name varchar2(240) := null;
58: CURSOR c IS
59: SELECT MCK.concatenated_segments
60: FROM mtl_categories_kfv MCK, MTL_CATEGORY_SETS_B CSET
61: WHERE CSET.CATEGORY_SET_ID = p_category_set_id AND
62: MCK.STRUCTURE_ID = CSET.STRUCTURE_ID AND
63: MCK.CATEGORY_ID = p_category_id;
64: BEGIN

Line 78: FROM mtl_categories_vl MCK, MTL_CATEGORY_SETS_B CSET

74: IS
75: l_desc varchar2(240) := null;
76: CURSOR c IS
77: SELECT MCK.description
78: FROM mtl_categories_vl MCK, MTL_CATEGORY_SETS_B CSET
79: WHERE CSET.CATEGORY_SET_ID = p_category_set_id AND
80: MCK.STRUCTURE_ID = CSET.STRUCTURE_ID AND
81: MCK.CATEGORY_ID = p_category_id;
82: BEGIN