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


VIEW: APPS.POR_RCV_PURCHASE_ITEMS_V

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

View Type

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


View to query requisition lines that are from source code 'PO' in receiving pages


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIPT_DATE DATE

Receipt date
REQUESTOR_ID NUMBER

Requstor id
PO_HEADER_ID NUMBER

Purchase Order header id
PO_NUMBER VARCHAR2 (20)
Purchase Order Number
PO_LINE_ID NUMBER

Purchase Order line id
PO_LINE_LOCATION_ID NUMBER

Purchase Order line location ID
PO_RELEASE_ID NUMBER

Purchase Order Release ID
PO_RELEASE_NUMBER NUMBER

Purchase Order Release Number
REQ_HEADER_ID NUMBER

Requisition Header ID
REQUISITION_NUMBER VARCHAR2 (20)
Requisition Number
PO_LINE_NUMBER NUMBER

Purchase Order Line Number
PO_SHIPMENT_NUMBER NUMBER

Purchase Order Shipment Number
TO_ORGANIZATION_ID NUMBER

ID of the organization shipped to
ITEM_ID NUMBER

Item ID
PRIMARY_UOM VARCHAR2 (25)
Primary Unit of Measure
PRIMARY_UOM_CLASS VARCHAR2 (10)
Primary Unit of Measure Class
QUANTITY_DELIVERED NUMBER

Quantity Delivered
EXPECTED_RECEIPT_QTY NUMBER

Expected Receipt Quantity
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
SHIP_TO_LOCATION_ID NUMBER

ID of the location shipped to
VENDOR_ID NUMBER

Vendor ID
SOURCE VARCHAR2 (240)
Source Code
VENDOR_SITE_ID NUMBER

Vendor Site ID
SUPPLIER_SITE VARCHAR2 (15)
Supplier Site
NEED_BY_DATE DATE

Need by date
PROMISED_DATE DATE

Promised date
EXPECTED_RECEIPT_DATE DATE

Expected receipt date
ORDERED_QTY NUMBER

Quantity Ordered
ORDERED_UOM VARCHAR2 (25)
Unit of measure of the order
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution id
DELIVER_TO_LOCATION_ID NUMBER

ID of the location delivered to
REQ_DISTRIBUTION_ID NUMBER

Requisition distribution id
PO_DISTRIBUTION_NUM NUMBER

Purchase Order distribution number
VENDOR_PRODUCT_NUM VARCHAR2 (25)
Vendor product number
PO_NUM_REL_NUM VARCHAR2 (61)
Purchase Order release number
ORDER_ID NUMBER

Order ID
ORDER_NUMBER NUMBER

Order Number
REQ_LINE_ID NUMBER

Requisition Line ID
ORDER_TYPE_CODE CHAR (2)
Code of order type
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
MANUFACTURER_PART_NUMBER VARCHAR2 (30)
Number of manufacturer part
OPERATING_UNIT VARCHAR2 (240)
Operating Unit
QUANTITY_INVOICED NUMBER

Quantity Invoiced
Query Text

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


SELECT RECEIPT_DATE
,      REQUESTOR_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      REQ_HEADER_ID
,      REQUISITION_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      TO_ORGANIZATION_ID
,      ITEM_ID
,      PRIMARY_UOM
,      PRIMARY_UOM_CLASS
,      QUANTITY_DELIVERED
,      EXPECTED_RECEIPT_QTY
,      ITEM_DESCRIPTION
,      SHIP_TO_LOCATION_ID
,      VENDOR_ID
,      SOURCE
,      VENDOR_SITE_ID
,      SUPPLIER_SITE
,      NEED_BY_DATE
,      PROMISED_DATE
,      EXPECTED_RECEIPT_DATE
,      ORDERED_QTY
,      ORDERED_UOM
,      PO_DISTRIBUTION_ID
,      DELIVER_TO_LOCATION_ID
,      REQ_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUM
,      VENDOR_PRODUCT_NUM
,      PO_NUM_REL_NUM
,      ORDER_ID
,      ORDER_NUMBER
,      REQ_LINE_ID
,      ORDER_TYPE_CODE
,      MATCHING_BASIS
,      MANUFACTURER_PART_NUMBER
,      OPERATING_UNIT
,      QUANTITY_INVOICED
FROM APPS.POR_RCV_PURCHASE_ITEMS_V;

Dependencies

[top of page]

APPS.POR_RCV_PURCHASE_ITEMS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_DISTRIBUTIONS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES
SynonymPO_REQ_DISTRIBUTIONS
ViewPO_VENDORS
ViewPO_VENDOR_SITES
ViewPO_VENDOR_SITES_ALL

APPS.POR_RCV_PURCHASE_ITEMS_V is not referenced by any database object