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_IN_SECONDARY_CWK_

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_ASSIGNMENT_NUMBER,
       pval003 P_ASSIGNMENT_CATEGORY,
       pval004 P_CHANGE_REASON,
       pval005 P_COMMENTS,
       pval006 P_FREQUENCY,
       pval007 P_INTERNAL_ADDRESS_LINE,
       pval008 P_LABOUR_UNION_MEMBER_FLAG,
       pval009 P_MANAGER_FLAG,
       pval010 P_NORMAL_HOURS,
       pval011 P_PROJECT_TITLE,
       pval012 P_SOURCE_TYPE,
       pval013 P_TIME_NORMAL_FINISH,
       pval014 P_TIME_NORMAL_START,
       pval015 P_TITLE,
       pval016 P_VENDOR_ASSIGNMENT_NUMBER,
       pval017 P_VENDOR_EMPLOYEE_NUMBER,
       pval018 P_PROJECTED_ASSIGNMENT_END,
       pval019 P_ATTRIBUTE_CATEGORY,
       pval020 P_ATTRIBUTE1,
       pval021 P_ATTRIBUTE2,
       pval022 P_ATTRIBUTE3,
       pval023 P_ATTRIBUTE4,
       pval024 P_ATTRIBUTE5,
       pval025 P_ATTRIBUTE6,
       pval026 P_ATTRIBUTE7,
       pval027 P_ATTRIBUTE8,
       pval028 P_ATTRIBUTE9,
       pval029 P_ATTRIBUTE10,
       pval030 P_ATTRIBUTE11,
       pval031 P_ATTRIBUTE12,
       pval032 P_ATTRIBUTE13,
       pval033 P_ATTRIBUTE14,
       pval034 P_ATTRIBUTE15,
       pval035 P_ATTRIBUTE16,
       pval036 P_ATTRIBUTE17,
       pval037 P_ATTRIBUTE18,
       pval038 P_ATTRIBUTE19,
       pval039 P_ATTRIBUTE20,
       pval040 P_ATTRIBUTE21,
       pval041 P_ATTRIBUTE22,
       pval042 P_ATTRIBUTE23,
       pval043 P_ATTRIBUTE24,
       pval044 P_ATTRIBUTE25,
       pval045 P_ATTRIBUTE26,
       pval046 P_ATTRIBUTE27,
       pval047 P_ATTRIBUTE28,
       pval048 P_ATTRIBUTE29,
       pval049 P_ATTRIBUTE30,
       pval050 P_PGP_SEGMENT1,
       pval051 P_PGP_SEGMENT2,
       pval052 P_PGP_SEGMENT3,
       pval053 P_PGP_SEGMENT4,
       pval054 P_PGP_SEGMENT5,
       pval055 P_PGP_SEGMENT6,
       pval056 P_PGP_SEGMENT7,
       pval057 P_PGP_SEGMENT8,
       pval058 P_PGP_SEGMENT9,
       pval059 P_PGP_SEGMENT10,
       pval060 P_PGP_SEGMENT11,
       pval061 P_PGP_SEGMENT12,
       pval062 P_PGP_SEGMENT13,
       pval063 P_PGP_SEGMENT14,
       pval064 P_PGP_SEGMENT15,
       pval065 P_PGP_SEGMENT16,
       pval066 P_PGP_SEGMENT17,
       pval067 P_PGP_SEGMENT18,
       pval068 P_PGP_SEGMENT19,
       pval069 P_PGP_SEGMENT20,
       pval070 P_PGP_SEGMENT21,
       pval071 P_PGP_SEGMENT22,
       pval072 P_PGP_SEGMENT23,
       pval073 P_PGP_SEGMENT24,
       pval074 P_PGP_SEGMENT25,
       pval075 P_PGP_SEGMENT26,
       pval076 P_PGP_SEGMENT27,
       pval077 P_PGP_SEGMENT28,
       pval078 P_PGP_SEGMENT29,
       pval079 P_PGP_SEGMENT30,
       pval080 P_SCL_CONCAT_SEGMENTS,
       pval081 P_PGP_CONCAT_SEGMENTS,
       pval082 P_ASSIGNMENT_USER_KEY,
       pval083 P_OBJECT_VERSION_NUMBER,
       pval084 P_EFFECTIVE_START_DATE,
       pval085 P_EFFECTIVE_END_DATE,
       pval086 P_ASSIGNMENT_SEQUENCE,
       pval087 P_COMMENT_ID,
       pval088 P_PEOPLE_GROUP_ID,
       pval089 P_PEOPLE_GROUP_NAME,
       pval090 P_OTHER_MANAGER_WARNING,
       pval091 P_HOURLY_SALARIED_WARNING,
       pval092 P_SOFT_CODING_KEYFLEX_ID,
       pval093 P_PERSON_USER_KEY,
       pval094 P_ORGANIZATION_NAME,
       pval095 P_LANGUAGE_CODE,
       pval096 P_USER_STATUS,
       pval097 P_DEFAULT_CODE_COMB_USER_KEY,
       pval098 P_ESTABLISHMENT_ORG_NAME,
       pval099 P_JOB_NAME,
       pval100 P_LOCATION_CODE,
       pval101 P_POSITION_NAME,
       pval102 P_GRADE_NAME,
       pval103 P_SET_OF_BOOKS_NAME,
       pval104 P_SUPERVISOR_USER_KEY,
       pval105 P_VENDOR_NAME,
       pval106 P_VENDOR_SITE_ID,
       pval107 P_PO_HEADER_ID,
       pval108 P_PO_LINE_ID,
       pval109 P_SCL_CONTRACTOR_NAME,
       pval110 P_SVR_ASSIGNMENT_USER_KEY
