APPS.INV_UTILITIES dependencies on MTL_PROJECT_V

Line 477: -- the call to MTL_PROJECT_V will return data.

473: BEGIN
474: v_seg19_f := TRUE;
475:
476: -- bug 4662395 set the profile mfg_organization_id so
477: -- the call to MTL_PROJECT_V will return data.
478:
479: FND_PROFILE.put('MFG_ORGANIZATION_ID',x_org_id);
480:
481: SELECT DISTINCT project_number

Line 483: FROM mtl_project_v

479: FND_PROFILE.put('MFG_ORGANIZATION_ID',x_org_id);
480:
481: SELECT DISTINCT project_number
482: INTO v_proj_name
483: FROM mtl_project_v
484: WHERE project_id = (SELECT NVL(TO_NUMBER(segment19), 0)
485: FROM mtl_item_locations
486: WHERE inventory_location_id = x_loc_id
487: AND organization_id = x_org_id);