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

TABLE: HR.GHR_COMPL_AGENCY_COSTS

Object Details
Object Name: GHR_COMPL_AGENCY_COSTS
Object Type: TABLE
Owner: HR
FND Design Data: TableGHR.GHR_COMPL_AGENCY_COSTS
Subobject Name:
Status: VALID


GHR_COMPL_AGENCY_COSTS stores Compliant Agency Costs Information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GHR_COMPL_AGENCY_COSTS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPL_AGENCY_COST_ID
GHR_COMPL_AGENCY_COSTS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPLAINT_ID
Columns
Name Datatype Length Mandatory Comments
COMPL_AGENCY_COST_ID NUMBER (15) Yes Complaint Agency Cost ID
COMPLAINT_ID NUMBER (15) Yes Complaint ID
PHASE VARCHAR2 (50)
Phase
STAGE VARCHAR2 (240)
Stage
CATEGORY VARCHAR2 (240)
Category
AMOUNT NUMBER (15)
Amount
COST_DATE DATE

Cost Date
DESCRIPTION VARCHAR2 (500)
Description
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number
CREATED_BY NUMBER (15) Yes Created By
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER (15) Yes Last Update By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
Query Text

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


SELECT COMPL_AGENCY_COST_ID
,      COMPLAINT_ID
,      PHASE
,      STAGE
,      CATEGORY
,      AMOUNT
,      COST_DATE
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.GHR_COMPL_AGENCY_COSTS;

Dependencies

[top of page]

HR.GHR_COMPL_AGENCY_COSTS does not reference any database object

HR.GHR_COMPL_AGENCY_COSTS is referenced by following:

SchemaAPPS
SynonymGHR_COMPL_AGENCY_COSTS
TriggerGHR_COMPL_AGENCY_COSTS_WHO
SchemaPUBLIC
SynonymGHR_COMPL_AGENCY_COSTS