APPS.AHL_MC_RULE_PUB dependencies on MTL_PARAMETERS

Line 1487: FROM MTL_PARAMETERS MP

1483: FROM MTL_SYSTEM_ITEMS_B KFV
1484: WHERE inventory_item_id = p_item_id
1485: AND EXISTS
1486: (SELECT 'X'
1487: FROM MTL_PARAMETERS MP
1488: WHERE MP.master_organization_id = KFV.organization_id
1489: AND MP.eam_enabled_flag = 'Y');
1490:
1491: CURSOR chk_item_name_csr (p_item_name VARCHAR2) IS

Line 1497: FROM MTL_PARAMETERS MP

1493: FROM MTL_SYSTEM_ITEMS_KFV KFV
1494: WHERE concatenated_segments = p_item_name
1495: AND EXISTS
1496: (SELECT 'X'
1497: FROM MTL_PARAMETERS MP
1498: WHERE MP.master_organization_id = KFV.organization_id
1499: AND MP.eam_enabled_flag = 'Y');
1500:
1501: CURSOR chk_mc_id_csr (p_mc_id NUMBER) IS