DBA Data[Home] [Help]

APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on MTL_CATEGORY_SETS_VL

Line 405: MTL_CATEGORY_SETS_VL MCSTL

401: CONCATENATED_SEGMENTS COMM_CLASS
402: FROM
403: MTL_CATEGORIES_KFV MC,
404: MTL_ITEM_CATEGORIES MIC,
405: MTL_CATEGORY_SETS_VL MCSTL
406: WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
407: AND MIC.ORGANIZATION_ID = C_INV_ORG_ID
408: AND MIC.CATEGORY_SET_ID = MCSTL.CATEGORY_SET_ID
409: AND MC.CATEGORY_ID = MIC.CATEGORY_ID

Line 437: MTL_CATEGORY_SETS_VL MCSTL

433: MC.SEGMENT1 || '-' || MC.SEGMENT2 || '-' || MC.SEGMENT3 COMM_CLASS
434: FROM
435: MTL_CATEGORIES MC,
436: MTL_ITEM_CATEGORIES MIC,
437: MTL_CATEGORY_SETS_VL MCSTL
438: WHERE MIC.INVENTORY_ITEM_ID = C_INV_ITEM_ID
439: AND MIC.ORGANIZATION_ID = C_INV_ORG_ID
440: AND MIC.CATEGORY_SET_ID = MCSTL.CATEGORY_SET_ID
441: AND MC.CATEGORY_ID = MIC.CATEGORY_ID