VIEW: APPS.JTF_RS_REP_MANAGERS_VL

Source

View Text - Preformatted

SELECT MGR.DENORM_MGR_ID DENORM_MGR_ID , MGR.PERSON_ID PERSON_ID , MGR.RESOURCE_ID RESOURCE_ID , MGR.CATEGORY CATEGORY , MGR.MANAGER_PERSON_ID MANAGER_PERSON_ID , MGR.GROUP_ID GROUP_ID , MGR.REPORTS_TO_FLAG REPORTS_TO_FLAG , MGR.LAST_UPDATE_DATE LAST_UPDATE_DATE , MGR.LAST_UPDATED_BY LAST_UPDATED_BY , MGR.CREATION_DATE CREATION_DATE , MGR.CREATED_BY CREATED_BY , MGR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , MGR.START_DATE_ACTIVE START_DATE_ACTIVE , MGR.END_DATE_ACTIVE END_DATE_ACTIVE ,MGR.HIERARCHY_TYPE HIERARCHY_TYPE , MGR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , MGR.ATTRIBUTE1 , MGR.ATTRIBUTE2 , MGR.ATTRIBUTE3 , MGR.ATTRIBUTE4 , MGR.ATTRIBUTE5 , MGR.ATTRIBUTE6 , MGR.ATTRIBUTE7 , MGR.ATTRIBUTE8 , MGR.ATTRIBUTE9 , MGR.ATTRIBUTE10 , MGR.ATTRIBUTE11 , MGR.ATTRIBUTE12 , MGR.ATTRIBUTE13 , MGR.ATTRIBUTE14 , MGR.ATTRIBUTE15 , MGR.DENORM_LEVEL FROM JTF_RS_REP_MANAGERS MGR

View Text - HTML Formatted

SELECT MGR.DENORM_MGR_ID DENORM_MGR_ID
, MGR.PERSON_ID PERSON_ID
, MGR.RESOURCE_ID RESOURCE_ID
, MGR.CATEGORY CATEGORY
, MGR.MANAGER_PERSON_ID MANAGER_PERSON_ID
, MGR.GROUP_ID GROUP_ID
, MGR.REPORTS_TO_FLAG REPORTS_TO_FLAG
, MGR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MGR.LAST_UPDATED_BY LAST_UPDATED_BY
, MGR.CREATION_DATE CREATION_DATE
, MGR.CREATED_BY CREATED_BY
, MGR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MGR.START_DATE_ACTIVE START_DATE_ACTIVE
, MGR.END_DATE_ACTIVE END_DATE_ACTIVE
, MGR.HIERARCHY_TYPE HIERARCHY_TYPE
, MGR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MGR.ATTRIBUTE1
, MGR.ATTRIBUTE2
, MGR.ATTRIBUTE3
, MGR.ATTRIBUTE4
, MGR.ATTRIBUTE5
, MGR.ATTRIBUTE6
, MGR.ATTRIBUTE7
, MGR.ATTRIBUTE8
, MGR.ATTRIBUTE9
, MGR.ATTRIBUTE10
, MGR.ATTRIBUTE11
, MGR.ATTRIBUTE12
, MGR.ATTRIBUTE13
, MGR.ATTRIBUTE14
, MGR.ATTRIBUTE15
, MGR.DENORM_LEVEL
FROM JTF_RS_REP_MANAGERS MGR