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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This View Displays Retruns Information for Shipments on Purchase Orders belonging to all organizations.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization Identifier
PARENT_TRANSACTION_ID	NUMBER			Parent Transaction Identifier
SHIPMENT_HEADER_ID	NUMBER		Yes	Shipment Header Identifier
SHIPMENT_LINE_ID	NUMBER		Yes	Shipment Line Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	Transaction Type
TRANSACTION_DATE	DATE		Yes	Transaction Date
TRANSACT_QTY	NUMBER			Transaction Quantity
TRANSACT_UOM	VARCHAR2	(25)		Transaction Unit of Measure
PRIMARY_UOM	VARCHAR2	(25)		Primary Unit of Measure
PRIMARY_QUANTITY	NUMBER			Primary Quantity
QUANTITY_RECEIVED	NUMBER			Quantity Received
NET_PRIMARY_QUANTITY	NUMBER			Net Primary Quantity
ITEM_ID	NUMBER			Item Identifier
ITEM_REV	VARCHAR2	(3)		Item Rev.
ITEM_DESC	VARCHAR2	(240)		Item Description
VENDOR_ITEM_NUM	VARCHAR2	(25)		Vendor Item Number
DESTINATION_TYPE	VARCHAR2	(25)		Destination Type
PO_HEADER_ID	NUMBER			Purchase Order Header Identifier
PO_LINE_ID	NUMBER			Purchase Order Line Identifier
PO_LINE_LOCATION_ID	NUMBER			Purchase Order Line Location Identifier
PO_DISTRIBUTION_ID	NUMBER			Purchase Order Distribution Identifier
PO_RELEASE_ID	NUMBER			Purchase Order Release Identifier
ROUTING_HEADER_ID	NUMBER			Routing Header Identifier
SHIP_TO_LOCATION_ID	NUMBER			Ship-to Location Identifier
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship-to Location
SHIP_TO_LOCATION_DESC	VARCHAR2	(240)		Ship-to Location Description
EMPLOYEE_ID	NUMBER	(9)		Employee Identifier
RECEIVER	VARCHAR2	(240)		Receiver
DELIVER_TO_LOCATION_ID	NUMBER			Deliver to Location Identifier
DELIVER_TO_PERSON_ID	NUMBER	(9)		Deliver to Person Identifier
SOURCE_DOC_CODE	VARCHAR2	(25)		Source Document Code
SOURCE_DOC_UOM	VARCHAR2	(25)		Source Document Unit of Measure
SOURCE_DOC_QTY	NUMBER			Source Document Quantity
SOURCE_TYPE	VARCHAR2	(25)	Yes	Source Type
SUPPLIER_ID	NUMBER			Supplier Identifier
SUPPLIER	VARCHAR2	(240)		Supplier
VENDOR_ID	NUMBER			Vendor Identifier
VENDOR_NAME	VARCHAR2	(240)		Vendor Name
VENDOR_NUMBER	VARCHAR2	(30)	Yes	Vendor Number
SUPPLIER_SITE_ID	NUMBER			Supplier Site Identifier
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site
WIP_ENTITY_ID	NUMBER			Work-in Process Entity Identifier
INSPECTION_STATUS_CODE	VARCHAR2	(25)		Inspection Status Code
REASON_ID	NUMBER			Reason Identifier
COMMENTS	VARCHAR2	(240)		Comments
VENDOR_LOT_NUM	VARCHAR2	(30)		Vendor Lot Number
RMA_REFERENCE	VARCHAR2	(30)		RMA Reference
RECEIPT_EXCEPTION_FLAG	VARCHAR2	(1)		Receipt Exception Flag
RECEIPT_NUM	VARCHAR2	(30)		Receipt Number
RECEIPT_DATE	DATE		Yes	Receipt Date
PO_NUM	VARCHAR2	(20)	Yes	Purchase Order Number
PO_LINE	NUMBER		Yes	Purchase Order Line
PO_SHIPMENT	NUMBER			Purcahse Order Shipment
SHIPMENT_NUM	VARCHAR2	(30)		Shipment Number
BILL_OF_LADING	VARCHAR2	(25)		Bill of Lading
PACKING_SLIP	VARCHAR2	(25)		Packing Slip
FREIGHT_CARRIER	VARCHAR2	(25)		Freight Carrier
PO_RELEASE	NUMBER			Purcahse Order Release
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of Measure Look-up Code
NEED_BY_DATE	DATE			Need-by Date
PROMISED_DATE	DATE			Promised Date
REASON	VARCHAR2	(30)		Reason
SUPPLIER_URL	VARCHAR2	(150)		Supplier Url
ITEM_URL	VARCHAR2	(240)		Item Url
ITEM_NUM	VARCHAR2	(40)		Item Number
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)		Waybill Airbill Number
PO_ORG_ID	NUMBER			Purchase Order Organization Identifier
ORG_NAME	VARCHAR2	(240)		Organization Name
CONSIGNED_FLAG	VARCHAR2	(1)		Consigned Flag
SUPPLIER_REF_NUMBER	VARCHAR2	(150)		Configuration Id

Query Text

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


SELECT ORGANIZATION_ID
,      PARENT_TRANSACTION_ID
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      TRANSACTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_DATE
,      TRANSACT_QTY
,      TRANSACT_UOM
,      PRIMARY_UOM
,      PRIMARY_QUANTITY
,      QUANTITY_RECEIVED
,      NET_PRIMARY_QUANTITY
,      ITEM_ID
,      ITEM_REV
,      ITEM_DESC
,      VENDOR_ITEM_NUM
,      DESTINATION_TYPE
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      PO_RELEASE_ID
,      ROUTING_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_TO_LOCATION_DESC
,      EMPLOYEE_ID
,      RECEIVER
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      SOURCE_DOC_CODE
,      SOURCE_DOC_UOM
,      SOURCE_DOC_QTY
,      SOURCE_TYPE
,      SUPPLIER_ID
,      SUPPLIER
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      WIP_ENTITY_ID
,      INSPECTION_STATUS_CODE
,      REASON_ID
,      COMMENTS
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      RECEIPT_EXCEPTION_FLAG
,      RECEIPT_NUM
,      RECEIPT_DATE
,      PO_NUM
,      PO_LINE
,      PO_SHIPMENT
,      SHIPMENT_NUM
,      BILL_OF_LADING
,      PACKING_SLIP
,      FREIGHT_CARRIER
,      PO_RELEASE
,      UNIT_MEAS_LOOKUP_CODE
,      NEED_BY_DATE
,      PROMISED_DATE
,      REASON
,      SUPPLIER_URL
,      ITEM_URL
,      ITEM_NUM
,      WAYBILL_AIRBILL_NUM
,      PO_ORG_ID
,      ORG_NAME
,      CONSIGNED_FLAG
,      SUPPLIER_REF_NUMBER
FROM APPS.POS_RCV_RETURNS_V;

Dependencies

[top of page]

APPS.POS_RCV_RETURNS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_KFV; MTL_TRANSACTION_REASONS; ORG_ORGANIZATION_DEFINITIONS; PER_ALL_PEOPLE_F; POS_PO_RCV_QTY - show dependent code; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS

APPS.POS_RCV_RETURNS_V is not referenced by any database object