DBA Data[Home] [Help]

APPS.CSM_SERVICE_REQUESTS_PKG dependencies on MTL_PARAMETERS

Line 280: FROM mtl_parameters

276: FETCH c_validate_item_org INTO l_dummy;
277: IF c_validate_item_org%NOTFOUND THEN
278: SELECT master_organization_id
279: INTO l_org_id
280: FROM mtl_parameters
281: WHERE organization_id = l_sr_rec.inventory_org_id;
282: l_sr_rec.inventory_org_id := l_org_id;
283: END IF;
284: CLOSE c_validate_item_org;

Line 574: FROM mtl_parameters

570: FETCH c_validate_item_org INTO l_dummy;
571: IF c_validate_item_org%NOTFOUND THEN
572: SELECT master_organization_id
573: INTO l_org_id
574: FROM mtl_parameters
575: WHERE organization_id = l_sr_rec.inventory_org_id;
576:
577: l_sr_rec.inventory_org_id := l_org_id;
578: END IF;