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_DOC_TYPE_ASSOS_V

Object Details

Object Name:	AHL_DOC_TYPE_ASSOS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_DOC_TYPE_ASSOS_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
DOC_TITLE_ASSO_ID	NUMBER		Primary Key
OBJECT_VERSION_NUMBER	NUMBER		Stores locking sequence number
ASO_OBJECT_ID	NUMBER		ASO Object Id
USE_LATEST_REV_FLAG	VARCHAR2	(1)	Use Latest Revision Flag
USE_LATEST_REV_FLAG_MEAN	VARCHAR2	(80)	Use Latest Revision Flag Meaning
DOCUMENT_ID	NUMBER		Document Identifier
DOCUMENT_NO	VARCHAR2	(30)	Document Number
DOC_TYPE_CODE	VARCHAR2	(30)	Document Type Code
DOC_TYPE_DESCRIPTION	VARCHAR2	(80)	Document Type Description
DOCUMENT_TITLE	VARCHAR2	(240)	Title of the document
DOC_REVISION_ID	NUMBER		Document Revision Identifier
REVISION_NO	VARCHAR2	(30)	Revision Number
CHAPTER	VARCHAR2	(30)	Chapter of the document
SECTION	VARCHAR2	(30)	Section of the document
SUBJECT	VARCHAR2	(240)	Subject of the document
PAGE	VARCHAR2	(5)	Page of the document
FIGURE	VARCHAR2	(30)	Picture of the document
NOTE	VARCHAR2	(2000)	Note

Query Text

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


SELECT DOC_TITLE_ASSO_ID
,      OBJECT_VERSION_NUMBER
,      ASO_OBJECT_ID
,      USE_LATEST_REV_FLAG
,      USE_LATEST_REV_FLAG_MEAN
,      DOCUMENT_ID
,      DOCUMENT_NO
,      DOC_TYPE_CODE
,      DOC_TYPE_DESCRIPTION
,      DOCUMENT_TITLE
,      DOC_REVISION_ID
,      REVISION_NO
,      CHAPTER
,      SECTION
,      SUBJECT
,      PAGE
,      FIGURE
,      NOTE
FROM APPS.AHL_DOC_TYPE_ASSOS_V;

Dependencies

[top of page]

APPS.AHL_DOC_TYPE_ASSOS_V references the following:

APPS: AHL_DOCUMENTS_VL; AHL_DOC_REVISIONS_B; AHL_DOC_TITLE_ASSOS_VL; FND_LOOKUP_VALUES_VL

APPS.AHL_DOC_TYPE_ASSOS_V is not referenced by any database object