DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.MSD_SR_PRODUCT_RETURN_V

Object Details
Object Name: MSD_SR_PRODUCT_RETURN_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This is the Source View for Product Return Data. This view would be applied to an Oracle Applications 11i instance from which the Product Return information is to be retrieved.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

Inv Org Pk
INV_ORG VARCHAR2 (0)
Inv Org
SR_ITEM_PK NUMBER

Item Pk
ITEM VARCHAR2 (0)
Item
SR_CUSTOMER_PK NUMBER

Customer Pk
CUSTOMER VARCHAR2 (0)
Customer
SR_SALES_CHANNEL_PK VARCHAR2 (40)
Sales Channel Pk
SALES_CHANNEL VARCHAR2 (0)
Sales Channel
SR_SALES_REP_PK NUMBER

Sales Rep Pk
SALES_REP VARCHAR2 (0)
Sales Rep
SR_SHIP_TO_LOC_PK NUMBER

Ship To Loc Pk
SHIP_TO_LOC VARCHAR2 (0)
Ship To Loc
RETURN_DATE DATE

Booked Date
RETURN_AMOUNT NUMBER

Amount
RETURN_QTY NUMBER

Qty Ordered
RMA_TYPE VARCHAR2 (30) Yes RMA Type
Query Text

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


SELECT SR_INV_ORG_PK
,      INV_ORG
,      SR_ITEM_PK
,      ITEM
,      SR_CUSTOMER_PK
,      CUSTOMER
,      SR_SALES_CHANNEL_PK
,      SALES_CHANNEL
,      SR_SALES_REP_PK
,      SALES_REP
,      SR_SHIP_TO_LOC_PK
,      SHIP_TO_LOC
,      RETURN_DATE
,      RETURN_AMOUNT
,      RETURN_QTY
,      RMA_TYPE
FROM APPS.MSD_SR_PRODUCT_RETURN_V;

Dependencies

[top of page]

APPS.MSD_SR_PRODUCT_RETURN_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymMSD_APP_INSTANCE_ORGS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_SYSTEM_ITEMS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES_ALL
SynonymOE_TRANSACTION_TYPES_TL
SynonymRA_SALESREPS_ALL
SynonymSO_LOOKUPS

APPS.MSD_SR_PRODUCT_RETURN_V is not referenced by any database object