APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_PARAMETERS

Line 399: FROM mtl_parameters

395: AND l_Rel_Item_Rec.ORGANIZATION_ID <> FND_API.G_MISS_NUM THEN
396:
397: BEGIN
398: SELECT 'x' INTO l_master_org_exists
399: FROM mtl_parameters
400: WHERE ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID
401: AND MASTER_ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID;
402: EXCEPTION
403: WHEN NO_DATA_FOUND THEN

Line 417: ,p_table_name => 'MTL_PARAMETERS'

413: ,p_token_tbl => l_Token_Tbl
414: ,p_message_type => 'E'
415: ,p_entity_code => G_Entity_Code
416: ,p_entity_index => 1
417: ,p_table_name => 'MTL_PARAMETERS'
418: );
419: RAISE VALIDATION_ERROR;
420: WHEN Too_Many_Rows THEN
421: NULL;

Line 2288: FROM mtl_parameters mtp

2284:
2285: BEGIN
2286:
2287: SELECT mtp.organization_id into p_organization_id
2288: FROM mtl_parameters mtp
2289: WHERE mtp.organization_code = l_mtl_Rel_Item_rec.ORGANIZATION_CODE;
2290:
2291:
2292: IF l_mtl_Rel_Item_rec.ORGANIZATION_ID IS NOT NULL THEN