eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGW.IGW_PROP_MAP_STOPS

Object Details

Object Name:	IGW_PROP_MAP_STOPS
Object Type:	TABLE
Owner:	IGW
FND Design Data:	IGW.IGW_PROP_MAP_STOPS
Subobject Name:
Status:	VALID

IGW_PROP_MAP_STOPS stores personnel information for each map in the IGW_PROP_MAPS table during proposal approval. It includes information such as submission date, approval date, and approval status.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGW_PROP_MAP_STOPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROP_MAP_ID STOP_ID USER_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
PROP_MAP_ID	NUMBER	(15)	Yes	Identifier for each map in a proposal approval run
STOP_ID	NUMBER	(4)	Yes	Stop identifier
USER_NAME	VARCHAR2	(100)	Yes	Application user name of the approver or the person to whom notification is sent
WF_ROLE_NAME	VARCHAR2	(100)		Workflow role name. Submit for approval process assigns a role to each stop in a map used by the process. The role is named IGW-X-Y-Z where X is the run identifier, Y is the map identifier, and Z is the stop identifier for routing maps and IGW-X-0-0 where X is the run identifier for notification maps.
WF_DISPLAY_ROLE_NAME	VARCHAR2	(200)	Yes	Display name for WF_ROLE_NAME field
APPROVER_TYPE	VARCHAR2	(1)		Type of approver in the map. P means Primary and A means Alternate.
APPROVAL_STATUS	VARCHAR2	(1)		Approval status for the user. A means Approved, R means Rejected, W means Waiting for approval, and S means Submitted.
SUBMISSION_DATE	DATE			Date user was notified or the proposal was submitted for approval
APPROVAL_DATE	DATE			Date when proposal is approved or rejected
COMMENTS	VARCHAR2	(2000)		Comments entered by user in the Note field while approving or rejecting the proposal
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	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

Query Text

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


SELECT PROP_MAP_ID
,      STOP_ID
,      USER_NAME
,      WF_ROLE_NAME
,      WF_DISPLAY_ROLE_NAME
,      APPROVER_TYPE
,      APPROVAL_STATUS
,      SUBMISSION_DATE
,      APPROVAL_DATE
,      COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM IGW.IGW_PROP_MAP_STOPS;

Dependencies

[top of page]

IGW.IGW_PROP_MAP_STOPS does not reference any database object

IGW.IGW_PROP_MAP_STOPS is referenced by following:

APPS: IGW_PROP_MAP_STOPS