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


VIEW: APPS.POR_VIEW_REQS_BY_PUBLIC_V

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

View Type

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


POR_VIEW_REQS_BY_PUBLIC_V provides infomation on requisitions. This data access is unrestricted and can be seen by all users in the system


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQ_HEADER_ID NUMBER
Yes Requisition header identifier
REQUISITION_NUMBER VARCHAR2 (20) Yes Requisition number
PREPARER_ID NUMBER (9) Yes Preparer identifier
PREPARER_NAME VARCHAR2 (240)
Name of preparer
PREPARER_LAST_NAME VARCHAR2 (150)
Last name of preparer
DESCRIPTION VARCHAR2 (240)
Description
STATUS_CODE VARCHAR2 (25)
Status code
STATUS VARCHAR2 (80) Yes Requisition status
CANCEL_FLAG VARCHAR2 (1)
Cancel flag
CLOSED_CODE VARCHAR2 (25)
Closed code
PCARD_NUMBER VARCHAR2 (80)
PCard number
CREATION_DATE DATE

Creation date
COMPARED_CREATION_DATE VARCHAR2 (10)
Compared creation date
PLACED_ON_SO_FLAG VARCHAR2 (1)
Placed on SO Flag
PLACED_ON_NG_FLAG CHAR (1)
Placed on negotiations flag
EMERGENCY_PO_NUM VARCHAR2 (20)
Emergency PO number
CHANGE_PENDING_FLAG VARCHAR2 (1)
Flag to indicate that a requester initiated change order request is pending.
Query Text

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


SELECT REQ_HEADER_ID
,      REQUISITION_NUMBER
,      PREPARER_ID
,      PREPARER_NAME
,      PREPARER_LAST_NAME
,      DESCRIPTION
,      STATUS_CODE
,      STATUS
,      CANCEL_FLAG
,      CLOSED_CODE
,      PCARD_NUMBER
,      CREATION_DATE
,      COMPARED_CREATION_DATE
,      PLACED_ON_SO_FLAG
,      PLACED_ON_NG_FLAG
,      EMERGENCY_PO_NUM
,      CHANGE_PENDING_FLAG
FROM APPS.POR_VIEW_REQS_BY_PUBLIC_V;

Dependencies

[top of page]

APPS.POR_VIEW_REQS_BY_PUBLIC_V references the following:

SchemaAPPS
SynonymAP_CARDS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymPER_ALL_PEOPLE_F
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES_ALL

APPS.POR_VIEW_REQS_BY_PUBLIC_V is not referenced by any database object