DBA Data[Home] [Help]

APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on MTL_CATEGORIES

Line 414: MTL_CATEGORIES_KFV MC,

410: CURSOR C_CATEGORY(C_INV_ITEM_ID IN NUMBER,C_INV_ORG_ID IN NUMBER) IS
411: SELECT
412: CONCATENATED_SEGMENTS COMM_CLASS
413: FROM
414: MTL_CATEGORIES_KFV MC,
415: MTL_ITEM_CATEGORIES MIC,
416: MTL_CATEGORY_SETS_VL MCSTL
417: WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
418: AND MIC.ORGANIZATION_ID = C_INV_ORG_ID

Line 446: MTL_CATEGORIES MC,

442: CURSOR C_CATEGORY(C_INV_ITEM_ID IN NUMBER,C_INV_ORG_ID IN NUMBER) IS
443: SELECT
444: MC.SEGMENT1 || '-' || MC.SEGMENT2 || '-' || MC.SEGMENT3 COMM_CLASS
445: FROM
446: MTL_CATEGORIES MC,
447: MTL_ITEM_CATEGORIES MIC,
448: MTL_CATEGORY_SETS_VL MCSTL
449: WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
450: AND MIC.ORGANIZATION_ID = C_INV_ORG_ID