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

TABLE: HRI.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT

Object Details
Object Name: HRI_MDP_BDGTS_LBRCST_ORGMGR_CT
Object Type: TABLE
Owner: HRI
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_MDP_BDGTS_LBRCST_ORGMGR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGMGR_ID
ColumnORGANIZATION_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
ORGMGR_ID NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
ORGANIZATION_ID NUMBER (15)
JOB_ID NUMBER (15)
POSITION_ID NUMBER (15)
GRADE_ID NUMBER (15)
ELEMENT_TYPE_ID NUMBER (15)
INPUT_VALUE_ID NUMBER (15)
COST_ALLOCATION_KEYFLEX_ID NUMBER (15)
BUDGET_VALUE NUMBER

DR_BUDGET_VALUE NUMBER

CURRENCY_CODE VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ORGMGR_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      ELEMENT_TYPE_ID
,      INPUT_VALUE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      BUDGET_VALUE
,      DR_BUDGET_VALUE
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HRI.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT;

Dependencies

[top of page]

HRI.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT does not reference any database object

HRI.HRI_MDP_BDGTS_LBRCST_ORGMGR_CT is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_BDGTS_LBRCST_MV
SynonymHRI_MDP_BDGTS_LBRCST_ORGMGR_CT
TriggerHRI_MDP_BDGTS_LBRCST_ORGMG_WHO
Materialized ViewHRI_MDP_BDGTS_LBRCST_ORG_MV