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: ViewPO.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) Yes 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 (20)
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:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_TRANSACTION_REASONS
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOS_PO_RCV_QTY - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.POS_RCV_RETURNS_V is not referenced by any database object