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_P_SUBMSSN_HISTORIES

Object Details

Object Name:	IGW_P_SUBMSSN_HISTORIES
Object Type:	TABLE
Owner:	IGW
Subobject Name:
Status:	VALID

IGW_PROP_SUBMISSION_HISTORY table stores Proposal Submission History Details.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PROP_SUBMISSION_HISTORY_ID	NUMBER	(15)	Yes	Proposal Submission History Identifier
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal Identifier
SUBMISSION_PURPOSE_CODE	VARCHAR2	(30)		Reason of the proposal submission
SUBMISSION_TYPE_CODE	VARCHAR2	(30)		Type of application being submitted
ACTION_CODE	VARCHAR2	(30)		Code to indicate application action type as update of information or budget adjustment
SUBMISSION_SECURITY_CODE	VARCHAR2	(30)		Submission Security Code
DUE_DATE	DATE			Last date the application needs to be sent
SUBMISSION_DATE	DATE			Date the application is sent
RECEIVED_DATE	DATE			The date the application was received
COMMENTS	VARCHAR2	(240)		Comments
SUBMITTING_ORG_PARTY_ID	NUMBER	(15)		Party Identifier of organization sending the proposal
ORGANIZATION_TYPE_CODE	VARCHAR2	(30)		Type of organization
SUBMITTER_PARTY_ID	NUMBER	(15)		Party Identifier of person sending the proposal
ROLE_CODE	VARCHAR2	(30)		Type of individual associated with the business process of submitting the application
TRANSMISSION_TYPE_CODE	VARCHAR2	(30)		External Transmission Type
TRANSMISSION_METHOD	VARCHAR2	(80)		Other form of electronic transmission
CARRIER_CODE	VARCHAR2	(30)		DUNS/CAGE
CARRIER_NUMBER	VARCHAR2	(80)		DUNS/CAGE number of the commercial express courier which performs the transmission
SOFTWARE_DESCRIPTION	VARCHAR2	(30)		The brand name of the spreadsheet software and its version and release number
RELATED_TRANSACTION_SET	VARCHAR2	(80)		Unique number of a related transaction set
CREATION_DATE	DATE			Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPPDATE_LOGIN	NUMBER	(15)		Standard Who Column
GRANTOR_STATUS_CODE	VARCHAR2	(30)		Grantor Status Code
RECORD_VERSION_NUMBER	NUMBER			Record Version Number
TRANSACTION_SET_NUMBER	VARCHAR2	(80)		Transaction Set Number

Query Text

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


SELECT PROP_SUBMISSION_HISTORY_ID
,      PROPOSAL_ID
,      SUBMISSION_PURPOSE_CODE
,      SUBMISSION_TYPE_CODE
,      ACTION_CODE
,      SUBMISSION_SECURITY_CODE
,      DUE_DATE
,      SUBMISSION_DATE
,      RECEIVED_DATE
,      COMMENTS
,      SUBMITTING_ORG_PARTY_ID
,      ORGANIZATION_TYPE_CODE
,      SUBMITTER_PARTY_ID
,      ROLE_CODE
,      TRANSMISSION_TYPE_CODE
,      TRANSMISSION_METHOD
,      CARRIER_CODE
,      CARRIER_NUMBER
,      SOFTWARE_DESCRIPTION
,      RELATED_TRANSACTION_SET
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPPDATE_LOGIN
,      GRANTOR_STATUS_CODE
,      RECORD_VERSION_NUMBER
,      TRANSACTION_SET_NUMBER
FROM IGW.IGW_P_SUBMSSN_HISTORIES;

Dependencies

[top of page]

IGW.IGW_P_SUBMSSN_HISTORIES does not reference any database object

IGW.IGW_P_SUBMSSN_HISTORIES is referenced by following:

APPS: IGW_P_SUBMSSN_HISTORIES