[Home] [Help] [Dependency Information]
Object Name: | IGW_PROP_CHECKLIST |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_PROP_CHECKLIST |
Subobject Name: | |
Status: | VALID |
IGW_PROP_CHECKLIST stores statuses of proposal components. A proposal is comprised of budgets, narratives, and other components.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_PROP_CHECKLIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPOSAL_ID
DOCUMENT_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
DOCUMENT_TYPE_CODE | VARCHAR2 | (30) | Yes | Proposal component. The code is taken from IGW_SS_PROP_DOC_TYPES lookup. |
CHECKLIST_ORDER | NUMBER | (2) | Order in which component records are displayed | |
COMPLETE | VARCHAR2 | (1) | Flag to indicate whether or not proposal component has been completed. Possible values are Y or N. | |
NOT_APPLICABLE | VARCHAR2 | (1) | Flag to indicate whether or not component is applicable to this proposal. Possible values are Y or N. | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
RECORD_VERSION_NUMBER | NUMBER | Yes | Locking sequence number | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
DUE_DATE | DATE | Identifies when the document is due | ||
DATE_SUBMITTED | DATE | identifies the submission date | ||
COMMENTS | VARCHAR2 | (2000) | stores the comments | |
STATUS | VARCHAR2 | (30) | status of the document | |
DATE_RECEIVED | DATE | The date the proposal is received | ||
REVIEWED_BY | NUMBER | Reviewed By | ||
REVIEW_DATE | DATE | Review Date | ||
COMPLETED_DATE | DATE | Completion Date of the Checklist |
Cut, paste (and edit) the following text to query this object:
SELECT PROPOSAL_ID
, DOCUMENT_TYPE_CODE
, CHECKLIST_ORDER
, COMPLETE
, NOT_APPLICABLE
, LAST_UPDATE_DATE
, RECORD_VERSION_NUMBER
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DUE_DATE
, DATE_SUBMITTED
, COMMENTS
, STATUS
, DATE_RECEIVED
, REVIEWED_BY
, REVIEW_DATE
, COMPLETED_DATE
FROM IGW.IGW_PROP_CHECKLIST;
IGW.IGW_PROP_CHECKLIST does not reference any database object
IGW.IGW_PROP_CHECKLIST is referenced by following:
|
|
|