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_REQ_PURCH_RECEIPTS_V

Object Details

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

View Type

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

View to query receipts based on transaction source type 'PO' for a requisition

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RCV_TRANSACTION_ID	NUMBER		Yes	Receiving Transaction ID
CREATION_DATE	DATE		Yes	Creation Date
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Transaction type
TRANSACTION_DATE	DATE		Yes	Transaction date
EMPLOYEE_ID	NUMBER	(9)		Employee ID
QUANTITY	NUMBER			Quantity ordered
NET_DELIVERED_QUANTITY	NUMBER			Actually quantity received
QUANTITY_ORDERED	NUMBER			Quantity ordered
UNIT_OF_MEASURE	VARCHAR2	(25)		Unit of measure
UNIT_OF_MEASURE_B	VARCHAR2	(25)		Unit of measure
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment header ID
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment Line ID
SOURCE_DOCUMENT_CODE	CHAR	(2)		Source document code
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Code of destination type
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Primary unit of measure
GRANDPARENT_TRANSACTION_ID	NUMBER			ID of the grandparent transaction
PO_HEADER_ID	NUMBER			Purchase Order Header ID
PO_RELEASE_ID	NUMBER			Purchase Order release ID
PO_LINE_ID	NUMBER			Purchase Order line ID
PO_LINE_LOCATION_ID	NUMBER			Purchase Order line location ID
PO_DISTRIBUTION_ID	NUMBER			Purchase Order distribution ID
PO_REVISION_NUM	NUMBER			Purchase Order revisition number
REQ_LINE_ID	NUMBER		Yes	Requisition line ID
REQ_LINE_NUM	NUMBER		Yes	Requisition line number
PO_UNIT_PRICE	NUMBER			Purchase order unit price
CURRENCY_CODE	VARCHAR2	(15)		Currency code
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
ROUTING_ID	NUMBER			Routing ID
ROUTING_STEP_ID	NUMBER			Routing step ID
DELIVER_TO_PERSON_ID	NUMBER	(9)		ID of the person delivered to
DELIVER_TO_LOCATION_ID	NUMBER			ID of the location delivered to
VENDOR_ID	NUMBER			Vendor ID
VENDOR_SITE_ID	NUMBER			Vendor site ID
ORGANIZATION_ID	NUMBER			Organization ID
SUBINVENTORY	VARCHAR2	(10)		Subinventory
LOCATOR_ID	NUMBER			Locator ID
LOCATION_ID	NUMBER			Location ID
RECEIPT_EXCEPTION_FLAG	VARCHAR2	(1)		Receipt exception flag
INSPECTION_STATUS_CODE	VARCHAR2	(25)		Inspection status code
VENDOR_LOT_NUM	VARCHAR2	(30)		Vendor lot number
COMMENTS	VARCHAR2	(240)		Comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		Backup attribute
ATTRIBUTE2	VARCHAR2	(150)		Backup attribute
ATTRIBUTE3	VARCHAR2	(150)		Backup attribute
ATTRIBUTE4	VARCHAR2	(150)		Backup attribute
ATTRIBUTE5	VARCHAR2	(150)		Backup attribute
ATTRIBUTE6	VARCHAR2	(150)		Backup attribute
ATTRIBUTE7	VARCHAR2	(150)		Backup attribute
ATTRIBUTE8	VARCHAR2	(150)		Backup attribute
ATTRIBUTE9	VARCHAR2	(150)		Backup attribute
ATTRIBUTE10	VARCHAR2	(150)		Backup attribute
ATTRIBUTE11	VARCHAR2	(150)		Backup attribute
ATTRIBUTE12	VARCHAR2	(150)		Backup attribute
ATTRIBUTE13	VARCHAR2	(150)		Backup attribute
ATTRIBUTE14	VARCHAR2	(150)		Backup attribute
ATTRIBUTE15	VARCHAR2	(150)		Backup attribute
REQ_DISTRIBUTION_ID	NUMBER			Requisition distribution id
DESTINATION_CONTEXT	VARCHAR2	(30)		Destination context
LOCATOR_ATTRIBUTE	VARCHAR2	(150)		Locator attribute
SOURCE_DOC_UNIT_OF_MEASURE	VARCHAR2	(25)		Source document unit of measure
GOVERNMENT_CONTEXT	VARCHAR2	(30)		Government context
REQ_HEADER_ID	NUMBER		Yes	Requisition header ID
REQ_NUMBER	VARCHAR2	(20)	Yes	Requisition Number
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
RCV_SHIPMENT_NUMBER	VARCHAR2	(30)		Receiving Shipment Number
RCV_LINE_NUMBER	NUMBER		Yes	Receiving line number
PACKING_SLIP	VARCHAR2	(25)		Packing slip
ITEM_ID	NUMBER			Item ID
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
CATEGORY_ID	NUMBER			Category ID
ITEM_REVISION	VARCHAR2	(3)		Item revision
RECEIPT_SOURCE_CODE	VARCHAR2	(25)	Yes	Receipt source code
PO_NUMBER	VARCHAR2	(61)		Purchase Order number
PO_LINE_NUMBER	NUMBER		Yes	Purchase Order line number
PO_SHIPMENT_NUMBER	NUMBER			Purchase Order shipment number
PO_RELEASE_NUMBER	NUMBER			Purchase Order release number
VENDOR	VARCHAR2	(240)		Vendor
NOTE_TO_RECEIVER	VARCHAR2	(480)		Note to receiver
INV_REQ_NOTE_TO_RECEIVER	VARCHAR2	(4000)		Inv Req note to receiver
BILL_OF_LADING	VARCHAR2	(25)		Bill of lading
FREIGHT_CARRIER	VARCHAR2	(25)		Freight carrier
WAYBILL_AIRBILL_NUM	VARCHAR2	(20)		Waybill/airbill number
VENDOR_ITEM_NUMBER	VARCHAR2	(25)		Vendor item number
ORDERED_QTY	NUMBER			Quantity ordered
ORDERED_UOM	VARCHAR2	(25)		Unit of measure of the order
DUE_DATE_VENDOR	DATE			Vendor due date
DUE_DATE_INTERNAL	DATE			Internal due date
PERSON	VARCHAR2	(240)		Person
WIP_ENTITY_ID	NUMBER			WIP entity ID
WIP_LINE_ID	NUMBER			WIP line ID
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			WIP Repetitive schedule ID
WIP_OPERATION_SEQ_NUM	NUMBER			WIP operation sequence number
WIP_RESOURCE_SEQ_NUM	NUMBER			WIP resource sequence number
DEPARTMENT_CODE	VARCHAR2	(10)		Department code
BOM_RESOURCE_ID	NUMBER			BOM resource ID
QTY_RCV_EXCEPTION_CODE	VARCHAR2	(25)		Exception code of receiving quantity
MOVEMENT_ID	NUMBER			Movement ID
INSPECTION_QUALITY_CODE	VARCHAR2	(25)		Inspection quality code
SUBSTITUTE_UNORDERED_CODE	VARCHAR2	(25)		Substitute unordered code
PO_NO_RELEASE_NUMBER	VARCHAR2	(20)	Yes	Purchase Order release number
ORDER_ID	NUMBER			Order ID
SO_NUMBER	NUMBER			SO Number
SOURCE_ORGANIZATION	VARCHAR2	(0)		Source Organization
MATCHING_BASIS	VARCHAR2	(30)	Yes	Matching Basis
OPERATING_UNIT	VARCHAR2	(240)	Yes	Operating unit
CLOSED_CODE	VARCHAR2	(30)		Closed Code
CANCEL_FLAG	VARCHAR2	(1)		Cancel Flag

