DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HXC_RESOURCE_INFORMATION_V

Object Details
Object Name: HXC_RESOURCE_INFORMATION_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHXC.HXC_RESOURCE_INFORMATION_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Yes
RESOURCE_DISPLAY_LABEL VARCHAR2 (240)
RESOURCE_NUMBER VARCHAR2 (30)
NATIONAL_IDENTIFIER VARCHAR2 (30)
HIRE_DATE DATE

JOB_TITLE VARCHAR2 (700)
ORGANIZATION_NAME VARCHAR2 (240) Yes
SUPERVISOR_NAME VARCHAR2 (240)
SUPERVISOR_NUMBER VARCHAR2 (30)
PER_INFORMATION_CATEGORY VARCHAR2 (30)
PER_INFORMATION1 VARCHAR2 (150)
PER_INFORMATION2 VARCHAR2 (150)
PER_INFORMATION3 VARCHAR2 (150)
PER_INFORMATION4 VARCHAR2 (150)
PER_INFORMATION5 VARCHAR2 (150)
PER_INFORMATION6 VARCHAR2 (150)
PER_INFORMATION7 VARCHAR2 (150)
PER_INFORMATION8 VARCHAR2 (150)
PER_INFORMATION9 VARCHAR2 (150)
PER_INFORMATION10 VARCHAR2 (150)
PER_INFORMATION11 VARCHAR2 (150)
PER_INFORMATION12 VARCHAR2 (150)
PER_INFORMATION13 VARCHAR2 (150)
PER_INFORMATION14 VARCHAR2 (150)
PER_INFORMATION15 VARCHAR2 (150)
PER_INFORMATION16 VARCHAR2 (150)
PER_INFORMATION17 VARCHAR2 (150)
PER_INFORMATION18 VARCHAR2 (150)
PER_INFORMATION19 VARCHAR2 (150)
PER_INFORMATION20 VARCHAR2 (150)
PER_INFORMATION21 VARCHAR2 (150)
PER_INFORMATION22 VARCHAR2 (150)
PER_INFORMATION23 VARCHAR2 (150)
PER_INFORMATION24 VARCHAR2 (150)
PER_INFORMATION25 VARCHAR2 (150)
PER_INFORMATION26 VARCHAR2 (150)
PER_INFORMATION27 VARCHAR2 (150)
PER_INFORMATION28 VARCHAR2 (150)
PER_INFORMATION29 VARCHAR2 (150)
PER_INFORMATION30 VARCHAR2 (150)
OFFICE VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
AVAILABILITY_SCHEDULE VARCHAR2 (80)
FULLTIME_AVAILABILITY NUMBER (5)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
GRADE_NAME VARCHAR2 (240)
ASSIGNMENT_LOCATION VARCHAR2 (60)
ASSIGNMENT_PEOPLE_GROUP VARCHAR2 (240)
ASSIGNMENT_POSITION VARCHAR2 (240)
ASSIGNMENT_PAYROLL VARCHAR2 (80)
ASSIGNMENT_STATUS VARCHAR2 (80) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)
EMPLOYMENT_CATEGORY VARCHAR2 (30)
NORMAL_HOURS NUMBER (22)
NORMAL_HOURS_FREQUENCY VARCHAR2 (80)
NORMAL_START_TIME VARCHAR2 (5)
NORMAL_FINISH_TIME VARCHAR2 (5)
SOFT_CODED_KEYFLEX1 VARCHAR2 (60)
SOFT_CODED_KEYFLEX2 VARCHAR2 (60)
SOFT_CODED_KEYFLEX3 VARCHAR2 (60)
SOFT_CODED_KEYFLEX4 VARCHAR2 (60)
SOFT_CODED_KEYFLEX5 VARCHAR2 (60)
SOFT_CODED_KEYFLEX6 VARCHAR2 (60)
SOFT_CODED_KEYFLEX7 VARCHAR2 (60)
SOFT_CODED_KEYFLEX8 VARCHAR2 (60)
SOFT_CODED_KEYFLEX9 VARCHAR2 (60)
SOFT_CODED_KEYFLEX10 VARCHAR2 (60)
SOFT_CODED_KEYFLEX11 VARCHAR2 (60)
SOFT_CODED_KEYFLEX12 VARCHAR2 (60)
SOFT_CODED_KEYFLEX13 VARCHAR2 (60)
SOFT_CODED_KEYFLEX14 VARCHAR2 (60)
SOFT_CODED_KEYFLEX15 VARCHAR2 (60)
SOFT_CODED_KEYFLEX16 VARCHAR2 (60)
SOFT_CODED_KEYFLEX17 VARCHAR2 (60)
SOFT_CODED_KEYFLEX18 VARCHAR2 (60)
SOFT_CODED_KEYFLEX19 VARCHAR2 (60)
SOFT_CODED_KEYFLEX20 VARCHAR2 (60)
SOFT_CODED_KEYFLEX21 VARCHAR2 (60)
SOFT_CODED_KEYFLEX22 VARCHAR2 (60)
SOFT_CODED_KEYFLEX23 VARCHAR2 (60)
SOFT_CODED_KEYFLEX24 VARCHAR2 (60)
SOFT_CODED_KEYFLEX25 VARCHAR2 (60)
SOFT_CODED_KEYFLEX26 VARCHAR2 (60)
SOFT_CODED_KEYFLEX27 VARCHAR2 (60)
SOFT_CODED_KEYFLEX28 VARCHAR2 (60)
SOFT_CODED_KEYFLEX29 VARCHAR2 (60)
SOFT_CODED_KEYFLEX30 VARCHAR2 (60)
BARGAINING_UNIT_CODE VARCHAR2 (30)
SALARY_BASIS VARCHAR2 (30)
COLLECTIVE_AGREEMENT VARCHAR2 (80)
AGREEMENT_GRADE1 VARCHAR2 (150)
AGREEMENT_GRADE2 VARCHAR2 (150)
AGREEMENT_GRADE3 VARCHAR2 (150)
AGREEMENT_GRADE4 VARCHAR2 (150)
AGREEMENT_GRADE5 VARCHAR2 (150)
AGREEMENT_GRADE6 VARCHAR2 (150)
AGREEMENT_GRADE7 VARCHAR2 (150)
AGREEMENT_GRADE8 VARCHAR2 (150)
AGREEMENT_GRADE9 VARCHAR2 (150)
AGREEMENT_GRADE10 VARCHAR2 (150)
AGREEMENT_GRADE11 VARCHAR2 (150)
AGREEMENT_GRADE12 VARCHAR2 (150)
AGREEMENT_GRADE13 VARCHAR2 (150)
AGREEMENT_GRADE14 VARCHAR2 (150)
AGREEMENT_GRADE15 VARCHAR2 (150)
AGREEMENT_GRADE16 VARCHAR2 (150)
AGREEMENT_GRADE17 VARCHAR2 (150)
AGREEMENT_GRADE18 VARCHAR2 (150)
AGREEMENT_GRADE19 VARCHAR2 (150)
AGREEMENT_GRADE20 VARCHAR2 (150)
COST_ALLOCATION1 VARCHAR2 (60)
COST_ALLOCATION2 VARCHAR2 (60)
COST_ALLOCATION3 VARCHAR2 (60)
COST_ALLOCATION4 VARCHAR2 (60)
COST_ALLOCATION5 VARCHAR2 (60)
COST_ALLOCATION6 VARCHAR2 (60)
COST_ALLOCATION7 VARCHAR2 (60)
COST_ALLOCATION8 VARCHAR2 (60)
COST_ALLOCATION9 VARCHAR2 (60)
COST_ALLOCATION10 VARCHAR2 (60)
COST_ALLOCATION11 VARCHAR2 (60)
COST_ALLOCATION12 VARCHAR2 (60)
COST_ALLOCATION13 VARCHAR2 (60)
COST_ALLOCATION14 VARCHAR2 (60)
COST_ALLOCATION15 VARCHAR2 (60)
COST_ALLOCATION16 VARCHAR2 (60)
COST_ALLOCATION17 VARCHAR2 (60)
COST_ALLOCATION18 VARCHAR2 (60)
COST_ALLOCATION19 VARCHAR2 (60)
COST_ALLOCATION20 VARCHAR2 (60)
COST_ALLOCATION21 VARCHAR2 (60)
COST_ALLOCATION22 VARCHAR2 (60)
COST_ALLOCATION23 VARCHAR2 (60)
COST_ALLOCATION24 VARCHAR2 (60)
COST_ALLOCATION25 VARCHAR2 (60)
COST_ALLOCATION26 VARCHAR2 (60)
COST_ALLOCATION27 VARCHAR2 (60)
COST_ALLOCATION28 VARCHAR2 (60)
COST_ALLOCATION29 VARCHAR2 (60)
COST_ALLOCATION30 VARCHAR2 (60)
JOB_DFF_ATTRIBUTE1 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE2 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE3 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE4 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE5 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE6 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE7 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE8 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE9 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE10 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE11 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE12 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE13 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE14 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE15 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE16 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE17 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE18 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE19 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE20 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE1 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE2 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE3 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE4 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE5 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE6 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE7 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE8 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE9 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE10 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE11 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE12 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE13 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE14 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE15 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE16 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE17 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE18 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE19 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE20 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE1 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE2 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE3 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE4 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE5 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE6 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE7 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE8 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE9 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE10 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE11 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE12 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE13 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE14 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE15 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE16 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE17 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE18 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE19 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE20 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE21 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE22 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE23 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE24 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE25 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE26 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE27 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE28 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE29 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE30 VARCHAR2 (150)
PAYROLL_PERIOD_START_DATE DATE

