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


VIEW: APPS.POR_VIEW_REQS_BY_APPR_V

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

View Type

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


POR_VIEW_REQS_BY_APPR_V is used for Orders I have Approved query on Order Status Page, Approvals link


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQ_HEADER_ID NUMBER
Yes Requisition header unique identifier
REQUISITION_NUMBER VARCHAR2 (20) Yes Requisition number
PREPARER_ID NUMBER (9) Yes Employee id of the preparer
PREPARER_NAME VARCHAR2 (240)
Preparer name
PREPARER_LAST_NAME VARCHAR2 (150)
Preparer last name
DESCRIPTION VARCHAR2 (240)
Requisition description
STATUS_CODE VARCHAR2 (25)
Authorization status code
STATUS VARCHAR2 (80) Yes Authorization status displayed value
CANCEL_FLAG VARCHAR2 (1)
Unused since release 7.0
CLOSED_CODE VARCHAR2 (25)
Closed code
PCARD_NUMBER VARCHAR2 (80)
Procurement Card Number
CREATION_DATE DATE

Creation date of the requisition
COMPARED_CREATION_DATE VARCHAR2 (10)
Creation date is used for search criteria
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)
PO Number that is reserved for Emergency Requisition
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
FROM APPS.POR_VIEW_REQS_BY_APPR_V;

Dependencies

[top of page]

APPS.POR_VIEW_REQS_BY_APPR_V references the following:

SchemaAPPS
SynonymAP_CARDS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_USER
ViewGL_SETS_OF_BOOKS
SynonymPER_ALL_PEOPLE_F
SynonymPO_ACTION_HISTORY
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES_ALL

APPS.POR_VIEW_REQS_BY_APPR_V is not referenced by any database object