VIEW: APPS.GHR_POSITION_DESCRIPTIONS_V

Source

View Text - Preformatted

SELECT PDI.ROWID ROW_ID , PDI.POSITION_DESCRIPTION_ID , PDI.BUSINESS_GROUP_ID , PDI.ROUTING_GROUP_ID , PDI.PA_REQUEST_ID , PDI.DATE_FROM , PDI.DATE_TO , PDI.OPM_CERT_NUM , PDI.FLSA , PDI.FINANCIAL_STATEMENT , PDI.SUBJECT_TO_IA_ACTION , PDI.POSITION_STATUS , PDI.POSITION_IS , PDI.POSITION_SENSITIVITY , PDI.COMPETITIVE_LEVEL , PDI.PD_REMARKS , PDI.POSITION_CLASS_STD , PDI.CATEGORY , PDI.CAREER_LADDER , PDI.SUPERVISOR_NAME , PDI.SUPERVISOR_TITLE , PDI.SUPERVISOR_DATE , PDI.MANAGER_NAME , PDI.MANAGER_TITLE , PDI.MANAGER_DATE , PDI.CLASSIFIER_NAME , PDI.CLASSIFIER_TITLE , PDI.CLASSIFIER_DATE , PDI.ATTRIBUTE_CATEGORY , PDI.ATTRIBUTE1 , PDI.ATTRIBUTE2 , PDI.ATTRIBUTE3 , PDI.ATTRIBUTE4 , PDI.ATTRIBUTE5 , PDI.ATTRIBUTE6 , PDI.ATTRIBUTE7 , PDI.ATTRIBUTE8 , PDI.ATTRIBUTE9 , PDI.ATTRIBUTE10 , PDI.ATTRIBUTE11 , PDI.ATTRIBUTE12 , PDI.ATTRIBUTE13 , PDI.ATTRIBUTE14 , PDI.ATTRIBUTE15 , PDI.ATTRIBUTE16 , PDI.ATTRIBUTE17 , PDI.ATTRIBUTE18 , PDI.ATTRIBUTE19 , PDI.ATTRIBUTE20 , PDI.CREATED_BY , PDI.CREATION_DATE , PDI.LAST_UPDATED_BY , PDI.LAST_UPDATE_DATE, PDI.LAST_UPDATE_LOGIN , PDI.OBJECT_VERSION_NUMBER FROM GHR_POSITION_DESCRIPTIONS PDI

View Text - HTML Formatted

SELECT PDI.ROWID ROW_ID
, PDI.POSITION_DESCRIPTION_ID
, PDI.BUSINESS_GROUP_ID
, PDI.ROUTING_GROUP_ID
, PDI.PA_REQUEST_ID
, PDI.DATE_FROM
, PDI.DATE_TO
, PDI.OPM_CERT_NUM
, PDI.FLSA
, PDI.FINANCIAL_STATEMENT
, PDI.SUBJECT_TO_IA_ACTION
, PDI.POSITION_STATUS
, PDI.POSITION_IS
, PDI.POSITION_SENSITIVITY
, PDI.COMPETITIVE_LEVEL
, PDI.PD_REMARKS
, PDI.POSITION_CLASS_STD
, PDI.CATEGORY
, PDI.CAREER_LADDER
, PDI.SUPERVISOR_NAME
, PDI.SUPERVISOR_TITLE
, PDI.SUPERVISOR_DATE
, PDI.MANAGER_NAME
, PDI.MANAGER_TITLE
, PDI.MANAGER_DATE
, PDI.CLASSIFIER_NAME
, PDI.CLASSIFIER_TITLE
, PDI.CLASSIFIER_DATE
, PDI.ATTRIBUTE_CATEGORY
, PDI.ATTRIBUTE1
, PDI.ATTRIBUTE2
, PDI.ATTRIBUTE3
, PDI.ATTRIBUTE4
, PDI.ATTRIBUTE5
, PDI.ATTRIBUTE6
, PDI.ATTRIBUTE7
, PDI.ATTRIBUTE8
, PDI.ATTRIBUTE9
, PDI.ATTRIBUTE10
, PDI.ATTRIBUTE11
, PDI.ATTRIBUTE12
, PDI.ATTRIBUTE13
, PDI.ATTRIBUTE14
, PDI.ATTRIBUTE15
, PDI.ATTRIBUTE16
, PDI.ATTRIBUTE17
, PDI.ATTRIBUTE18
, PDI.ATTRIBUTE19
, PDI.ATTRIBUTE20
, PDI.CREATED_BY
, PDI.CREATION_DATE
, PDI.LAST_UPDATED_BY
, PDI.LAST_UPDATE_DATE
, PDI.LAST_UPDATE_LOGIN
, PDI.OBJECT_VERSION_NUMBER
FROM GHR_POSITION_DESCRIPTIONS PDI