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]

VIEW: APPS.ECE_ATTACHMENT_V

Object Details

Object Name:	ECE_ATTACHMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_ATTACHMENT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts attachment data
for the outbound Purchase Order (850/ORDERS) and
outbound Purchase Order Change (860/ORDCHG) transactions.
The attachment view is used for header, line, shipment, distribution, item and master item level data.

[View Source]

Columns

Name	Datatype	Length	Comments
DOCUMENT_ID	NUMBER		Document ID
ENTITY_NAME	VARCHAR2	(40)	Entity Name
CATEGORY_NAME	VARCHAR2	(30)	Name
PK1_VALUE	VARCHAR2	(100)	Primary Key 1 Value
PK2_VALUE	VARCHAR2	(100)	Primary Key 2 Value
PK3_VALUE	VARCHAR2	(100)	Primary Key 3 Value
PK4_VALUE	VARCHAR2	(150)	Primary Key 4 Value
PK5_VALUE	VARCHAR2	(150)	Primary Key 5 Value
USAGE_TYPE	VARCHAR2	(1)	Usage Type
DESCRIPTION	VARCHAR2	(255)	Description
DATATYPE_ID	NUMBER		Data Type ID
SHORT_TEXT	VARCHAR2	(4000)	Short Text
LONG_TEXT	LONG	(0)	Long Text
LANGUAGE	VARCHAR2	(4)	Language
DOC_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute Category
DOC_ATTRIBUTE1	VARCHAR2	(150)	Attribute 1
DOC_ATTRIBUTE2	VARCHAR2	(150)	Attribute 2
DOC_ATTRIBUTE3	VARCHAR2	(150)	Attribute 3
DOC_ATTRIBUTE4	VARCHAR2	(150)	Attribute 4
DOC_ATTRIBUTE5	VARCHAR2	(150)	Attribute 5
DOC_ATTRIBUTE6	VARCHAR2	(150)	Attribute 6
DOC_ATTRIBUTE7	VARCHAR2	(150)	Attribute 7
DOC_ATTRIBUTE8	VARCHAR2	(150)	Attribute 8
DOC_ATTRIBUTE9	VARCHAR2	(150)	Attribute 9
DOC_ATTRIBUTE10	VARCHAR2	(150)	Attribute 10
DOC_ATTRIBUTE11	VARCHAR2	(150)	Attribute 11
DOC_ATTRIBUTE12	VARCHAR2	(150)	Attribute 12
DOC_ATTRIBUTE13	VARCHAR2	(150)	Attribute 13
DOC_ATTRIBUTE14	VARCHAR2	(150)	Attribute 14
DOC_ATTRIBUTE15	VARCHAR2	(150)	Attribute 15
ATT_SEQ_NUM	NUMBER		Attribute Sequence Number
ATTACHED_DOCUMENT_ID	NUMBER		Attached Document ID

Query Text

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


SELECT DOCUMENT_ID
,      ENTITY_NAME
,      CATEGORY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      USAGE_TYPE
,      DESCRIPTION
,      DATATYPE_ID
,      SHORT_TEXT
,      LONG_TEXT
,      LANGUAGE
,      DOC_ATTRIBUTE_CATEGORY
,      DOC_ATTRIBUTE1
,      DOC_ATTRIBUTE2
,      DOC_ATTRIBUTE3
,      DOC_ATTRIBUTE4
,      DOC_ATTRIBUTE5
,      DOC_ATTRIBUTE6
,      DOC_ATTRIBUTE7
,      DOC_ATTRIBUTE8
,      DOC_ATTRIBUTE9
,      DOC_ATTRIBUTE10
,      DOC_ATTRIBUTE11
,      DOC_ATTRIBUTE12
,      DOC_ATTRIBUTE13
,      DOC_ATTRIBUTE14
,      DOC_ATTRIBUTE15
,      ATT_SEQ_NUM
,      ATTACHED_DOCUMENT_ID
FROM APPS.ECE_ATTACHMENT_V;

Dependencies

[top of page]

APPS.ECE_ATTACHMENT_V references the following:

APPS: FND_ATTACHED_DOCUMENTS; FND_DOCUMENTS; FND_DOCUMENTS_LONG_TEXT; FND_DOCUMENTS_SHORT_TEXT; FND_DOCUMENTS_TL; FND_DOCUMENT_CATEGORIES_TL

APPS.ECE_ATTACHMENT_V is not referenced by any database object