ECC Human Resources, Human Resources, SQL5

➜ 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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
    ,PERSON_ID
               ,TAG
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,TAG_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_TAG_V where language in ('US')) PIVOT (max(TAG) as TAG 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 Procurement, Indirect Procurement, SQL3 ECC Service, Service Request ECC Service, Service Charges ECC Depot Repair, Depot Service Orders ECC Lease Contracts, Lease Meter Readings Information ECC Depot Repair, Depot Resolved Service Orders FA Asset Book Details PER Report on Hirings INV Physical Inventory Tag Count Upload
Blitz Report™

Blitz Report™ provides multiple benefits: