DBA Data[Home] [Help]

APPS.WSH_WSHRDMBL_XMLP_PKG dependencies on MTL_CATEGORIES_KFV

Line 416: MTL_CATEGORIES_KFV MC,

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

Line 449: MTL_CATEGORIES_KFV MC,

445: CURSOR C_CATEGORY(C_INV_ITEM_ID IN NUMBER,C_INV_ORG_ID IN NUMBER) IS
446: SELECT
447: CONCATENATED_SEGMENTS COMM_CLASS
448: FROM
449: MTL_CATEGORIES_KFV MC,
450: MTL_ITEM_CATEGORIES MIC,
451: MTL_CATEGORY_SETS_VL MCSTL
452: WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
453: AND MIC.ORGANIZATION_ID = C_INV_ORG_ID