[Home] [Help] [Dependency Information]
Object Name: | IGW_PROP_APPROVAL_RUNS |
---|---|
Object Type: | TABLE |
Owner: | IGW |
FND Design Data: | IGW.IGW_PROP_APPROVAL_RUNS |
Subobject Name: | |
Status: | VALID |
IGW_PROP_APPROVAL_RUNS stores the history of every proposal approval process invoked for approving a proposal. This table contains the status of the proposal approval process, which can have the values of In-Progress, Approved, Rejected, or Error.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGW_PROP_APPROVAL_RUNS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RUN_ID |
IGW_PROP_APPROVAL_RUNS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPOSAL_ID
RUN_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RUN_ID | NUMBER | (15) | Yes | Run identifier |
PROPOSAL_ID | NUMBER | (15) | Yes | Proposal identifier |
RUN_NUMBER | NUMBER | (4) | Yes | Run or invocation sequence number of the proposal approval process. It starts with 1 for each proposal and is incremented by 1 for each invocation of the proposal approval process. |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status of the proposal approval. Possible values are I for Approval in Progress, A for Approved, R for Rejected, or E for Error. |
STATUS_DATE | DATE | Date corresponding to the status |
Cut, paste (and edit) the following text to query this object:
SELECT RUN_ID
, PROPOSAL_ID
, RUN_NUMBER
, STATUS_CODE
, STATUS_DATE
FROM IGW.IGW_PROP_APPROVAL_RUNS;
IGW.IGW_PROP_APPROVAL_RUNS does not reference any database object
IGW.IGW_PROP_APPROVAL_RUNS is referenced by following:
|
|
|