DBA Data[Home] [Help]

APPS.INV_INVISMMX_XMLP_PKG dependencies on MTL_CATEGORY_SETS

Line 99: MTL_CATEGORY_SETS

95: SELECT
96: STRUCTURE_ID
97: INTO P_MCAT_STRUCT
98: FROM
99: MTL_CATEGORY_SETS
100: WHERE CATEGORY_SET_ID = P_CAT_SET_ID;
101: ELSE
102: SELECT
103: CSET.CATEGORY_SET_ID,

Line 107: MTL_CATEGORY_SETS CSET,

103: CSET.CATEGORY_SET_ID,
104: CSET.STRUCTURE_ID
105: INTO P_CAT_SET_ID,P_MCAT_STRUCT
106: FROM
107: MTL_CATEGORY_SETS CSET,
108: MTL_DEFAULT_CATEGORY_SETS DEF
109: WHERE DEF.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID
110: AND DEF.FUNCTIONAL_AREA_ID = 1;
111: END IF;

Line 234: MTL_CATEGORY_SETS

230: SELECT
231: CATEGORY_SET_NAME
232: INTO P_CSET_TEXT
233: FROM
234: MTL_CATEGORY_SETS
235: WHERE CATEGORY_SET_ID = P_CAT_SET_ID;
236: SELECT
237: MEANING
238: INTO P_YES_TEXT