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.HRDPV_UPDATE_IN_CONTACT_EXTRA_

Source

View Text - Preformatted


select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_EFFECTIVE_DATE,
       pval002 P_DATETRACK_UPDATE_MODE,
       pval003 P_INFORMATION_TYPE,
       pval004 P_NOMINATION_TYPE,
       pval005 P_PERCENT_SHARE,
       pval006 P_NOMINATION_CHANGE_REASON,
       pval007 P_CEI_ATTRIBUTE_CATEGORY,
       pval008 P_CEI_ATTRIBUTE1,
       pval009 P_CEI_ATTRIBUTE2,
       pval010 P_CEI_ATTRIBUTE3,
       pval011 P_CEI_ATTRIBUTE4,
       pval012 P_CEI_ATTRIBUTE5,
       pval013 P_CEI_ATTRIBUTE6,
       pval014 P_CEI_ATTRIBUTE7,
       pval015 P_CEI_ATTRIBUTE8,
       pval016 P_CEI_ATTRIBUTE9,
       pval017 P_CEI_ATTRIBUTE10,
       pval018 P_CEI_ATTRIBUTE11,
       pval019 P_CEI_ATTRIBUTE12,
       pval020 P_CEI_ATTRIBUTE13,
       pval021 P_CEI_ATTRIBUTE14,
       pval022 P_CEI_ATTRIBUTE15,
       pval023 P_CEI_ATTRIBUTE16,
       pval024 P_CEI_ATTRIBUTE17,
       pval025 P_CEI_ATTRIBUTE18,
       pval026 P_CEI_ATTRIBUTE19,
       pval027 P_CEI_ATTRIBUTE20,
       pval028 P_EFFECTIVE_START_DATE,
       pval029 P_EFFECTIVE_END_DATE,
       pval030 P_CONTACT_USER_KEY,
       pval031 P_CONTACTEE_USER_KEY,
       pval032 P_CONTACT_EXTRA_INFO_USER_KEY
from hr_pump_batch_lines
where api_module_id = 3222
with check option

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_EFFECTIVE_DATE
, PVAL002 P_DATETRACK_UPDATE_MODE
, PVAL003 P_INFORMATION_TYPE
, PVAL004 P_NOMINATION_TYPE
, PVAL005 P_PERCENT_SHARE
, PVAL006 P_NOMINATION_CHANGE_REASON
, PVAL007 P_CEI_ATTRIBUTE_CATEGORY
, PVAL008 P_CEI_ATTRIBUTE1
, PVAL009 P_CEI_ATTRIBUTE2
, PVAL010 P_CEI_ATTRIBUTE3
, PVAL011 P_CEI_ATTRIBUTE4
, PVAL012 P_CEI_ATTRIBUTE5
, PVAL013 P_CEI_ATTRIBUTE6
, PVAL014 P_CEI_ATTRIBUTE7
, PVAL015 P_CEI_ATTRIBUTE8
, PVAL016 P_CEI_ATTRIBUTE9
, PVAL017 P_CEI_ATTRIBUTE10
, PVAL018 P_CEI_ATTRIBUTE11
, PVAL019 P_CEI_ATTRIBUTE12
, PVAL020 P_CEI_ATTRIBUTE13
, PVAL021 P_CEI_ATTRIBUTE14
, PVAL022 P_CEI_ATTRIBUTE15
, PVAL023 P_CEI_ATTRIBUTE16
, PVAL024 P_CEI_ATTRIBUTE17
, PVAL025 P_CEI_ATTRIBUTE18
, PVAL026 P_CEI_ATTRIBUTE19
, PVAL027 P_CEI_ATTRIBUTE20
, PVAL028 P_EFFECTIVE_START_DATE
, PVAL029 P_EFFECTIVE_END_DATE
, PVAL030 P_CONTACT_USER_KEY
, PVAL031 P_CONTACTEE_USER_KEY
, PVAL032 P_CONTACT_EXTRA_INFO_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3222 WITH CHECK OPTION