DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_RES dependencies on MTL_UOM_CONVERSIONS

Line 1052: FROM MTL_UOM_CONVERSIONS muc1,

1048: SELECT 'Unable to convert'
1049: FROM SYS.DUAL
1050: WHERE NOT EXISTS(
1051: SELECT NULL
1052: FROM MTL_UOM_CONVERSIONS muc1,
1053: MTL_UOM_CONVERSIONS muc2
1054: WHERE muc1.uom_code = p_res_uom_code
1055: AND muc1.uom_class = p_res_uom_class
1056: AND muc1.inventory_item_id = 0

Line 1053: MTL_UOM_CONVERSIONS muc2

1049: FROM SYS.DUAL
1050: WHERE NOT EXISTS(
1051: SELECT NULL
1052: FROM MTL_UOM_CONVERSIONS muc1,
1053: MTL_UOM_CONVERSIONS muc2
1054: WHERE muc1.uom_code = p_res_uom_code
1055: AND muc1.uom_class = p_res_uom_class
1056: AND muc1.inventory_item_id = 0
1057: AND NVL(muc1.disable_date, SYSDATE + 1) > SYSDATE