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

Object Details

Object Name:	PO_HEADERS_REF_V
Object Type:	VIEW
Owner:	APPS
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
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_NUMBER	VARCHAR2	(20)	Yes	Document number - Combined with type_lookup_code and org_id to form unique key
PO_TYPE	VARCHAR2	(25)	Yes	Type of the document. (Combined with segment1and org_id to form unique key; References PO_DOCUMENT_TYPES_ALL_B.document_subtype)
PO_HDR_DESCRIPTION	VARCHAR2	(240)		Descriptive comments for the document
BUYER_ID	NUMBER	(9)	Yes	Buyer unique identifier. (References PO_AGENTS.agent_id)
BUYER_NAME	VARCHAR2	(240)		Full concatenated name of the employee
REVISION_NUM	NUMBER			Document revision number
PCARD_NUMBER	VARCHAR2	(80)		Pcard Number
ENCUMBRANCE_REQUIRED_FLAG	VARCHAR2	(1)		Blanket Agreement Encumbrance Required
VENDOR_ID	NUMBER			Supplier Identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier
VENDOR_SITE_ID	NUMBER			Supplier Site
VENDOR_SITE_NAME	VARCHAR2	(15)		Supplier Site
ORG_ID	NUMBER			Organization identifier
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes	Operating Unit Name
PURCH_ENCUMBRANCE_TYPE_ID	NUMBER	(15)	Yes	Purchasing Encumbrance Type ID
PURCH_ENCUMBRANCE_FLAG	VARCHAR2	(1)		Flag that indicates if Oracle Purchasing will create an encumbrance journal entry when a purchase order is created
REQ_ENCUMBRANCE_FLAG	VARCHAR2	(1)		PO Encumbrance Flag
GLOBAL_AGREEMENT_FLAG	VARCHAR2	(1)		Global agreement flag
POH_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
POH_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield Segments 1
POH_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield Segments 2
POH_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield Segments 3
POH_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield Segments 4
POH_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield Segments 5
POH_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield Segments 6
POH_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield Segments 7
POH_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield Segments 8
POH_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield Segments 9
POH_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield Segments 10
POH_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield Segments 11
POH_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield Segments 12
POH_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield Segments 13
POH_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield Segments 14
POH_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield Segments 15
POH_GOLBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
POH_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality

Query Text

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


SELECT PO_HEADER_ID
,      PO_NUMBER
,      PO_TYPE
,      PO_HDR_DESCRIPTION
,      BUYER_ID
,      BUYER_NAME
,      REVISION_NUM
,      PCARD_NUMBER
,      ENCUMBRANCE_REQUIRED_FLAG
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_NAME
,      ORG_ID
,      OPERATING_UNIT_NAME
,      PURCH_ENCUMBRANCE_TYPE_ID
,      PURCH_ENCUMBRANCE_FLAG
,      REQ_ENCUMBRANCE_FLAG
,      GLOBAL_AGREEMENT_FLAG
,      POH_ATTRIBUTE_CATEGORY
,      POH_ATTRIBUTE1
,      POH_ATTRIBUTE2
,      POH_ATTRIBUTE3
,      POH_ATTRIBUTE4
,      POH_ATTRIBUTE5
,      POH_ATTRIBUTE6
,      POH_ATTRIBUTE7
,      POH_ATTRIBUTE8
,      POH_ATTRIBUTE9
,      POH_ATTRIBUTE10
,      POH_ATTRIBUTE11
,      POH_ATTRIBUTE12
,      POH_ATTRIBUTE13
,      POH_ATTRIBUTE14
,      POH_ATTRIBUTE15
,      POH_GOLBAL_ATTRIBUTE_CATEGORY
,      POH_GLOBAL_ATTRIBUTE1
,      POH_GLOBAL_ATTRIBUTE2
,      POH_GLOBAL_ATTRIBUTE3
,      POH_GLOBAL_ATTRIBUTE4
,      POH_GLOBAL_ATTRIBUTE5
,      POH_GLOBAL_ATTRIBUTE6
,      POH_GLOBAL_ATTRIBUTE7
,      POH_GLOBAL_ATTRIBUTE8
,      POH_GLOBAL_ATTRIBUTE9
,      POH_GLOBAL_ATTRIBUTE10
,      POH_GLOBAL_ATTRIBUTE11
,      POH_GLOBAL_ATTRIBUTE12
,      POH_GLOBAL_ATTRIBUTE13
,      POH_GLOBAL_ATTRIBUTE14
,      POH_GLOBAL_ATTRIBUTE15
,      POH_GLOBAL_ATTRIBUTE16
,      POH_GLOBAL_ATTRIBUTE17
,      POH_GLOBAL_ATTRIBUTE18
,      POH_GLOBAL_ATTRIBUTE19
,      POH_GLOBAL_ATTRIBUTE20
FROM APPS.PO_HEADERS_REF_V;