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_CREATE_MX_CONTACT

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_START_DATE,
       pval002 P_CONTACT_TYPE,
       pval003 P_CTR_COMMENTS,
       pval004 P_PRIMARY_CONTACT_FLAG,
       pval005 P_DATE_START,
       pval006 P_DATE_END,
       pval007 P_RLTD_PER_RSDS_W_DSGNTR_FLAG,
       pval008 P_PERSONAL_FLAG,
       pval009 P_SEQUENCE_NUMBER,
       pval010 P_CONT_ATTRIBUTE_CATEGORY,
       pval011 P_CONT_ATTRIBUTE1,
       pval012 P_CONT_ATTRIBUTE2,
       pval013 P_CONT_ATTRIBUTE3,
       pval014 P_CONT_ATTRIBUTE4,
       pval015 P_CONT_ATTRIBUTE5,
       pval016 P_CONT_ATTRIBUTE6,
       pval017 P_CONT_ATTRIBUTE7,
       pval018 P_CONT_ATTRIBUTE8,
       pval019 P_CONT_ATTRIBUTE9,
       pval020 P_CONT_ATTRIBUTE10,
       pval021 P_CONT_ATTRIBUTE11,
       pval022 P_CONT_ATTRIBUTE12,
       pval023 P_CONT_ATTRIBUTE13,
       pval024 P_CONT_ATTRIBUTE14,
       pval025 P_CONT_ATTRIBUTE15,
       pval026 P_CONT_ATTRIBUTE16,
       pval027 P_CONT_ATTRIBUTE17,
       pval028 P_CONT_ATTRIBUTE18,
       pval029 P_CONT_ATTRIBUTE19,
       pval030 P_CONT_ATTRIBUTE20,
       pval031 P_THIRD_PARTY_PAY_FLAG,
       pval032 P_BONDHOLDER_FLAG,
       pval033 P_DEPENDENT_FLAG,
       pval034 P_BENEFICIARY_FLAG,
       pval035 P_PATERNAL_LAST_NAME,
       pval036 P_SEX,
       pval037 P_PER_COMMENTS,
       pval038 P_DATE_OF_BIRTH,
       pval039 P_EMAIL_ADDRESS,
       pval040 P_FIRST_NAME,
       pval041 P_KNOWN_AS,
       pval042 P_MARITAL_STATUS,
       pval043 P_SECOND_NAME,
       pval044 P_NATIONALITY,
       pval045 P_CURP_ID,
       pval046 P_PREVIOUS_LAST_NAME,
       pval047 P_REGISTERED_DISABLED_FLAG,
       pval048 P_TITLE,
       pval049 P_WORK_TELEPHONE,
       pval050 P_ATTRIBUTE_CATEGORY,
       pval051 P_ATTRIBUTE1,
       pval052 P_ATTRIBUTE2,
       pval053 P_ATTRIBUTE3,
       pval054 P_ATTRIBUTE4,
       pval055 P_ATTRIBUTE5,
       pval056 P_ATTRIBUTE6,
       pval057 P_ATTRIBUTE7,
       pval058 P_ATTRIBUTE8,
       pval059 P_ATTRIBUTE9,
       pval060 P_ATTRIBUTE10,
       pval061 P_ATTRIBUTE11,
       pval062 P_ATTRIBUTE12,
       pval063 P_ATTRIBUTE13,
       pval064 P_ATTRIBUTE14,
       pval065 P_ATTRIBUTE15,
       pval066 P_ATTRIBUTE16,
       pval067 P_ATTRIBUTE17,
       pval068 P_ATTRIBUTE18,
       pval069 P_ATTRIBUTE19,
       pval070 P_ATTRIBUTE20,
       pval071 P_ATTRIBUTE21,
       pval072 P_ATTRIBUTE22,
       pval073 P_ATTRIBUTE23,
       pval074 P_ATTRIBUTE24,
       pval075 P_ATTRIBUTE25,
       pval076 P_ATTRIBUTE26,
       pval077 P_ATTRIBUTE27,
       pval078 P_ATTRIBUTE28,
       pval079 P_ATTRIBUTE29,
       pval080 P_ATTRIBUTE30,
       pval081 P_MATERNAL_LAST_NAME,
       pval082 P_CORRESPONDENCE_LANGUAGE,
       pval083 P_HONORS,
       pval084 P_PRE_NAME_ADJUNCT,
       pval085 P_SUFFIX,
       pval086 P_CREATE_MIRROR_FLAG,
       pval087 P_MIRROR_TYPE,
       pval088 P_MIRROR_CONT_ATTRIBUTE_CAT,
       pval089 P_MIRROR_CONT_ATTRIBUTE1,
       pval090 P_MIRROR_CONT_ATTRIBUTE2,
       pval091 P_MIRROR_CONT_ATTRIBUTE3,
       pval092 P_MIRROR_CONT_ATTRIBUTE4,
       pval093 P_MIRROR_CONT_ATTRIBUTE5,
       pval094 P_MIRROR_CONT_ATTRIBUTE6,
       pval095 P_MIRROR_CONT_ATTRIBUTE7,
       pval096 P_MIRROR_CONT_ATTRIBUTE8,
       pval097 P_MIRROR_CONT_ATTRIBUTE9,
       pval098 P_MIRROR_CONT_ATTRIBUTE10,
       pval099 P_MIRROR_CONT_ATTRIBUTE11,
       pval100 P_MIRROR_CONT_ATTRIBUTE12,
       pval101 P_MIRROR_CONT_ATTRIBUTE13,
       pval102 P_MIRROR_CONT_ATTRIBUTE14,
       pval103 P_MIRROR_CONT_ATTRIBUTE15,
       pval104 P_MIRROR_CONT_ATTRIBUTE16,
       pval105 P_MIRROR_CONT_ATTRIBUTE17,
       pval106 P_MIRROR_CONT_ATTRIBUTE18,
       pval107 P_MIRROR_CONT_ATTRIBUTE19,
       pval108 P_MIRROR_CONT_ATTRIBUTE20,
       pval109 P_CONTACT_RELATIONSHIP_ID,
       pval110 P_CTR_OBJECT_VERSION_NUMBER,
       pval111 P_PER_PERSON_USER_KEY,
       pval112 P_PER_OBJECT_VERSION_NUMBER,
       pval113 P_PER_EFFECTIVE_START_DATE,
       pval114 P_PER_EFFECTIVE_END_DATE,
       pval115 P_FULL_NAME,
       pval116 P_PER_COMMENT_ID,
       pval117 P_NAME_COMBINATION_WARNING,
       pval118 P_ORIG_HIRE_WARNING,
       pval119 P_PERSON_USER_KEY,
       pval120 P_CONTACT_PERSON_USER_KEY,
       pval121 P_START_LIFE_REASON,
       pval122 P_END_LIFE_REASON,
       pval123 P_USER_PERSON_TYPE,
       pval124 P_LANGUAGE_CODE