from hr_pump_batch_lines
where api_module_id = 3215
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_ASSIGNMENT_NUMBER
, PVAL003 P_ASSIGNMENT_CATEGORY
, PVAL004 P_CHANGE_REASON
, PVAL005 P_COMMENTS
, PVAL006 P_FREQUENCY
, PVAL007 P_INTERNAL_ADDRESS_LINE
, PVAL008 P_LABOUR_UNION_MEMBER_FLAG
, PVAL009 P_MANAGER_FLAG
, PVAL010 P_NORMAL_HOURS
, PVAL011 P_PROJECT_TITLE
, PVAL012 P_SOURCE_TYPE
, PVAL013 P_TIME_NORMAL_FINISH
, PVAL014 P_TIME_NORMAL_START
, PVAL015 P_TITLE
, PVAL016 P_VENDOR_ASSIGNMENT_NUMBER
, PVAL017 P_VENDOR_EMPLOYEE_NUMBER
, PVAL018 P_PROJECTED_ASSIGNMENT_END
, PVAL019 P_ATTRIBUTE_CATEGORY
, PVAL020 P_ATTRIBUTE1
, PVAL021 P_ATTRIBUTE2
, PVAL022 P_ATTRIBUTE3
, PVAL023 P_ATTRIBUTE4
, PVAL024 P_ATTRIBUTE5
, PVAL025 P_ATTRIBUTE6
, PVAL026 P_ATTRIBUTE7
, PVAL027 P_ATTRIBUTE8
, PVAL028 P_ATTRIBUTE9
, PVAL029 P_ATTRIBUTE10
, PVAL030 P_ATTRIBUTE11
, PVAL031 P_ATTRIBUTE12
, PVAL032 P_ATTRIBUTE13
, PVAL033 P_ATTRIBUTE14
, PVAL034 P_ATTRIBUTE15
, PVAL035 P_ATTRIBUTE16
, PVAL036 P_ATTRIBUTE17
, PVAL037 P_ATTRIBUTE18
, PVAL038 P_ATTRIBUTE19
, PVAL039 P_ATTRIBUTE20
, PVAL040 P_ATTRIBUTE21
, PVAL041 P_ATTRIBUTE22
, PVAL042 P_ATTRIBUTE23
, PVAL043 P_ATTRIBUTE24
, PVAL044 P_ATTRIBUTE25
, PVAL045 P_ATTRIBUTE26
, PVAL046 P_ATTRIBUTE27
, PVAL047 P_ATTRIBUTE28
, PVAL048 P_ATTRIBUTE29
, PVAL049 P_ATTRIBUTE30
, PVAL050 P_PGP_SEGMENT1
, PVAL051 P_PGP_SEGMENT2
, PVAL052 P_PGP_SEGMENT3
, PVAL053 P_PGP_SEGMENT4
, PVAL054 P_PGP_SEGMENT5
, PVAL055 P_PGP_SEGMENT6
, PVAL056 P_PGP_SEGMENT7
, PVAL057 P_PGP_SEGMENT8
, PVAL058 P_PGP_SEGMENT9
, PVAL059 P_PGP_SEGMENT10
, PVAL060 P_PGP_SEGMENT11
, PVAL061 P_PGP_SEGMENT12
, PVAL062 P_PGP_SEGMENT13
, PVAL063 P_PGP_SEGMENT14
, PVAL064 P_PGP_SEGMENT15
, PVAL065 P_PGP_SEGMENT16
, PVAL066 P_PGP_SEGMENT17
, PVAL067 P_PGP_SEGMENT18
, PVAL068 P_PGP_SEGMENT19
, PVAL069 P_PGP_SEGMENT20
, PVAL070 P_PGP_SEGMENT21
, PVAL071 P_PGP_SEGMENT22
, PVAL072 P_PGP_SEGMENT23
, PVAL073 P_PGP_SEGMENT24
, PVAL074 P_PGP_SEGMENT25
, PVAL075 P_PGP_SEGMENT26
, PVAL076 P_PGP_SEGMENT27
, PVAL077 P_PGP_SEGMENT28
, PVAL078 P_PGP_SEGMENT29
, PVAL079 P_PGP_SEGMENT30
, PVAL080 P_SCL_CONCAT_SEGMENTS
, PVAL081 P_PGP_CONCAT_SEGMENTS
, PVAL082 P_ASSIGNMENT_USER_KEY
, PVAL083 P_OBJECT_VERSION_NUMBER
, PVAL084 P_EFFECTIVE_START_DATE
, PVAL085 P_EFFECTIVE_END_DATE
, PVAL086 P_ASSIGNMENT_SEQUENCE
, PVAL087 P_COMMENT_ID
, PVAL088 P_PEOPLE_GROUP_ID
, PVAL089 P_PEOPLE_GROUP_NAME
, PVAL090 P_OTHER_MANAGER_WARNING
, PVAL091 P_HOURLY_SALARIED_WARNING
, PVAL092 P_SOFT_CODING_KEYFLEX_ID
, PVAL093 P_PERSON_USER_KEY
, PVAL094 P_ORGANIZATION_NAME
, PVAL095 P_LANGUAGE_CODE
, PVAL096 P_USER_STATUS
, PVAL097 P_DEFAULT_CODE_COMB_USER_KEY
, PVAL098 P_ESTABLISHMENT_ORG_NAME
, PVAL099 P_JOB_NAME
, PVAL100 P_LOCATION_CODE
, PVAL101 P_POSITION_NAME
, PVAL102 P_GRADE_NAME
, PVAL103 P_SET_OF_BOOKS_NAME
, PVAL104 P_SUPERVISOR_USER_KEY
, PVAL105 P_VENDOR_NAME
, PVAL106 P_VENDOR_SITE_ID
, PVAL107 P_PO_HEADER_ID
, PVAL108 P_PO_LINE_ID
, PVAL109 P_SCL_CONTRACTOR_NAME
, PVAL110 P_SVR_ASSIGNMENT_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 3215 WITH CHECK OPTION