DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on FND_USER

Line 3173: l_party_id FND_USER.CUSTOMER_ID%TYPE;

3169: l_Primary_Unit_of_Measure VARCHAR2(25);
3170: l_SERVICE_ITEM_FLAG VARCHAR2(1);
3171: l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
3172: l_USAGE_ITEM_FLAG VARCHAR2(1);
3173: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3174: l_grant_guid fnd_grants.grant_guid%TYPE;
3175: l_ego_exists VARCHAR2(1) := 'N';
3176: l_master_org VARCHAR2(1); --R12: Business Events
3177: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;

Line 4086: -- For Internal Users , Customer_Id may not getting populated in FND_USER

4082: OPEN c_ego_exists;
4083: FETCH c_ego_exists INTO l_ego_exists;
4084: CLOSE c_ego_exists;
4085:
4086: -- For Internal Users , Customer_Id may not getting populated in FND_USER
4087: -- Hence checking USER_ID from ego_people_v which always return all registered
4088: -- Users (Customer, Internal and Vendor)
4089: -- Bug Fix : 3048453
4090: --3797291: Using fnd_grants API instead of EGO API.