DBA Data[Home] [Help]

APPS.CSM_SERVICE_REQUESTS_PKG dependencies on MTL_PARAMETERS

Line 376: FROM mtl_parameters

372: FETCH c_validate_item_org INTO l_dummy;
373: IF c_validate_item_org%NOTFOUND THEN
374: SELECT master_organization_id
375: INTO l_org_id
376: FROM mtl_parameters
377: WHERE organization_id = l_sr_rec.inventory_org_id;
378: l_sr_rec.inventory_org_id := l_org_id;
379: END IF;
380: CLOSE c_validate_item_org;

Line 738: FROM mtl_parameters

734: FETCH c_validate_item_org INTO l_dummy;
735: IF c_validate_item_org%NOTFOUND THEN
736: SELECT master_organization_id
737: INTO l_org_id
738: FROM mtl_parameters
739: WHERE organization_id = l_sr_rec.inventory_org_id;
740: l_sr_rec.inventory_org_id := l_org_id;
741: END IF;
742: CLOSE c_validate_item_org;