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

VIEW: APPS.POR_RCV_CONF_ITEMS_V

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

View Type

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


View to show information of the Receive Items transaction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECEIPT_NUM VARCHAR2 (30)
Receipt Number
RECEIPT_DATE DATE

Receipt Date
REQ_NUMBER VARCHAR2 (20)
Requisition Number
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
RECEIPT_UOM VARCHAR2 (25)
Receipt Unit of Measure
RECEIPT_QUANTITY NUMBER

Receipt Quantity
WAYBILL_AIRBILL_NUM VARCHAR2 (30)
Waybill Airbill Number
PACKING_SLIP VARCHAR2 (25)
Packing Slip
ITEM_COMMENTS VARCHAR2 (4000)
Item Comments
RECEIPT_COMMENTS VARCHAR2 (4000)
Receipt Comments
SOURCE VARCHAR2 (240)
Source of the item
DESTINATION_ORGANIZATION VARCHAR2 (240)
Destination Organization
GROUP_ID NUMBER

Group ID
Query Text

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


SELECT RECEIPT_NUM
,      RECEIPT_DATE
,      REQ_NUMBER
,      ITEM_DESCRIPTION
,      RECEIPT_UOM
,      RECEIPT_QUANTITY
,      WAYBILL_AIRBILL_NUM
,      PACKING_SLIP
,      ITEM_COMMENTS
,      RECEIPT_COMMENTS
,      SOURCE
,      DESTINATION_ORGANIZATION
,      GROUP_ID
FROM APPS.POR_RCV_CONF_ITEMS_V;

Dependencies

[top of page]

APPS.POR_RCV_CONF_ITEMS_V references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymMTL_UNITS_OF_MEASURE
PL/SQL PackagePO_CLM_INTG_GRP - show dependent code
ViewPO_DISTRIBUTIONS_TRX_V
ViewPO_LINES_TRX_V
ViewPO_LINE_LOCATIONS_TRX_V
SynonymPO_REQUISITION_HEADERS
SynonymPO_REQUISITION_LINES
SynonymPO_REQ_DISTRIBUTIONS
ViewPO_VENDORS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.POR_RCV_CONF_ITEMS_V is not referenced by any database object