APPS.BOM_CSTRSCCR_XMLP_PKG dependencies on MTL_CATEGORIES_KFV

Line 123: MTL_CATEGORIES_KFV MCV,

119: SELECT
120: MIN(TO_CHAR(MCV.CATEGORY_ID))
121: INTO P_CATEGORY_ID
122: FROM
123: MTL_CATEGORIES_KFV MCV,
124: MTL_CATEGORY_SETS MCS
125: WHERE SUBSTRB(MCV.CONCATENATED_SEGMENTS
126: ,1
127: ,2000) = P_CATEGORY_ID

Line 341: MTL_CATEGORIES_KFV MCV

337: ,1
338: ,2000)
339: INTO P_CATEGORY_NAME
340: FROM
341: MTL_CATEGORIES_KFV MCV
342: WHERE CATEGORY_ID = TO_NUMBER(P_CATEGORY_ID);
343: P_CATEGORY_FROM := P_CATEGORY_NAME;
344: P_CATEGORY_TO := P_CATEGORY_NAME;
345: END IF;

Line 485: MTL_CATEGORIES_KFV MCV,

481: FROM
482: MTL_ITEM_CATEGORIES MIC,
483: MTL_SYSTEM_ITEMS MSI,
484: BOM_PARAMETERS BP,
485: MTL_CATEGORIES_KFV MCV,
486: CST_ITEM_COSTS CIC,
487: MTL_PARAMETERS MP
488: WHERE P_ORGANIZATION_ID is not null
489: AND MIC.ORGANIZATION_ID = P_ORGANIZATION_ID

Line 547: MTL_CATEGORIES_KFV MCV,

543: FROM
544: MTL_ITEM_CATEGORIES MIC,
545: MTL_SYSTEM_ITEMS MSI,
546: BOM_PARAMETERS BP,
547: MTL_CATEGORIES_KFV MCV,
548: CST_ITEM_COSTS CIC,
549: MTL_PARAMETERS MP
550: WHERE P_ORGANIZATION_ID is null
551: AND MIC.CATEGORY_SET_ID = LP_CATEGORY_SET_ID