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

VIEW: APPS.POR_ATTACHMENTS_SUMMARY_V

Object Details
Object Name: POR_ATTACHMENTS_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_ATTACHMENTS_SUMMARY_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The POR_ATTACHMENTS_SUMMARY_V provides Attachments Summary information on Requisition Detail and Requisition Line Detail pages.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_NUM NUMBER
Yes User-entered sequence number for displaying attachments in order
DIRECT_TO VARCHAR2 (255) Yes Username for the category (language-dependent)
TYPE_ID NUMBER
Yes Datatype identifier
TYPE VARCHAR2 (80) Yes Username for the datatype (language specific)
DESCRIPTION VARCHAR2 (255)
Document description
FUNCTION_NAME VARCHAR2 (30) Yes Developer name for the function
ENTITY_NAME VARCHAR2 (40) Yes Foreign key to FND_DOCUMENT_ENTITIES indicating which application entity the document is related to
PK1_VALUE VARCHAR2 (100)
Part of the related entity's foreign key
PK2_VALUE VARCHAR2 (100)
Part of the related entity's foreign key
ATTACHED_DOC_ID NUMBER
Yes Attached document identifier
MEDIA_ID NUMBER

Identifier of the sub-table in which the document is stored
FILE_NAME VARCHAR2 (2048)
File name of the document
DCD_NAME CHAR (1)
Database Connection Descriptor Name
Query Text

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


SELECT SEQ_NUM
,      DIRECT_TO
,      TYPE_ID
,      TYPE
,      DESCRIPTION
,      FUNCTION_NAME
,      ENTITY_NAME
,      PK1_VALUE
,      PK2_VALUE
,      ATTACHED_DOC_ID
,      MEDIA_ID
,      FILE_NAME
,      DCD_NAME
FROM APPS.POR_ATTACHMENTS_SUMMARY_V;

Dependencies

[top of page]

APPS.POR_ATTACHMENTS_SUMMARY_V references the following:

SchemaAPPS
ViewFND_ATTACHED_DOCS_FORM_VL

APPS.POR_ATTACHMENTS_SUMMARY_V is not referenced by any database object