from hr_pump_batch_lines
where api_module_id = 3861
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_START_DATE
, PVAL002 P_CONTACT_TYPE
, PVAL003 P_CTR_COMMENTS
, PVAL004 P_PRIMARY_CONTACT_FLAG
, PVAL005 P_DATE_START
, PVAL006 P_DATE_END
, PVAL007 P_RLTD_PER_RSDS_W_DSGNTR_FLAG
, PVAL008 P_PERSONAL_FLAG
, PVAL009 P_SEQUENCE_NUMBER
, PVAL010 P_CONT_ATTRIBUTE_CATEGORY
, PVAL011 P_CONT_ATTRIBUTE1
, PVAL012 P_CONT_ATTRIBUTE2
, PVAL013 P_CONT_ATTRIBUTE3
, PVAL014 P_CONT_ATTRIBUTE4
, PVAL015 P_CONT_ATTRIBUTE5
, PVAL016 P_CONT_ATTRIBUTE6
, PVAL017 P_CONT_ATTRIBUTE7
, PVAL018 P_CONT_ATTRIBUTE8
, PVAL019 P_CONT_ATTRIBUTE9
, PVAL020 P_CONT_ATTRIBUTE10
, PVAL021 P_CONT_ATTRIBUTE11
, PVAL022 P_CONT_ATTRIBUTE12
, PVAL023 P_CONT_ATTRIBUTE13
, PVAL024 P_CONT_ATTRIBUTE14
, PVAL025 P_CONT_ATTRIBUTE15
, PVAL026 P_CONT_ATTRIBUTE16
, PVAL027 P_CONT_ATTRIBUTE17
, PVAL028 P_CONT_ATTRIBUTE18
, PVAL029 P_CONT_ATTRIBUTE19
, PVAL030 P_CONT_ATTRIBUTE20
, PVAL031 P_THIRD_PARTY_PAY_FLAG
, PVAL032 P_BONDHOLDER_FLAG
, PVAL033 P_DEPENDENT_FLAG
, PVAL034 P_BENEFICIARY_FLAG
, PVAL035 P_PATERNAL_LAST_NAME
, PVAL036 P_SEX
, PVAL037 P_PER_COMMENTS
, PVAL038 P_DATE_OF_BIRTH
, PVAL039 P_EMAIL_ADDRESS
, PVAL040 P_FIRST_NAME
, PVAL041 P_KNOWN_AS
, PVAL042 P_MARITAL_STATUS
, PVAL043 P_SECOND_NAME
, PVAL044 P_NATIONALITY
, PVAL045 P_CURP_ID
, PVAL046 P_PREVIOUS_LAST_NAME
, PVAL047 P_REGISTERED_DISABLED_FLAG
, PVAL048 P_TITLE
, PVAL049 P_WORK_TELEPHONE
, PVAL050 P_ATTRIBUTE_CATEGORY
, PVAL051 P_ATTRIBUTE1
, PVAL052 P_ATTRIBUTE2
, PVAL053 P_ATTRIBUTE3
, PVAL054 P_ATTRIBUTE4
, PVAL055 P_ATTRIBUTE5
, PVAL056 P_ATTRIBUTE6
, PVAL057 P_ATTRIBUTE7
, PVAL058 P_ATTRIBUTE8
, PVAL059 P_ATTRIBUTE9
, PVAL060 P_ATTRIBUTE10
, PVAL061 P_ATTRIBUTE11
, PVAL062 P_ATTRIBUTE12
, PVAL063 P_ATTRIBUTE13
, PVAL064 P_ATTRIBUTE14
, PVAL065 P_ATTRIBUTE15
, PVAL066 P_ATTRIBUTE16
, PVAL067 P_ATTRIBUTE17
, PVAL068 P_ATTRIBUTE18
, PVAL069 P_ATTRIBUTE19
, PVAL070 P_ATTRIBUTE20
, PVAL071 P_ATTRIBUTE21
, PVAL072 P_ATTRIBUTE22
, PVAL073 P_ATTRIBUTE23
, PVAL074 P_ATTRIBUTE24
, PVAL075 P_ATTRIBUTE25
, PVAL076 P_ATTRIBUTE26
, PVAL077 P_ATTRIBUTE27
, PVAL078 P_ATTRIBUTE28
, PVAL079 P_ATTRIBUTE29
, PVAL080 P_ATTRIBUTE30
, PVAL081 P_MATERNAL_LAST_NAME
, PVAL082 P_CORRESPONDENCE_LANGUAGE
, PVAL083 P_HONORS
, PVAL084 P_PRE_NAME_ADJUNCT
, PVAL085 P_SUFFIX
, PVAL086 P_CREATE_MIRROR_FLAG
, PVAL087 P_MIRROR_TYPE
, PVAL088 P_MIRROR_CONT_ATTRIBUTE_CAT
, PVAL089 P_MIRROR_CONT_ATTRIBUTE1
, PVAL090 P_MIRROR_CONT_ATTRIBUTE2
, PVAL091 P_MIRROR_CONT_ATTRIBUTE3
, PVAL092 P_MIRROR_CONT_ATTRIBUTE4
, PVAL093 P_MIRROR_CONT_ATTRIBUTE5
, PVAL094 P_MIRROR_CONT_ATTRIBUTE6
, PVAL095 P_MIRROR_CONT_ATTRIBUTE7
, PVAL096 P_MIRROR_CONT_ATTRIBUTE8
, PVAL097 P_MIRROR_CONT_ATTRIBUTE9
, PVAL098 P_MIRROR_CONT_ATTRIBUTE10
, PVAL099 P_MIRROR_CONT_ATTRIBUTE11
, PVAL100 P_MIRROR_CONT_ATTRIBUTE12
, PVAL101 P_MIRROR_CONT_ATTRIBUTE13
, PVAL102 P_MIRROR_CONT_ATTRIBUTE14
, PVAL103 P_MIRROR_CONT_ATTRIBUTE15
, PVAL104 P_MIRROR_CONT_ATTRIBUTE16
, PVAL105 P_MIRROR_CONT_ATTRIBUTE17
, PVAL106 P_MIRROR_CONT_ATTRIBUTE18
, PVAL107 P_MIRROR_CONT_ATTRIBUTE19
, PVAL108 P_MIRROR_CONT_ATTRIBUTE20
, PVAL109 P_CONTACT_RELATIONSHIP_ID
, PVAL110 P_CTR_OBJECT_VERSION_NUMBER
, PVAL111 P_PER_PERSON_USER_KEY
, PVAL112 P_PER_OBJECT_VERSION_NUMBER
, PVAL113 P_PER_EFFECTIVE_START_DATE
, PVAL114 P_PER_EFFECTIVE_END_DATE
, PVAL115 P_FULL_NAME
, PVAL116 P_PER_COMMENT_ID
, PVAL117 P_NAME_COMBINATION_WARNING
, PVAL118 P_ORIG_HIRE_WARNING
, PVAL119 P_PERSON_USER_KEY
, PVAL120 P_CONTACT_PERSON_USER_KEY
, PVAL121 P_START_LIFE_REASON
, PVAL122 P_END_LIFE_REASON
, PVAL123 P_USER_PERSON_TYPE
, PVAL124 P_LANGUAGE_CODE FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3861 WITH CHECK OPTION