DBA Data[Home] [Help]

APPS.INV_UTILITIES dependencies on MTL_PROJECT_V

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

641: BEGIN
642: v_seg19_f := TRUE;
643:
644: -- bug 4662395 set the profile mfg_organization_id so
645: -- the call to MTL_PROJECT_V will return data.
646:
647: FND_PROFILE.put('MFG_ORGANIZATION_ID',x_org_id);
648:
649: SELECT DISTINCT project_number

Line 651: FROM mtl_project_v

647: FND_PROFILE.put('MFG_ORGANIZATION_ID',x_org_id);
648:
649: SELECT DISTINCT project_number
650: INTO v_proj_name
651: FROM mtl_project_v
652: WHERE project_id = (SELECT NVL(TO_NUMBER(segment19), 0)
653: FROM mtl_item_locations
654: WHERE inventory_location_id = x_loc_id
655: AND organization_id = x_org_id);