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: BIM.BIM_R_RESP_INT_HEADER

Object Details

Object Name:	BIM_R_RESP_INT_HEADER
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Store response header information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_RESP_INT_HEADER_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERFACE_HEADER_ID OBJECT_ID OBJECT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_HEADER_ID	NUMBER		Yes	Interface header id
LAST_UPDATE_DATE	DATE			who column
LAST_UPDATED_BY	NUMBER	(15)		who column
CREATION_DATE	DATE			Who column
CREATED_BY	NUMBER	(15)		Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		who column
OBJECT_ID	NUMBER			object identifier
OBJECT_TYPE	VARCHAR2	(30)	Yes	object type
COUNTRY	VARCHAR2	(30)		country
REGION	VARCHAR2	(30)		region
SOURCE_CODE	VARCHAR2	(30)		source code
SOURCE_CODE_ID	NUMBER			source code id
RESPONSE_CREATE_DATE	DATE			response create date
LANDING_PAD_HITS	NUMBER			landing pad hits
SURVEY_COMPLETED	NUMBER			survey_completed
PROCESS_FLAG	VARCHAR2	(1)		process flag
IMPORT_ERROR	VARCHAR2	(240)		import error
RESPONSE_SOURCE	VARCHAR2	(30)		response source
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		attribute category
ATTRIBUTE1	VARCHAR2	(150)		attribute1
ATTRIBUTE2	VARCHAR2	(150)		attribute2
ATTRIBUTE3	VARCHAR2	(150)		attribute3
ATTRIBUTE4	VARCHAR2	(150)		attribute4
ATTRIBUTE5	VARCHAR2	(150)		attribute5
ATTRIBUTE6	VARCHAR2	(150)		attribute6
ATTRIBUTE7	VARCHAR2	(150)		attribute7
ATTRIBUTE8	VARCHAR2	(150)		attribute8
ATTRIBUTE9	VARCHAR2	(150)		attribute9
ATTRIBUTE10	VARCHAR2	(150)		attribute10
ATTRIBUTE11	VARCHAR2	(150)		attribute11
ATTRIBUTE12	VARCHAR2	(150)		attribute12
ATTRIBUTE13	VARCHAR2	(150)		attribute13
ATTRIBUTE14	VARCHAR2	(150)		attribute14
ATTRIBUTE15	VARCHAR2	(150)		attribute15

Query Text

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


SELECT INTERFACE_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      OBJECT_TYPE
,      COUNTRY
,      REGION
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      RESPONSE_CREATE_DATE
,      LANDING_PAD_HITS
,      SURVEY_COMPLETED
,      PROCESS_FLAG
,      IMPORT_ERROR
,      RESPONSE_SOURCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM BIM.BIM_R_RESP_INT_HEADER;

Dependencies

[top of page]

BIM.BIM_R_RESP_INT_HEADER does not reference any database object

BIM.BIM_R_RESP_INT_HEADER is referenced by following:

BIM: BIM_R_RESP_INT_HEADER#