[Home] [Help]
[Dependency Information]
Object Name: | HR_ALL_ORGANIZATION_UNITS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | ![]() ![]() |
Subobject Name: | |
Status: | VALID |
HR_ALL_ORGANIZATION_UNITS holds the definitions that identify business
groups and the organization units within a single business group.
Additional information about classifications and information types for
each organization is held in HR_ORGANIZATION_INFORMATION.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_ORGANIZATION_UNITS_PK | NORMAL | UNIQUE |
![]() |
![]() |
HR_ORGANIZATION_UNITS_UK2 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
HR_ORGANIZATION_UNITS_FK1 | NORMAL | NONUNIQUE |
![]() |
![]() |
HR_ORGANIZATION_UNITS_FK2 | NORMAL | NONUNIQUE |
![]() |
![]() |
HR_ORGANIZATION_UNITS_FK3 | NORMAL | NONUNIQUE |
![]() |
![]() |
HR_ORGANIZATION_UNITS_FK4 | NORMAL | NONUNIQUE |
![]() |
![]() |
Table | |
Foreign Table | Foreign Key Column | HR_ALL_ORGANIZATION_UNITS | ![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS BUSINESS_GROUP_ID | HR_ALL_ORGANIZATION_UNITS | ![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS SOFT_CODING_KEYFLEX_ID | HR_ALL_ORGANIZATION_UNITS | ![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS LOCATION_ID | HR_ALL_ORGANIZATION_UNITS | ![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS COST_ALLOCATION_KEYFLEX_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | BEN_BENEFIT_CONTRIBUTIONS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT OLD_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT NEW_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT TARGET_POSITION_ORG_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_MASS_SALARIES ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_MASS_TRANSFERS OLD_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | GHR_PA_REQUESTS TO_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ALL_ORGANIZATION_UNITS SOFT_CODING_KEYFLEX_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ALL_ORGANIZATION_UNITS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ALL_POSITIONS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ALL_POSITIONS_F ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ASSIGNMENT_SETS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_ORGANIZATION_INFORMATION ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_QUESTIONNAIRES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_QUEST_ANSWERS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | HR_TIPS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ACCRUAL_BANDS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ACCRUAL_PLANS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ALL_PAYROLLS_F ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ALL_PAYROLLS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_CONSOLIDATION_SETS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_COST_ALLOCATIONS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ELEMENT_LINKS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ELEMENT_LINKS_F ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ELE_PAYROLL_FREQ_RULES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_FREQ_RULE_PERIODS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_GRADE_RULES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_JOB_WC_CODE_USAGES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_NET_CALCULATION_RULES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_ORG_PAYMENT_METHODS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_PAYROLL_ACTIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_PERSONAL_PAYMENT_METHODS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_RATES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_SECURITY_PAYROLLS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_US_EMP_CITY_TAX_RULES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_US_EMP_COUNTY_TAX_RULES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_US_EMP_FED_TAX_RULES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_US_EMP_STATE_TAX_RULES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WCI_ACCOUNTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WCI_OCCUPATIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WCI_RATES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WC_FUNDS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WC_FUNDS CARRIER_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PAY_WC_RATES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ABSENCE_ATTENDANCES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ABSENCE_ATTENDANCE_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ABS_ATTENDANCE_REASONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ADDRESSES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_ASSIGNMENTS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_ASSIGNMENTS_F SOURCE_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_ASSIGNMENTS_F ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_ASSIGNMENTS_F ESTABLISHMENT_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_PEOPLE_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_POSITIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_POSITIONS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_VACANCIES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ALL_VACANCIES ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_APPLICATIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_APPRAISALS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_APPRAISAL_TEMPLATES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ASSESSMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ASSESSMENT_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ASSIGNMENT_BUDGET_VALUES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ASS_STATUS_TYPE_AMENDS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BF_BALANCE_AMOUNTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BF_BALANCE_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BF_PAYMENT_DETAILS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BF_PAYROLL_RUNS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BOOKINGS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BUDGETS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BUDGET_ELEMENTS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BUDGET_ELEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BUDGET_VALUES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_BUDGET_VERSIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_CAREER_PATHS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_CAREER_PATH_ELEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COBRA_COVERAGE_BENEFITS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COBRA_COVERAGE_STATUSES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COBRA_COV_ENROLLMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COLLECTIVE_AGREEMENTS EMPLOYER_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COLLECTIVE_AGREEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COLLECTIVE_AGREEMENTS BARGAINING_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COMPETENCES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COMPETENCE_ELEMENTS ENTERPRISE_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COMPETENCE_ELEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_COMPETENCE_ELEMENTS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_CONTACT_RELATIONSHIPS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_CONTRACTS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_DEPLOYMENT_FACTORS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_DISABILITIES_F ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ELECTIONS REP_BODY_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ELECTIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ELECTION_CANDIDATES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ELECTION_CONSTITUENCYS CONSTITUENCY_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ESTABLISHMENT_ATTENDANCES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_EVENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_EVENTS ORGANIZATION_RUN_BY_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_GRADES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_GRADE_SPINES_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_JOBS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_JOB_EVALUATIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_JOB_GROUPS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_JOB_REQUIREMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_LETTER_GEN_STATUSES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_LETTER_REQUESTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_LETTER_REQUEST_LINES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_LETTER_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_MASS_MOVES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_MEDICAL_ASSESSMENTS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_NUMBER_GENERATION_CONTROLS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_OBJECTIVES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORGANIZATION_LIST ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORGANIZATION_STRUCTURES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORG_STRUCTURE_ELEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORG_STRUCTURE_ELEMENTS ORGANIZATION_ID_CHILD |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORG_STRUCTURE_ELEMENTS ORGANIZATION_ID_PARENT |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ORG_STRUCTURE_VERSIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PARENT_SPINES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PARTICIPANTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PAY_BASES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PAY_PROPOSALS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PAY_PROPOSAL_COMPONENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PERIODS_OF_SERVICE BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PERSON_ANALYSES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_PERSON_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_POSITION_STRUCTURES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_POS_STRUCTURE_ELEMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_POS_STRUCTURE_VERSIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_QUALIFICATIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_RATING_LEVELS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_RATING_SCALES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_RECRUITMENT_ACTIVITIES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_RECRUITMENT_ACTIVITIES RUN_BY_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_RECRUITMENT_ACTIVITY_FOR BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_REQUISITIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_ROLES ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SALARY_SURVEY_MAPPINGS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SALARY_SURVEY_MAPPINGS COMPANY_ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SCHED_COBRA_PAYMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SECONDARY_ASS_STATUSES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SECURITY_ORGANIZATIONS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SECURITY_PROFILES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SECURITY_PROFILES ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SEC_PROFILE_ASSIGNMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SPECIAL_INFO_TYPES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SPINAL_POINTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SPINAL_POINT_PLACEMENTS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SPINAL_POINT_STEPS_F BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_SUCCESSION_PLANNING BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PER_VALID_GRADES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_BUDGET_DETAILS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_COPY_ENTITY_TXNS CONTEXT_BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_DFLT_BUDGET_SETS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_POSITION_TRANSACTIONS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_POSITION_TRANSACTIONS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_ROLES BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_RULE_SETS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_RULE_SETS ORGANIZATION_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_TXN_JOB_REQUIREMENTS BUSINESS_GROUP_ID |
![]() |
![]() |
HR_ALL_ORGANIZATION_UNITS | PQH_WORKSHEET_DETAILS ORGANIZATION_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | (15) | Yes | System-generated primary key column. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
COST_ALLOCATION_KEYFLEX_ID | NUMBER | (9) | Foreign key to PAY_COST_ALLOCATION_KEYFLEX. | |
LOCATION_ID | NUMBER | (15) | Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization. | |
SOFT_CODING_KEYFLEX_ID | NUMBER | (15) | Column obsolete | |
DATE_FROM | DATE | Yes | Start date of the organization. | |
NAME | VARCHAR2 | (240) | Yes | Name of the organization. |
DATE_TO | DATE | End date of the organization. | ||
INTERNAL_EXTERNAL_FLAG | VARCHAR2 | (30) | Identifies whether the organization is treated as an employment unit within the business group. | |
INTERNAL_ADDRESS_LINE | VARCHAR2 | (80) | Internal address line. | |
TYPE | VARCHAR2 | (30) | User-defined organization types, for example Region, Division, Department. | |
REQUEST_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update. | |
PARTY_ID | NUMBER | (15) | Foreign key to HZ_PARTIES. Not currently used, reserved for future use. | |
COMMENTS | LONG | (0) | General remark. | |
ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield column. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, COST_ALLOCATION_KEYFLEX_ID
, LOCATION_ID
, SOFT_CODING_KEYFLEX_ID
, DATE_FROM
, NAME
, DATE_TO
, INTERNAL_EXTERNAL_FLAG
, INTERNAL_ADDRESS_LINE
, TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, PARTY_ID
, COMMENTS
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM HR.HR_ALL_ORGANIZATION_UNITS;
HR.HR_ALL_ORGANIZATION_UNITS does not reference any database object
HR.HR_ALL_ORGANIZATION_UNITS is referenced by following:
|
|
|