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


VIEW: APPS.PO_REQ_HEADERS_REF_V

Object Details
Object Name: PO_REQ_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
REQ_ID NUMBER
Yes Requisition Header Identifier
REQ_NUMBER VARCHAR2 (20) Yes Requisition Number
REQUISITION_TYPE VARCHAR2 (80) Yes Requisition Type
REQ_HDR_DESCRIPTION VARCHAR2 (240)
Requisition Header Description
PREPARER_ID NUMBER (9) Yes Prepare Identifier
PREPARER_NAME VARCHAR2 (240)
Preparer Name
ORG_ID NUMBER

Organization identifier
OPERATING_UNIT_NAME VARCHAR2 (240) Yes Operating Unit Name
CBC_ACCOUNTING_DATE DATE

Column used to store the accounting action date for dual budgetary controls
REQ_ENCUMBRANCE_TYPE_ID NUMBER (15)
Requisition Encumbrance Type ID
REQ_ENCUMBRANCE_TYPE VARCHAR2 (30)
Requisition Encumbrance Type
REQ_ENCUMBRANCE_FLAG VARCHAR2 (1)
Requisition Encumbrance Flag
PURCH_ENCUMBRANCE_FLAG VARCHAR2 (1)
PO Encumbrance Flag
REQ_HDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
REQ_HDR_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield Attributes
REQ_HDR_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield Attributes
Query Text

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


SELECT REQ_ID
,      REQ_NUMBER
,      REQUISITION_TYPE
,      REQ_HDR_DESCRIPTION
,      PREPARER_ID
,      PREPARER_NAME
,      ORG_ID
,      OPERATING_UNIT_NAME
,      CBC_ACCOUNTING_DATE
,      REQ_ENCUMBRANCE_TYPE_ID
,      REQ_ENCUMBRANCE_TYPE
,      REQ_ENCUMBRANCE_FLAG
,      PURCH_ENCUMBRANCE_FLAG
,      REQ_HDR_ATTRIBUTE_CATEGORY
,      REQ_HDR_ATTRIBUTE1
,      REQ_HDR_ATTRIBUTE2
,      REQ_HDR_ATTRIBUTE3
,      REQ_HDR_ATTRIBUTE4
,      REQ_HDR_ATTRIBUTE5
,      REQ_HDR_ATTRIBUTE6
,      REQ_HDR_ATTRIBUTE7
,      REQ_HDR_ATTRIBUTE8
,      REQ_HDR_ATTRIBUTE9
,      REQ_HDR_ATTRIBUTE10
,      REQ_HDR_ATTRIBUTE11
,      REQ_HDR_ATTRIBUTE12
,      REQ_HDR_ATTRIBUTE13
,      REQ_HDR_ATTRIBUTE14
,      REQ_HDR_ATTRIBUTE15
FROM APPS.PO_REQ_HEADERS_REF_V;

Dependencies

[top of page]

APPS.PO_REQ_HEADERS_REF_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_ENCUMBRANCE_TYPES
SynonymHR_ALL_ORGANIZATION_UNITS_TL
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_REQUISITION_HEADERS_ALL
APPS.PO_REQ_HEADERS_REF_V is referenced by following:

SchemaAPPS
Package BodyXLA_00707_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000005_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000005_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000007_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000019_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000020_BC_PKG - show dependent code
Package BodyXLA_00707_AAD_S_000020_PKG - show dependent code