DBA Data[Home] [Help]

APPS.OZF_ADJ_NEW_PROD_PVT dependencies on MTL_ITEM_UOMS_VIEW

Line 758: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM mtl_item_uoms_view

754: )
755: IS
756: CURSOR C_UOM_CODE_EXISTS (p_uom_code VARCHAR2,p_organization_id NUMBER,p_inventory_item_id NUMBER)
757: IS
758: SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM mtl_item_uoms_view
759: WHERE ( organization_id = p_organization_id
760: OR p_organization_id is NULL )
761: AND uom_code = p_uom_code
762: AND inventory_item_id = p_inventory_item_id);