Query Text

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


SELECT RCV_TRANSACTION_ID
,      CREATION_DATE
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      EMPLOYEE_ID
,      QUANTITY
,      NET_DELIVERED_QUANTITY
,      QUANTITY_ORDERED
,      UNIT_OF_MEASURE
,      UNIT_OF_MEASURE_B
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SOURCE_DOCUMENT_CODE
,      DESTINATION_TYPE_CODE
,      PRIMARY_UNIT_OF_MEASURE
,      GRANDPARENT_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_REVISION_NUM
,      REQ_LINE_ID
,      REQ_LINE_NUM
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ROUTING_ID
,      ROUTING_STEP_ID
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATION_ID
,      RECEIPT_EXCEPTION_FLAG
,      INSPECTION_STATUS_CODE
,      VENDOR_LOT_NUM
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQ_DISTRIBUTION_ID
,      DESTINATION_CONTEXT
,      LOCATOR_ATTRIBUTE
,      SOURCE_DOC_UNIT_OF_MEASURE
,      GOVERNMENT_CONTEXT
,      REQ_HEADER_ID
,      REQ_NUMBER
,      RECEIPT_NUM
,      RCV_SHIPMENT_NUMBER
,      RCV_LINE_NUMBER
,      PACKING_SLIP
,      ITEM_ID
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      ITEM_REVISION
,      RECEIPT_SOURCE_CODE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      PO_SHIPMENT_NUMBER
,      PO_RELEASE_NUMBER
,      VENDOR
,      NOTE_TO_RECEIVER
,      INV_REQ_NOTE_TO_RECEIVER
,      BILL_OF_LADING
,      FREIGHT_CARRIER
,      WAYBILL_AIRBILL_NUM
,      VENDOR_ITEM_NUMBER
,      ORDERED_QTY
,      ORDERED_UOM
,      DUE_DATE_VENDOR
,      DUE_DATE_INTERNAL
,      PERSON
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      DEPARTMENT_CODE
,      BOM_RESOURCE_ID
,      QTY_RCV_EXCEPTION_CODE
,      MOVEMENT_ID
,      INSPECTION_QUALITY_CODE
,      SUBSTITUTE_UNORDERED_CODE
,      PO_NO_RELEASE_NUMBER
,      ORDER_ID
,      SO_NUMBER
,      SOURCE_ORGANIZATION
,      MATCHING_BASIS
,      OPERATING_UNIT
,      CLOSED_CODE
,      CANCEL_FLAG
FROM APPS.POR_RCV_REQ_PURCH_RECEIPTS_V;

Dependencies

[top of page]

APPS.POR_RCV_REQ_PURCH_RECEIPTS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_UNITS_OF_MEASURE; PER_ALL_PEOPLE_F; PER_PEOPLE_F; 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_VENDORS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.POR_RCV_REQ_PURCH_RECEIPTS_V is not referenced by any database object