eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HR_DM_EXP_ALL_ORG_UNITS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'