Product: | PER - Human Resources |
---|---|
Description: | View to export Org information |
Implementation/DBA Data: | APPS.HR_DM_EXP_ALL_ORG_UNITS_V |
SELECT EXP_IMP_ID
, TABLE_NAME
, PVAL001 ORGANIZATION_ID
, PVAL002 BUSINESS_GROUP_ID
, PVAL003 COST_ALLOCATION_KEYFLEX_ID
, PVAL004 LOCATION_ID
, PVAL005 SOFT_CODING_KEYFLEX_ID
, PVAL006 DATE_FROM
, PVAL007 NAME
, PVAL008 COMMENTS
, PVAL009 DATE_TO
, PVAL010 INTERNAL_EXTERNAL_FLAG
, PVAL011 INTERNAL_ADDRESS_LINE
, PVAL012 TYPE
, PVAL013 REQUEST_ID
, PVAL014 PROGRAM_APPLICATION_ID
, PVAL015 PROGRAM_ID
, PVAL016 PROGRAM_UPDATE_DATE
, PVAL017 ATTRIBUTE_CATEGORY
, PVAL018 ATTRIBUTE1
, PVAL019 ATTRIBUTE2
, PVAL020 ATTRIBUTE3
, PVAL021 ATTRIBUTE4
, PVAL022 ATTRIBUTE5
, PVAL023 ATTRIBUTE6
, PVAL024 ATTRIBUTE7
, PVAL025 ATTRIBUTE8
, PVAL026 ATTRIBUTE9
, PVAL027 ATTRIBUTE10
, PVAL028 ATTRIBUTE11
, PVAL029 ATTRIBUTE12
, PVAL030 ATTRIBUTE13
, PVAL031 ATTRIBUTE14
, PVAL032 ATTRIBUTE15
, PVAL033 ATTRIBUTE16
, PVAL034 ATTRIBUTE17
, PVAL035 ATTRIBUTE18
, PVAL036 ATTRIBUTE19
, PVAL037 ATTRIBUTE20
, PVAL038 LAST_UPDATE_DATE
, PVAL039 LAST_UPDATED_BY
, PVAL040 LAST_UPDATE_LOGIN
, PVAL041 CREATED_BY
, PVAL042 CREATION_DATE
FROM HR_DM_EXP_IMPS
WHERE TABLE_NAME = 'HR_ALL_ORGANIZATION_UNITS'