PAYROLL_PERIOD_END_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_ID
,      RESOURCE_DISPLAY_LABEL
,      RESOURCE_NUMBER
,      NATIONAL_IDENTIFIER
,      HIRE_DATE
,      JOB_TITLE
,      ORGANIZATION_NAME
,      SUPERVISOR_NAME
,      SUPERVISOR_NUMBER
,      PER_INFORMATION_CATEGORY
,      PER_INFORMATION1
,      PER_INFORMATION2
,      PER_INFORMATION3
,      PER_INFORMATION4
,      PER_INFORMATION5
,      PER_INFORMATION6
,      PER_INFORMATION7
,      PER_INFORMATION8
,      PER_INFORMATION9
,      PER_INFORMATION10
,      PER_INFORMATION11
,      PER_INFORMATION12
,      PER_INFORMATION13
,      PER_INFORMATION14
,      PER_INFORMATION15
,      PER_INFORMATION16
,      PER_INFORMATION17
,      PER_INFORMATION18
,      PER_INFORMATION19
,      PER_INFORMATION20
,      PER_INFORMATION21
,      PER_INFORMATION22
,      PER_INFORMATION23
,      PER_INFORMATION24
,      PER_INFORMATION25
,      PER_INFORMATION26
,      PER_INFORMATION27
,      PER_INFORMATION28
,      PER_INFORMATION29
,      PER_INFORMATION30
,      OFFICE
,      INTERNAL_LOCATION
,      MAILSTOP
,      AVAILABILITY_SCHEDULE
,      FULLTIME_AVAILABILITY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      GRADE_NAME
,      ASSIGNMENT_LOCATION
,      ASSIGNMENT_PEOPLE_GROUP
,      ASSIGNMENT_POSITION
,      ASSIGNMENT_PAYROLL
,      ASSIGNMENT_STATUS
,      ASSIGNMENT_NUMBER
,      EMPLOYMENT_CATEGORY
,      NORMAL_HOURS
,      NORMAL_HOURS_FREQUENCY
,      NORMAL_START_TIME
,      NORMAL_FINISH_TIME
,      SOFT_CODED_KEYFLEX1
,      SOFT_CODED_KEYFLEX2
,      SOFT_CODED_KEYFLEX3
,      SOFT_CODED_KEYFLEX4
,      SOFT_CODED_KEYFLEX5
,      SOFT_CODED_KEYFLEX6
,      SOFT_CODED_KEYFLEX7
,      SOFT_CODED_KEYFLEX8
,      SOFT_CODED_KEYFLEX9
,      SOFT_CODED_KEYFLEX10
,      SOFT_CODED_KEYFLEX11
,      SOFT_CODED_KEYFLEX12
,      SOFT_CODED_KEYFLEX13
,      SOFT_CODED_KEYFLEX14
,      SOFT_CODED_KEYFLEX15
,      SOFT_CODED_KEYFLEX16
,      SOFT_CODED_KEYFLEX17
,      SOFT_CODED_KEYFLEX18
,      SOFT_CODED_KEYFLEX19
,      SOFT_CODED_KEYFLEX20
,      SOFT_CODED_KEYFLEX21
,      SOFT_CODED_KEYFLEX22
,      SOFT_CODED_KEYFLEX23
,      SOFT_CODED_KEYFLEX24
,      SOFT_CODED_KEYFLEX25
,      SOFT_CODED_KEYFLEX26
,      SOFT_CODED_KEYFLEX27
,      SOFT_CODED_KEYFLEX28
,      SOFT_CODED_KEYFLEX29
,      SOFT_CODED_KEYFLEX30
,      BARGAINING_UNIT_CODE
,      SALARY_BASIS
,      COLLECTIVE_AGREEMENT
,      AGREEMENT_GRADE1
,      AGREEMENT_GRADE2
,      AGREEMENT_GRADE3
,      AGREEMENT_GRADE4
,      AGREEMENT_GRADE5
,      AGREEMENT_GRADE6
,      AGREEMENT_GRADE7
,      AGREEMENT_GRADE8
,      AGREEMENT_GRADE9
,      AGREEMENT_GRADE10
,      AGREEMENT_GRADE11
,      AGREEMENT_GRADE12
,      AGREEMENT_GRADE13
,      AGREEMENT_GRADE14
,      AGREEMENT_GRADE15
,      AGREEMENT_GRADE16
,      AGREEMENT_GRADE17
,      AGREEMENT_GRADE18
,      AGREEMENT_GRADE19
,      AGREEMENT_GRADE20
,      COST_ALLOCATION1
,      COST_ALLOCATION2
,      COST_ALLOCATION3
,      COST_ALLOCATION4
,      COST_ALLOCATION5
,      COST_ALLOCATION6
,      COST_ALLOCATION7
,      COST_ALLOCATION8
,      COST_ALLOCATION9
,      COST_ALLOCATION10
,      COST_ALLOCATION11
,      COST_ALLOCATION12
,      COST_ALLOCATION13
,      COST_ALLOCATION14
,      COST_ALLOCATION15
,      COST_ALLOCATION16
,      COST_ALLOCATION17
,      COST_ALLOCATION18
,      COST_ALLOCATION19
,      COST_ALLOCATION20
,      COST_ALLOCATION21
,      COST_ALLOCATION22
,      COST_ALLOCATION23
,      COST_ALLOCATION24
,      COST_ALLOCATION25
,      COST_ALLOCATION26
,      COST_ALLOCATION27
,      COST_ALLOCATION28
,      COST_ALLOCATION29
,      COST_ALLOCATION30
,      JOB_DFF_ATTRIBUTE1
,      JOB_DFF_ATTRIBUTE2
,      JOB_DFF_ATTRIBUTE3
,      JOB_DFF_ATTRIBUTE4
,      JOB_DFF_ATTRIBUTE5
,      JOB_DFF_ATTRIBUTE6
,      JOB_DFF_ATTRIBUTE7
,      JOB_DFF_ATTRIBUTE8
,      JOB_DFF_ATTRIBUTE9
,      JOB_DFF_ATTRIBUTE10
,      JOB_DFF_ATTRIBUTE11
,      JOB_DFF_ATTRIBUTE12
,      JOB_DFF_ATTRIBUTE13
,      JOB_DFF_ATTRIBUTE14
,      JOB_DFF_ATTRIBUTE15
,      JOB_DFF_ATTRIBUTE16
,      JOB_DFF_ATTRIBUTE17
,      JOB_DFF_ATTRIBUTE18
,      JOB_DFF_ATTRIBUTE19
,      JOB_DFF_ATTRIBUTE20
,      POSITION_DFF_ATTRIBUTE1
,      POSITION_DFF_ATTRIBUTE2
,      POSITION_DFF_ATTRIBUTE3
,      POSITION_DFF_ATTRIBUTE4
,      POSITION_DFF_ATTRIBUTE5
,      POSITION_DFF_ATTRIBUTE6
,      POSITION_DFF_ATTRIBUTE7
,      POSITION_DFF_ATTRIBUTE8
,      POSITION_DFF_ATTRIBUTE9
,      POSITION_DFF_ATTRIBUTE10
,      POSITION_DFF_ATTRIBUTE11
,      POSITION_DFF_ATTRIBUTE12
,      POSITION_DFF_ATTRIBUTE13
,      POSITION_DFF_ATTRIBUTE14
,      POSITION_DFF_ATTRIBUTE15
,      POSITION_DFF_ATTRIBUTE16
,      POSITION_DFF_ATTRIBUTE17
,      POSITION_DFF_ATTRIBUTE18
,      POSITION_DFF_ATTRIBUTE19
,      POSITION_DFF_ATTRIBUTE20
,      ASSIGNMENT_ATTRIBUTE1
,      ASSIGNMENT_ATTRIBUTE2
,      ASSIGNMENT_ATTRIBUTE3
,      ASSIGNMENT_ATTRIBUTE4
,      ASSIGNMENT_ATTRIBUTE5
,      ASSIGNMENT_ATTRIBUTE6
,      ASSIGNMENT_ATTRIBUTE7
,      ASSIGNMENT_ATTRIBUTE8
,      ASSIGNMENT_ATTRIBUTE9
,      ASSIGNMENT_ATTRIBUTE10
,      ASSIGNMENT_ATTRIBUTE11
,      ASSIGNMENT_ATTRIBUTE12
,      ASSIGNMENT_ATTRIBUTE13
,      ASSIGNMENT_ATTRIBUTE14
,      ASSIGNMENT_ATTRIBUTE15
,      ASSIGNMENT_ATTRIBUTE16
,      ASSIGNMENT_ATTRIBUTE17
,      ASSIGNMENT_ATTRIBUTE18
,      ASSIGNMENT_ATTRIBUTE19
,      ASSIGNMENT_ATTRIBUTE20
,      ASSIGNMENT_ATTRIBUTE21
,      ASSIGNMENT_ATTRIBUTE22
,      ASSIGNMENT_ATTRIBUTE23
,      ASSIGNMENT_ATTRIBUTE24
,      ASSIGNMENT_ATTRIBUTE25
,      ASSIGNMENT_ATTRIBUTE26
,      ASSIGNMENT_ATTRIBUTE27
,      ASSIGNMENT_ATTRIBUTE28
,      ASSIGNMENT_ATTRIBUTE29
,      ASSIGNMENT_ATTRIBUTE30
,      PAYROLL_PERIOD_START_DATE
,      PAYROLL_PERIOD_END_DATE
FROM APPS.HXC_RESOURCE_INFORMATION_V;

Dependencies

[top of page]

APPS.HXC_RESOURCE_INFORMATION_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_LOOKUPS
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHR_SOFT_CODING_KEYFLEX
SynonymPAY_COST_ALLOCATIONS_F
SynonymPAY_COST_ALLOCATION_KEYFLEX
ViewPAY_PAYROLLS
SynonymPAY_PEOPLE_GROUPS
ViewPER_ASSIGNMENTS_F
ViewPER_ASSIGNMENT_STATUS_TYPES_V
SynonymPER_CAGR_GRADES_DEF
SynonymPER_COLLECTIVE_AGREEMENTS
SynonymPER_GRADES
SynonymPER_JOBS
SynonymPER_PAY_BASES
ViewPER_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
ViewPER_POSITIONS
SynonymPER_TIME_PERIODS

APPS.HXC_RESOURCE_INFORMATION_V is not referenced by any database object