DBA Data[Home] [Help]

APPS.AHL_MM_CANNIBALIZATION_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 97: FROM mtl_system_items_kfv mtl, hr_organization_units hou, mtl_parameters mtlp

93:
94: CURSOR get_uom(c_org_id NUMBER, c_item_id NUMBER)
95: IS
96: SELECT mtl.primary_uom_code
97: FROM mtl_system_items_kfv mtl, hr_organization_units hou, mtl_parameters mtlp
98: WHERE mtl.organization_id = hou.organization_id
99: AND mtlp.organization_id = hou.organization_id
100: AND mtlp.eam_enabled_flag = 'Y'
101: AND hou.organization_id = c_org_id