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

VIEW: APPS.POR_RCV_ALL_ITEMS_V1

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

View Type

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


POR_RCV_ALL_ITEMS_V1 is a view that returns details of all items receivable for a requisition like requisition number, line id, delivery and item information like unit of measure, supplier, etc


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIPT_DATE DATE

Receipt date
REQUESTOR_ID NUMBER

Requester identifier
REQUESTER VARCHAR2 (240)
Requester
PO_HEADER_ID NUMBER
Yes PO header unique identifier
PO_NUMBER VARCHAR2 (20) Yes PO number
PO_LINE_ID NUMBER
Yes PO line identifier
PO_LINE_LOCATION_ID NUMBER
Yes PO line location identifier
PO_RELEASE_NUMBER NUMBER

PO Release number
PO_LINE_NUMBER VARCHAR2 (240)
PO line number
PO_SHIPMENT_NUMBER NUMBER

PO shipment number
TO_ORGANIZATION_ID NUMBER

Ship to Organization identifier
ITEM_ID NUMBER

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

Quantity delivered
EXPECTED_RECEIPT_QTY NUMBER

Expected receipt quantity
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
SHIP_TO_LOCATION_ID NUMBER

Delivery location identifier
VENDOR_ID NUMBER

Supplier (vendor) identifier
SOURCE VARCHAR2 (240)
Supplier name
NEED_BY_DATE DATE

Date needed by
PROMISED_DATE DATE

Date promised by
EXPECTED_RECEIPT_DATE DATE

Expected receipt date
ORDERED_QTY NUMBER

Ordered quantity
ORDERED_UOM VARCHAR2 (25)
Ordered Quantity UOM
PO_DISTRIBUTION_ID NUMBER
Yes PO Distribution Id
PO_NUM_REL_NUM VARCHAR2 (61)
PO number concatenated with Release Number
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Flag indicating if a receipt is required
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination Type Code
REVISION_NUM NUMBER

Revision Number
REQUISITION_CREATION_DATE DATE

Requisition creation date
CURRENCY_CODE VARCHAR2 (15)
Currency Code
UNIT_PRICE NUMBER

Unit Price
MATCHING_BASIS VARCHAR2 (30)
Matching Basis
PURCHASE_BASIS VARCHAR2 (30)
Purchase Basis
QUANTITY_INVOICED NUMBER

Quantity Invoiced
JOB VARCHAR2 (700)
Job
START_DATE DATE

Start Date
END_DATE DATE

End Date
WF_ITEM_KEY VARCHAR2 (240)
Workflow Item Key
INVOICED_VAL_IN_NTFN NUMBER

Invoiced value in notification
PRIMARY_UOM_NON_TL VARCHAR2 (25)
Primary UOM
Query Text

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


SELECT RECEIPT_DATE
,      REQUESTOR_ID
,      REQUESTER
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_RELEASE_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
,      NEED_BY_DATE
,      PROMISED_DATE
,      EXPECTED_RECEIPT_DATE
,      ORDERED_QTY
,      ORDERED_UOM
,      PO_DISTRIBUTION_ID
,      PO_NUM_REL_NUM
,      RECEIPT_REQUIRED_FLAG
,      DESTINATION_TYPE_CODE
,      REVISION_NUM
,      REQUISITION_CREATION_DATE
,      CURRENCY_CODE
,      UNIT_PRICE
,      MATCHING_BASIS
,      PURCHASE_BASIS
,      QUANTITY_INVOICED
,      JOB
,      START_DATE
,      END_DATE
,      WF_ITEM_KEY
,      INVOICED_VAL_IN_NTFN
,      PRIMARY_UOM_NON_TL
FROM APPS.POR_RCV_ALL_ITEMS_V1;

Dependencies

[top of page]

APPS.POR_RCV_ALL_ITEMS_V1 references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_UNITS_OF_MEASURE
SynonymPER_ALL_PEOPLE_F
SynonymPER_JOBS
PL/SQL PackagePO_CLM_INTG_GRP - show dependent code
ViewPO_DISTRIBUTIONS_TRX_V
SynonymPO_HEADERS
ViewPO_LINES_TRX_V
ViewPO_LINE_LOCATIONS_TRX_V
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
APPS.POR_RCV_ALL_ITEMS_V1 is referenced by following:

SchemaAPPS
Package BodyPORCPTWF - show dependent code