DBA Data[Home] [Help]

APPS.OE_VALIDATE_ATTR dependencies on MTL_SYSTEM_ITEMS

Line 4678: FROM MTL_SYSTEM_ITEMS SI,

4674: SELECT SI.PRIMARY_UOM_CODE,
4675: NVL(SERVICE_ITEM_FLAG,0)
4676: INTO x_unit_code,
4677: x_service_item_flag
4678: FROM MTL_SYSTEM_ITEMS SI,
4679: MTL_UNITS_OF_MEASURE MUOM
4680: WHERE SI.PRIMARY_UOM_CODE = MUOM.UOM_CODE
4681: AND SI.ORGANIZATION_ID = p_organization_id
4682: AND SI.INVENTORY_ITEM_ID = p_inventory_item_id;