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.RCV_RECEIVING_VALUE_VIEW

Object Details

Object Name:	RCV_RECEIVING_VALUE_VIEW
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.RCV_RECEIVING_VALUE_VIEW
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER			Item unique identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Unit of measure for the item
LOCATION_ID	NUMBER			Receiving location unique identifier
TO_ORGANIZATION_ID	NUMBER			Destination organization unique identifier
TO_ORG_PRIMARY_QUANTITY	NUMBER			Transaction quantity in terms of the item's primary unit of measure
RECEIPT_DATE	DATE			Date the quantity is received
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
SHIPMENT_NUM	VARCHAR2	(30)		Shipment number assigned by the shipment's source
SHIPPED_DATE	DATE			Shipping date
FREIGHT_CARRIER_CODE	VARCHAR2	(25)		Carrier responsible for shipping
QUANTITY_SHIPPED	NUMBER			Quantity Shipped
DESTINATION_TYPE_CODE	VARCHAR2	(25)	Yes	Destination type
PACKING_SLIP	VARCHAR2	(25)		Packing slip number
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)		Source document type
DELIVER_TO_LOCATION_ID	NUMBER			Deliver-to location unique identifier
SOURCE_DOCUMENT	VARCHAR2	(30)		Source document number
DOCUMENT_LINE_NUM	NUMBER			Source document line number
ACTUAL_PRICE	NUMBER			Actual price
VENDOR_ID	NUMBER			Vendor unique identifier
RCV_TRANSACTION_ID	NUMBER
BOM_RESOURCE_ID	NUMBER
WIP_ENTITY_ID	NUMBER
WIP_RESOURCE_SEQ_NUM	NUMBER
WIP_OPERATION_SEQ_NUM	NUMBER
WIP_REPETITIVE_SCHEDULE_ID	NUMBER

Query Text

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


SELECT ITEM_ID
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      UNIT_OF_MEASURE
,      LOCATION_ID
,      TO_ORGANIZATION_ID
,      TO_ORG_PRIMARY_QUANTITY
,      RECEIPT_DATE
,      RECEIPT_NUM
,      SHIPMENT_NUM
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      QUANTITY_SHIPPED
,      DESTINATION_TYPE_CODE
,      PACKING_SLIP
,      SOURCE_DOCUMENT_CODE
,      DELIVER_TO_LOCATION_ID
,      SOURCE_DOCUMENT
,      DOCUMENT_LINE_NUM
,      ACTUAL_PRICE
,      VENDOR_ID
,      RCV_TRANSACTION_ID
,      BOM_RESOURCE_ID
,      WIP_ENTITY_ID
,      WIP_RESOURCE_SEQ_NUM
,      WIP_OPERATION_SEQ_NUM
,      WIP_REPETITIVE_SCHEDULE_ID
FROM APPS.RCV_RECEIVING_VALUE_VIEW;

Dependencies

[top of page]

APPS.RCV_RECEIVING_VALUE_VIEW references the following:

APPS: MTL_SUPPLY; PO_DISTRIBUTIONS; PO_HEADERS; PO_LINES; PO_LINE_LOCATIONS; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.RCV_RECEIVING_VALUE_VIEW is not referenced by any database object