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_PURCHASE_RECEIPTS_V

Object Details

Object Name:	POR_RCV_PURCHASE_RECEIPTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_RCV_PURCHASE_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'

[View Source]

Columns

Name	Datatype	Length	Comments
APPROVED_FLAG	VARCHAR2	(1)	Approved Flag
RCV_TRANSACTION_ID	NUMBER		Receiving Transaction ID
CREATION_DATE	DATE		Date of creation
TRANSACTION_TYPE	VARCHAR2	(25)	Transaction type
TRANSACTION_DATE	DATE		Date of transaction
EMPLOYEE_ID	NUMBER	(9)	Employee ID
QUANTITY	NUMBER		Quantity ordered
NET_DELIVERED_QUANTITY	NUMBER		Quantity actually 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		Shipment header id
SHIPMENT_LINE_ID	NUMBER		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 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 revision number
REQ_LINE_ID	NUMBER		Requisition Line ID
REQ_LINE_NUM	NUMBER		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		Requisition header id
REQ_NUMBER	VARCHAR2	(20)	Requisition number
RECEIPT_NUM	VARCHAR2	(30)	Receipt number
RCV_SHIPMENT_NUMBER	VARCHAR2	(30)	Receiving shipment number
RCV_LINE_NUMBER	NUMBER		Receiving line number
PACKING_SLIP	VARCHAR2	(25)	Packing slip
ITEM_ID	NUMBER		ID of the item
ITEM_DESCRIPTION	VARCHAR2	(240)	item description
CATEGORY_ID	NUMBER		Category id
ITEM_REVISION	VARCHAR2	(3)	Item revision
RECEIPT_SOURCE_CODE	VARCHAR2	(25)	Receipt source code
PO_NUMBER	VARCHAR2	(91)	Purchase Order Number
PO_LINE_NUMBER	VARCHAR2	(240)	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)	Note to receiver
BILL_OF_LADING	VARCHAR2	(25)	Bill of Lading
FREIGHT_CARRIER	VARCHAR2	(25)	Freight carrier
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)	Number of waybill/airbill
VENDOR_ITEM_NUMBER	VARCHAR2	(25)	Vendor item number
ORDERED_QTY	NUMBER		Quantity ordered
ORDERED_UOM	VARCHAR2	(25)	Unit of measure ordered
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)	Qunaity receiving exception code
MOVEMENT_ID	NUMBER		Movement id
INSPECTION_QUALITY_CODE	VARCHAR2	(25)	Inspection quality code
SUBSTITUTE_UNORDERED_CODE	VARCHAR2	(25)	Substitue unordered code
PO_NO_RELEASE_NUMBER	VARCHAR2	(50)	Purchase Order release number
ORDER_ID	NUMBER		Order ID
SO_NUMBER	NUMBER		SO NUmber
SOURCE_ORGANIZATION	VARCHAR2	(0)	Source organization
MATCHING_BASIS	VARCHAR2	(30)	Matching basis
OPERATING_UNIT	VARCHAR2	(240)	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 APPROVED_FLAG
,      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_PURCHASE_RECEIPTS_V;

Dependencies

[top of page]

APPS.POR_RCV_PURCHASE_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_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PER_ALL_PEOPLE_F; PER_PEOPLE_F; PO_CLM_INTG_GRP - show dependent code; PO_DISTRIBUTIONS; PO_DISTRIBUTIONS_TRX_V; PO_HEADERS; PO_HEADERS_ALL; PO_LINES_TRX_V; PO_LINE_LOCATIONS_TRX_V; PO_RELEASES; 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_PURCHASE_RECEIPTS_V is not referenced by any database object