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

VIEW: APPS.PO_DOCUMENT_HEADERS_VIEW

Object Details
Object Name: PO_DOCUMENT_HEADERS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_DOCUMENT_HEADERS_VIEW
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 Mandatory Comments
DOCUMENT_ID NUMBER

Document unique identifier
TYPE_CODE VARCHAR2 (25)
Document type
SUBTYPE VARCHAR2 (25)
Document subtype
DOCUMENT_NUMBER VARCHAR2 (61)
Document number
REVISION NUMBER

Document reviwion
TYPE_NAME VARCHAR2 (80)
Document translated full name
PREPARER_NAME VARCHAR2 (4000)
Document preparer
PREPARER_ID NUMBER (9)
Document preparer unique identifier
CREATION_DATE DATE

Standard who column - date when this row was created.
DESCRIPTION VARCHAR2 (240)
Document description
NOTE_TO_AUTHORIZER VARCHAR2 (4000)
Note to approver
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT DOCUMENT_ID
,      TYPE_CODE
,      SUBTYPE
,      DOCUMENT_NUMBER
,      REVISION
,      TYPE_NAME
,      PREPARER_NAME
,      PREPARER_ID
,      CREATION_DATE
,      DESCRIPTION
,      NOTE_TO_AUTHORIZER
,      ORG_ID
FROM APPS.PO_DOCUMENT_HEADERS_VIEW;

Dependencies

[top of page]

APPS.PO_DOCUMENT_HEADERS_VIEW references the following:

SchemaAPPS
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
PL/SQL PackagePO_EMPLOYEES_SV - show dependent code
SynonymPO_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_RELEASES
SynonymPO_REQUISITION_HEADERS
APPS.PO_DOCUMENT_HEADERS_VIEW is referenced by following:

SchemaAPPS
Package BodyPO_INQ_SV - show dependent code