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


VIEW: APPS.POR_VIEW_REQS_TO_APPR_V

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

View Type

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


The POR_VIEW_REQS_TO_APPR_V provides data to Orders to Approve query on Approvals page


[View Source]

Columns
Name Datatype Length Mandatory Comments
REQ_HEADER_ID NUMBER
Yes Requisition unique identifier
REQUISITION_NUMBER VARCHAR2 (20) Yes Requisition Number
DESCRIPTION VARCHAR2 (240)
Requisition Description
STATUS_CODE VARCHAR2 (25)
Authorization Status Code
STATUS VARCHAR2 (80) Yes Authorization status displayed value
PCARD_NUMBER VARCHAR2 (80)
Procurement Card Number
CREATION_DATE DATE

Standard Who Column
PLACED_ON_SO_FLAG VARCHAR2 (1)
Placed on SO Flag
PLACED_ON_NG_FLAG VARCHAR2 (4000)
Placed on negotiations flag
EMERGENCY_PO_NUM VARCHAR2 (20)
Resreved PO number for Emergency Requisitions
NID NUMBER
Yes Notification Id
Query Text

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


SELECT REQ_HEADER_ID
,      REQUISITION_NUMBER
,      DESCRIPTION
,      STATUS_CODE
,      STATUS
,      PCARD_NUMBER
,      CREATION_DATE
,      PLACED_ON_SO_FLAG
,      PLACED_ON_NG_FLAG
,      EMERGENCY_PO_NUM
,      NID
FROM APPS.POR_VIEW_REQS_TO_APPR_V;

Dependencies

[top of page]

APPS.POR_VIEW_REQS_TO_APPR_V references the following:

SchemaAPPS
SynonymAP_CARDS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOR_VIEW_REQS_PKG - show dependent code
SynonymPO_DOCUMENT_TYPES
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
SynonymWF_NOTIFICATIONS
SynonymWF_NOTIFICATION_ATTRIBUTES
ViewWF_USER_ROLES

APPS.POR_VIEW_REQS_TO_APPR_V is not referenced by any database object