[Home] [Help] [Dependency Information]
Object Name: | IGW_PROP_ACTIVITIES |
---|---|
Object Type: | TABLE |
Owner: | IGW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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) |
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;
IGW.IGW_PROP_ACTIVITIES does not reference any database object
IGW.IGW_PROP_ACTIVITIES is referenced by following:
|
|
|