DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on FND_USER

Line 3434: l_party_id FND_USER.CUSTOMER_ID%TYPE;

3430: l_Primary_Unit_of_Measure VARCHAR2(25);
3431: l_SERVICE_ITEM_FLAG VARCHAR2(1);
3432: l_VENDOR_WARRANTY_FLAG VARCHAR2(1);
3433: l_USAGE_ITEM_FLAG VARCHAR2(1);
3434: l_party_id FND_USER.CUSTOMER_ID%TYPE;
3435: l_grant_guid fnd_grants.grant_guid%TYPE;
3436: l_ego_exists VARCHAR2(1) := 'N';
3437: l_master_org VARCHAR2(1); --R12: Business Events
3438: l_mast_organization_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE;

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

4347: OPEN c_ego_exists;
4348: FETCH c_ego_exists INTO l_ego_exists;
4349: CLOSE c_ego_exists;
4350:
4351: -- For Internal Users , Customer_Id may not getting populated in FND_USER
4352: -- Hence checking USER_ID from ego_people_v which always return all registered
4353: -- Users (Customer, Internal and Vendor)
4354: -- Bug Fix : 3048453
4355: --3797291: Using fnd_grants API instead of EGO API.