ECC Human Resources, Human Resources, SQL3
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
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, SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select x.* from ( select * from (SELECT ECC_SPEC_ID ,PERSON_ID ,ADDRESS_STYLE ,ADDRESS_TYPE ,ADDRESS ,ADDRESS_DATE_FROM ,ADDRESS_DATE_TO ,LOGGED_USER_ID ,SECURITY_PROFILE_ID ,ADD_LAST_UPDATE_DATE ,LANGUAGE FROM PER_ECC_ADDRESS_V where language in ('US')) PIVOT (max(ADDRESS_TYPE) as ADDRESS_TYPE for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Security Profile |
|
LOV |