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

TABLE: IGW.IGW_PROP_ACTIVITIES

Object Details
Object Name: IGW_PROP_ACTIVITIES
Object Type: TABLE
Owner: IGW
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_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER (15) Yes Sequence number to uniquely identify the activity name
PROPOSAL_ID NUMBER (15) Yes Identifier of a Proposal
ASSIGNED_TO NUMBER (15) Yes Party ID of a person from hz_parties table to whom the activities are assigned
ACTIVITY_NAME VARCHAR2 (250) Yes Free flow text to describe the activity assigned to an Internal Grantee.
ACTIVITY_STATUS_CODE VARCHAR2 (30)
Status of the activity such as 'Completed', 'Not Completed', 'On Hold'
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
RECORD_VERSION_NUMBER NUMBER
Yes Field for storing locking sequence number
DUE_DATE DATE

COMPLETED_DATE DATE

COMMENTS VARCHAR2 (4000)
Query Text

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


SELECT ACTIVITY_ID
,      PROPOSAL_ID
,      ASSIGNED_TO
,      ACTIVITY_NAME
,      ACTIVITY_STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      DUE_DATE
,      COMPLETED_DATE
,      COMMENTS
FROM IGW.IGW_PROP_ACTIVITIES;

Dependencies

[top of page]

IGW.IGW_PROP_ACTIVITIES does not reference any database object

IGW.IGW_PROP_ACTIVITIES is referenced by following:

SchemaAPPS
SynonymIGW_PROP_ACTIVITIES