eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.POR_RCV_REQS_ALL_V

Object Details

Object Name:	POR_RCV_REQS_ALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_RCV_REQS_ALL_V
Subobject Name:
Status:	VALID

View Type

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

View to query all requisitions

[View Source]

Columns

Name	Datatype	Length	Comments
REQUISITION_HEADER_ID	NUMBER		Requisition header id
PREPARER_ID	NUMBER	(9)	ID of preparer
TO_PERSON_ID	NUMBER	(9)	ID of the person delivered to
PO_HEADER_ID	NUMBER		Purchase Order Header ID
PO_RELEASE_ID	NUMBER		Purchase Order Release ID
ORDER_ID	NUMBER		Purchase Order ID
VENDOR_ID	NUMBER		Vendor ID

Query Text

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


SELECT REQUISITION_HEADER_ID
,      PREPARER_ID
,      TO_PERSON_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      ORDER_ID
,      VENDOR_ID
FROM APPS.POR_RCV_REQS_ALL_V;

Dependencies

[top of page]

APPS.POR_RCV_REQS_ALL_V references the following:

APPS: OE_ORDER_HEADERS_ALL; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_REQ_DISTRIBUTIONS; PO_SYSTEM_PARAMETERS; RCV_SHIPMENT_LINES

APPS.POR_RCV_REQS_ALL_V is not referenced by any database object