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


VIEW: APPS.POR_VIEW_HEADER_ALL_V

Object Details
Object Name: POR_VIEW_HEADER_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_VIEW_HEADER_ALL_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The POR_VIEW_HEADER_ALL_V view provides data to POR_OD_HEADER_R region on Order Detail Page. This view goes across operating units.


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUISITION_HEADER_ID NUMBER
Yes Requisition header unique identifier
REQ_NUM VARCHAR2 (20) Yes Requisition number
PREPARER_ID NUMBER (9) Yes Unique identifier of the employee who prepared the requisition
PREPARER_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
DESCRIPTION VARCHAR2 (240)
Description for requisition
NOTE_TO_AUTHORIZER VARCHAR2 (4000)
Note to approver (Unused since release 8.0)
APPROVAL_STATUS_CODE VARCHAR2 (25)
Authorization status type
STATUS VARCHAR2 (80) Yes Requisition status
URGENT_FLAG VARCHAR2 (4000)
Flag to indicate whether requisition is urgent
PCARD_ID NUMBER (15)
PCARD unique identifier
PCARD_NUMBER VARCHAR2 (80)
P Card number
PCARD_DESCRIPTION VARCHAR2 (240)
P card description
NOTE_TO_BUYER VARCHAR2 (4000)
Note to buyer
CREATION_DATE VARCHAR2 (75)
Standard who column
REQUISITION_TOTAL VARCHAR2 (4000)
Requisition total
REQUESTOR VARCHAR2 (4000)
Requestor name
SHIP_TO VARCHAR2 (4000)
Ship to name
EMERGENCY_PO_NUM VARCHAR2 (20)
Emergency PO number
ATTRIBUTE1 VARCHAR2 (150)
Attribute 1
ATTRIBUTE2 VARCHAR2 (150)
Attribute 2
ATTRIBUTE3 VARCHAR2 (150)
Attribute 3
ATTRIBUTE4 VARCHAR2 (150)
Attribute 4
ATTRIBUTE5 VARCHAR2 (150)
Attribute 5
ATTRIBUTE6 VARCHAR2 (150)
Attribute 6
ATTRIBUTE7 VARCHAR2 (150)
Attribute 7
ATTRIBUTE8 VARCHAR2 (150)
Attribute 8
ATTRIBUTE9 VARCHAR2 (150)
Attribute 8
ATTRIBUTE10 VARCHAR2 (150)
Attribute 10
ATTRIBUTE11 VARCHAR2 (150)
Attribute 11
ATTRIBUTE12 VARCHAR2 (150)
Attribute 12
ATTRIBUTE13 VARCHAR2 (150)
Attribute 13
ATTRIBUTE14 VARCHAR2 (150)
Attribute 14
ATTRIBUTE15 VARCHAR2 (150)
Attribute 15
Query Text

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


SELECT REQUISITION_HEADER_ID
,      REQ_NUM
,      PREPARER_ID
,      PREPARER_NAME
,      DESCRIPTION
,      NOTE_TO_AUTHORIZER
,      APPROVAL_STATUS_CODE
,      STATUS
,      URGENT_FLAG
,      PCARD_ID
,      PCARD_NUMBER
,      PCARD_DESCRIPTION
,      NOTE_TO_BUYER
,      CREATION_DATE
,      REQUISITION_TOTAL
,      REQUESTOR
,      SHIP_TO
,      EMERGENCY_PO_NUM
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.POR_VIEW_HEADER_ALL_V;

Dependencies

[top of page]

APPS.POR_VIEW_HEADER_ALL_V references the following:

SchemaAPPS
SynonymAP_CARDS_ALL
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOR_VIEW_REQS_PKG - show dependent code
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS_ALL

APPS.POR_VIEW_HEADER_ALL_V is not referenced by any database object