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: IGF.IGF_SL_CR_RESP_DTLS

Object Details

Object Name:	IGF_SL_CR_RESP_DTLS
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_CR_RESP_DTLS
Subobject Name:
Status:	VALID

Table storing the Common Record Tag Response Elements from the response XML file

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_CR_RESP_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID_TXT

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_ID_TXT	VARCHAR2	(30)	Yes	Identifier for the document
DOC_CREATED_DATE	DATE			Indicates the date and time when the document was created
SOURCE_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the source Entity ID
DEST_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the destination Entity ID
SOFT_PROVIDER	VARCHAR2	(30)		Indicates the Software Provider
SOFT_VERSION	VARCHAR2	(30)		Indicates the Software Version
FULL_RESP_CODE	VARCHAR2	(30)		Indicates the full response code of the document
RECEIPT_DATE	DATE			Indicates the date and time stamp that indicates the receipt of the document
DOC_TYPE_CODE	VARCHAR2	(30)		Indicates the code corresponding to the type of data being returned in the document.
DOC_STATUS_CODE	VARCHAR2	(30)		Indicates the status of the processed document on COD.
PROCESS_DATE	DATE			Indicates the date the document information was processed at COD.
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT DOCUMENT_ID_TXT
,      DOC_CREATED_DATE
,      SOURCE_ENTITY_ID_TXT
,      DEST_ENTITY_ID_TXT
,      SOFT_PROVIDER
,      SOFT_VERSION
,      FULL_RESP_CODE
,      RECEIPT_DATE
,      DOC_TYPE_CODE
,      DOC_STATUS_CODE
,      PROCESS_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM IGF.IGF_SL_CR_RESP_DTLS;

Dependencies

[top of page]

IGF.IGF_SL_CR_RESP_DTLS does not reference any database object

IGF.IGF_SL_CR_RESP_DTLS is referenced by following:

APPS: IGF_SL_CR_RESP_DTLS