[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_BDGTS_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_BDGTS_CT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HRI_MB_BDGTS_CT_ID |
HRI_MB_BDGTS_CT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUDGET_MEASUREMENT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HRI_MB_BDGTS_CT_ID | NUMBER | (15) | Yes | |
BUDGET_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
BUDGETED_ENTITY_CD | VARCHAR2 | (30) | Yes | |
BUDGET_MEASUREMENT_TYPE | VARCHAR2 | (30) | Yes | |
BUDGET_CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
BUDGET_AGGREGATE | VARCHAR2 | (30) | Yes | |
BUDGET_START_DATE | DATE | Yes | ||
BUDGET_END_DATE | DATE | Yes | ||
BUDGET_VERSION_ID | NUMBER | (15) | Yes | |
VERSION_START_DATE | DATE | Yes | ||
VERSION_END_DATE | DATE | Yes | ||
BUDGET_DETAIL_ID | NUMBER | (15) | Yes | |
ORGANIZATION_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | ||
BUDGET_PERIOD_ID | NUMBER | (15) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
BUDGET_SET_ID | NUMBER | (15) | ||
BUDGET_ELEMENT_ID | NUMBER | (15) | ||
ELEMENT_TYPE_ID | NUMBER | (15) | ||
BUDGET_FUND_SRC_ID | NUMBER | (15) | ||
COST_ALLOCATION_KEYFLEX_ID | NUMBER | (15) | ||
BUDGET_VALUE | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT HRI_MB_BDGTS_CT_ID
, BUDGET_ID
, BUSINESS_GROUP_ID
, BUDGETED_ENTITY_CD
, BUDGET_MEASUREMENT_TYPE
, BUDGET_CURRENCY_CODE
, BUDGET_AGGREGATE
, BUDGET_START_DATE
, BUDGET_END_DATE
, BUDGET_VERSION_ID
, VERSION_START_DATE
, VERSION_END_DATE
, BUDGET_DETAIL_ID
, ORGANIZATION_ID
, JOB_ID
, POSITION_ID
, GRADE_ID
, BUDGET_PERIOD_ID
, PERIOD_START_DATE
, PERIOD_END_DATE
, BUDGET_SET_ID
, BUDGET_ELEMENT_ID
, ELEMENT_TYPE_ID
, BUDGET_FUND_SRC_ID
, COST_ALLOCATION_KEYFLEX_ID
, BUDGET_VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM HRI.HRI_MB_BDGTS_CT;
HRI.HRI_MB_BDGTS_CT does not reference any database object
HRI.HRI_MB_BDGTS_CT is referenced by following:
|
|
|