DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 449: FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC1

445: ))
446: OR ( MTLUCV.INVENTORY_ITEM_ID = 0
447: AND MTLUCV.UOM_CODE IN
448: (SELECT MTLUCC1.TO_UOM_CODE
449: FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC1
450: WHERE MTLUCC1.INVENTORY_ITEM_ID = MTLITM1.INVENTORY_ITEM_ID
451: AND NVL(MTLUCC1.DISABLE_DATE, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
452: ) ) )
453: OR ( MTLITM1.ALLOWED_UNITS_LOOKUP_CODE IN (2, 3)

Line 457: FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC

453: OR ( MTLITM1.ALLOWED_UNITS_LOOKUP_CODE IN (2, 3)
454: AND MTLUCV.INVENTORY_ITEM_ID = 0
455: AND ( MTLUCV.UOM_CLASS IN
456: (SELECT MTLUCC.TO_UOM_CLASS
457: FROM MTL_UOM_CLASS_CONVERSIONS MTLUCC
458: WHERE MTLUCC.INVENTORY_ITEM_ID = MTLITM1.INVENTORY_ITEM_ID
459: AND NVL(MTLUCC.DISABLE_DATE, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
460: )
461: OR MTLUCV.UOM_CLASS =