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.AHL_REFERENCE_DOC_V

Object Details

Object Name:	AHL_REFERENCE_DOC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_REFERENCE_DOC_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
DOCUMENT_ID	NUMBER		Document Identifier
DOCUMENT_NO	VARCHAR2	(30)	Document Number
DOC_TITLE_ASSO_ID	NUMBER		Primary Key
OBJECT_VERSION_NUMBER	NUMBER		Stores locking sequence number
ASO_OBJECT_ID	NUMBER		ASO Object Id
DOC_REVISION_ID	NUMBER		Primary Key
REVISION_NO	VARCHAR2	(30)	Revision Number(Unique Key)
DOC_TYPE_CODE	VARCHAR2	(30)	Document Type Code
DOC_TYPE_DESCRIPTION	VARCHAR2	(80)	Description for the Document Type Code
ASO_OBJECT_TYPE_CODE	VARCHAR2	(30)	ASO Object Type (Route, MC, etc.)
ASO_OBJECT_TYPE_DESC	VARCHAR2	(80)	Description for the ASO Object Type
DOCUMENT_TITLE	VARCHAR2	(240)	Title of the document
CHAPTER	VARCHAR2	(30)
SECTION	VARCHAR2	(30)
SUBJECT	VARCHAR2	(240)
PAGE	VARCHAR2	(5)
FIGURE	VARCHAR2	(30)
NOTE	VARCHAR2	(2000)
USE_LATEST_REV_FLAG	VARCHAR2	(1)
USE_LATEST_REV_FLAG_MEANING	VARCHAR2	(80)
REVISION_STATUS_CODE	VARCHAR2	(30)	RevisionStatusCode
FILE_ID	NUMBER		Foreign key to FND_LOBS
FILE_NAME	VARCHAR2	(256)	File Name

Query Text

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


SELECT DOCUMENT_ID
,      DOCUMENT_NO
,      DOC_TITLE_ASSO_ID
,      OBJECT_VERSION_NUMBER
,      ASO_OBJECT_ID
,      DOC_REVISION_ID
,      REVISION_NO
,      DOC_TYPE_CODE
,      DOC_TYPE_DESCRIPTION
,      ASO_OBJECT_TYPE_CODE
,      ASO_OBJECT_TYPE_DESC
,      DOCUMENT_TITLE
,      CHAPTER
,      SECTION
,      SUBJECT
,      PAGE
,      FIGURE
,      NOTE
,      USE_LATEST_REV_FLAG
,      USE_LATEST_REV_FLAG_MEANING
,      REVISION_STATUS_CODE
,      FILE_ID
,      FILE_NAME
FROM APPS.AHL_REFERENCE_DOC_V;

Dependencies

[top of page]

APPS.AHL_REFERENCE_DOC_V references the following:

APPS: AHL_DOCUMENTS_VL; AHL_DOC_FILE_ASSOC_VL; AHL_DOC_REVISIONS_B; AHL_DOC_TITLE_ASSOS_VL; FND_LOOKUP_VALUES_VL

APPS.AHL_REFERENCE_DOC_V is not referenced by any database object