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

TABLE: HRI.HRI_CS_PER_ORGCC_CT

Object Details
Object Name: HRI_CS_PER_ORGCC_CT
Object Type: TABLE
Owner: HRI
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.

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_CS_PER_ORGCC_CT_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnORGANIZATION_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
HRI_CS_PER_ORGCC_CT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCC_MNGR_PERSON_ID
Columns
Name Datatype Length Mandatory Comments
CC_MNGR_PERSON_ID NUMBER (22) Yes Cost Centre Manager Person Id
COST_CENTRE_CODE VARCHAR2 (150) Yes COST_CENTRE_CODE
ORGANIZATION_ID NUMBER (22) Yes ORGANIZATION_ID
EFFECTIVE_START_DATE DATE
Yes EFFECTIVE_START_DATE
EFFECTIVE_END_DATE DATE
Yes EFFECTIVE_END_DATE
COMPANY_CODE VARCHAR2 (150)
COMPANY_CODE
REPORTING_NAME VARCHAR2 (150)
REPORTING_NAME
LAST_CHANGE_DATE DATE

LAST_CHANGE_DATE
CREATION_DATE DATE

Standard WHO Column
CREATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_DATE DATE

Standard WHO Column
LAST_UPDATED_BY NUMBER

Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
Query Text

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


SELECT CC_MNGR_PERSON_ID
,      COST_CENTRE_CODE
,      ORGANIZATION_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      COMPANY_CODE
,      REPORTING_NAME
,      LAST_CHANGE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HRI.HRI_CS_PER_ORGCC_CT;

Dependencies

[top of page]

HRI.HRI_CS_PER_ORGCC_CT does not reference any database object

HRI.HRI_CS_PER_ORGCC_CT is referenced by following:

SchemaAPPS
SynonymHRI_CS_PER_ORGCC_CT
TriggerHRI_CS_PER_ORGCC_CT_WHO