ECC Human Resources, Human Resources, SQL4

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: PER
Query Procedure: PER_ECC_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Human Resources, Human Resources, SQL4 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
    ,PERSON_ID
               ,PHONE_NUMBER
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,PHN_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_PHONE_V where language in ('US')) PIVOT (max(PHONE_NUMBER) as PHONE_NUMBER for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Security Profile 
x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile)
 LOV
Download
Related Blitz Reports
ECC Human Resources, Human Resources People Hierarchy ECC Sourcing, Negotiations, SQL2 ECC Service Contracts, Service Contract Customer Details ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances ECC Service Contracts, Service Contract Details ECC Lease Contracts, Lease Meter Readings Information ECC G-Invoicing, Projects: G-Invoicing ECC Service, Service Request
Blitz Report™

Blitz Report™ provides multiple benefits: