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_PERSON_ADDRESS

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_DATE_FROM,
       pval003 P_DATE_TO,
       pval004 P_ADDRESS_TYPE,
       plongval P_COMMENTS,
       pval006 P_FLAT_DOOR_BLOCK,
       pval007 P_BUILDING_VILLAGE,
       pval008 P_ROAD_STREET,
       pval009 P_AREA_LOCALITY,
       pval010 P_TOWN_OR_CITY,
       pval011 P_STATE_UT,
       pval012 P_PIN_CODE,
       pval013 P_ADDR_ATTRIBUTE_CATEGORY,
       pval014 P_ADDR_ATTRIBUTE1,
       pval015 P_ADDR_ATTRIBUTE2,
       pval016 P_ADDR_ATTRIBUTE3,
       pval017 P_ADDR_ATTRIBUTE4,
       pval018 P_ADDR_ATTRIBUTE5,
       pval019 P_ADDR_ATTRIBUTE6,
       pval020 P_ADDR_ATTRIBUTE7,
       pval021 P_ADDR_ATTRIBUTE8,
       pval022 P_ADDR_ATTRIBUTE9,
       pval023 P_ADDR_ATTRIBUTE10,
       pval024 P_ADDR_ATTRIBUTE11,
       pval025 P_ADDR_ATTRIBUTE12,
       pval026 P_ADDR_ATTRIBUTE13,
       pval027 P_ADDR_ATTRIBUTE14,
       pval028 P_ADDR_ATTRIBUTE15,
       pval029 P_ADDR_ATTRIBUTE16,
       pval030 P_ADDR_ATTRIBUTE17,
       pval031 P_ADDR_ATTRIBUTE18,
       pval032 P_ADDR_ATTRIBUTE19,
       pval033 P_ADDR_ATTRIBUTE20,
       pval034 P_ADDRESS_USER_KEY,
       pval035 P_COUNTRY
from hr_pump_batch_lines
where api_module_id = 3218
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_DATE_FROM
, PVAL003 P_DATE_TO
, PVAL004 P_ADDRESS_TYPE
, PLONGVAL P_COMMENTS
, PVAL006 P_FLAT_DOOR_BLOCK
, PVAL007 P_BUILDING_VILLAGE
, PVAL008 P_ROAD_STREET
, PVAL009 P_AREA_LOCALITY
, PVAL010 P_TOWN_OR_CITY
, PVAL011 P_STATE_UT
, PVAL012 P_PIN_CODE
, PVAL013 P_ADDR_ATTRIBUTE_CATEGORY
, PVAL014 P_ADDR_ATTRIBUTE1
, PVAL015 P_ADDR_ATTRIBUTE2
, PVAL016 P_ADDR_ATTRIBUTE3
, PVAL017 P_ADDR_ATTRIBUTE4
, PVAL018 P_ADDR_ATTRIBUTE5
, PVAL019 P_ADDR_ATTRIBUTE6
, PVAL020 P_ADDR_ATTRIBUTE7
, PVAL021 P_ADDR_ATTRIBUTE8
, PVAL022 P_ADDR_ATTRIBUTE9
, PVAL023 P_ADDR_ATTRIBUTE10
, PVAL024 P_ADDR_ATTRIBUTE11
, PVAL025 P_ADDR_ATTRIBUTE12
, PVAL026 P_ADDR_ATTRIBUTE13
, PVAL027 P_ADDR_ATTRIBUTE14
, PVAL028 P_ADDR_ATTRIBUTE15
, PVAL029 P_ADDR_ATTRIBUTE16
, PVAL030 P_ADDR_ATTRIBUTE17
, PVAL031 P_ADDR_ATTRIBUTE18
, PVAL032 P_ADDR_ATTRIBUTE19
, PVAL033 P_ADDR_ATTRIBUTE20
, PVAL034 P_ADDRESS_USER_KEY
, PVAL035 P_COUNTRY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3218 WITH CHECK OPTION