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

VIEW: APPS.IRCBV_DOCUMENTS_V

Object Details
Object Name: IRCBV_DOCUMENTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


Default posting (from IRC_DEFAULT_POSTINGS/TL table).


[View Source]

Columns
Name Datatype Length Mandatory Comments
BINARY_DOC BLOB (86)
Binary doc.
CHARACTER_DOC CLOB (86)
Character doc.
FILE_NAME VARCHAR2 (240)
File name.
FILE_FORMAT VARCHAR2 (30) Yes File format.
MIME_TYPE VARCHAR2 (150) Yes Mime type.
DESCRIPTION VARCHAR2 (240)
Description.
TYPE_M VARCHAR2 (4000)
(Lookup meaning based on lookup type IRC_DOCUMENT_TYPE).
PARSED_XML CLOB (86)
Parsed xml.
TYPE VARCHAR2 (30) Yes (Lookup code based on lookup type IRC_DOCUMENT_TYPE).
PERSON_ID NUMBER (15) Yes Foreign key to PER_ALL_PEOPLE_F.
DOCUMENT_ID NUMBER (15) Yes Primary key for IRC_DOCUMENTS.
PARTY_ID NUMBER (15)
Foreign key to HZ_PARTIES.
ASSIGNMENT_ID NUMBER (15)
Foreign key to PER_ALL_ASSIGNMENTS_F.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
Query Text

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


SELECT BINARY_DOC
,      CHARACTER_DOC
,      FILE_NAME
,      FILE_FORMAT
,      MIME_TYPE
,      DESCRIPTION
,      TYPE_M
,      PARSED_XML
,      TYPE
,      PERSON_ID
,      DOCUMENT_ID
,      PARTY_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.IRCBV_DOCUMENTS_V;

Dependencies

[top of page]

APPS.IRCBV_DOCUMENTS_V references the following:

SchemaAPPS
PL/SQL PackageHR_BIS - show dependent code
SynonymIRC_DOCUMENTS

APPS.IRCBV_DOCUMENTS_V is not referenced by any database object