APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on MTL_CATEGORIES_KFV

Line 131: MTL_CATEGORIES_KFV MCV,

127: SELECT
128: MIN(TO_CHAR(MCV.CATEGORY_ID))
129: INTO P_CATEGORY_ID
130: FROM
131: MTL_CATEGORIES_KFV MCV,
132: MTL_CATEGORY_SETS MCS
133: WHERE SUBSTRB(MCV.CONCATENATED_SEGMENTS
134: ,1
135: ,2000) = P_CATEGORY_ID

Line 349: MTL_CATEGORIES_KFV MCV

345: ,1
346: ,2000)
347: INTO P_CATEGORY_NAME
348: FROM
349: MTL_CATEGORIES_KFV MCV
350: WHERE CATEGORY_ID = TO_NUMBER(P_CATEGORY_ID);
351: P_CATEGORY_FROM := P_CATEGORY_NAME;
352: P_CATEGORY_TO := P_CATEGORY_NAME;
353: END IF;

Line 493: MTL_CATEGORIES_KFV MCV,

489: FROM
490: MTL_ITEM_CATEGORIES MIC,
491: MTL_SYSTEM_ITEMS MSI,
492: BOM_PARAMETERS BP,
493: MTL_CATEGORIES_KFV MCV,
494: CST_ITEM_COSTS CIC,
495: MTL_PARAMETERS MP
496: WHERE LP_ORGANIZATION_ID is not null
497: AND MIC.ORGANIZATION_ID = LP_ORGANIZATION_ID

Line 555: MTL_CATEGORIES_KFV MCV,

551: FROM
552: MTL_ITEM_CATEGORIES MIC,
553: MTL_SYSTEM_ITEMS MSI,
554: BOM_PARAMETERS BP,
555: MTL_CATEGORIES_KFV MCV,
556: CST_ITEM_COSTS CIC,
557: MTL_PARAMETERS MP
558: WHERE LP_ORGANIZATION_ID is null
559: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID