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

VIEW: APPS.MSD_SR_OPPORTUNITY_V

Object Details
Object Name: MSD_SR_OPPORTUNITY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_SR_OPPORTUNITY_V
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 Sales Opportunity. This view would be applied to an Oracle Applications 11i instance from which the Sales Opportunity information is to be retrieved.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEAD_NUMBER VARCHAR2 (0)
Lead Number
INTEREST_TYPE_PK VARCHAR2 (0)
Interest Type Pk
INTEREST_TYPE VARCHAR2 (0)
Interest Type
PRIMARY_INTEREST_CODE_PK VARCHAR2 (0)
Primary Interest Code Pk
PRIMARY_INTEREST_CODE VARCHAR2 (0)
Primary Interest Code
SECONDARY_INTEREST_CODE_PK VARCHAR2 (0)
Secondary Interest Code Pk
SECONDARY_INTEREST_CODE VARCHAR2 (0)
Secondary Interest Code
SR_ITEM_PK VARCHAR2 (0)
Item Pk
ITEM VARCHAR2 (0)
Item
SR_INV_ORG_PK VARCHAR2 (0)
Inv Org Pk
INV_ORG VARCHAR2 (0)
Inv Org
QUANTITY VARCHAR2 (0)
Quantity
AMOUNT VARCHAR2 (0)
Amount
SR_CUSTOMER_PK VARCHAR2 (0)
Customer Pk
CUSTOMER VARCHAR2 (0)
Customer
SR_SHIP_TO_LOC_PK VARCHAR2 (0)
Ship To Loc Pk
SHIP_TO_LOC VARCHAR2 (0)
Ship To Loc
SR_SALES_CHANNEL_PK VARCHAR2 (0)
Sales Channel Pk
SALES_CHANNEL VARCHAR2 (0)
Sales Channel
SR_SALES_REP_PK VARCHAR2 (0)
Sales Rep Pk
SALES_REP VARCHAR2 (0)
Sales Rep
SR_USER_DEFINED1_PK VARCHAR2 (0)
User Defined1 Pk
USER_DEFINED1 VARCHAR2 (0)
User Defined1
SR_USER_DEFINED2_PK VARCHAR2 (0)
User Defined2 Pk
USER_DEFINED2 VARCHAR2 (0)
User Defined2
SHIP_DATE VARCHAR2 (0)
Ship Date
WIN_PROBABILITY VARCHAR2 (0)
Win Probability
STATUS VARCHAR2 (0)
Status
Query Text

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


SELECT LEAD_NUMBER
,      INTEREST_TYPE_PK
,      INTEREST_TYPE
,      PRIMARY_INTEREST_CODE_PK
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE_PK
,      SECONDARY_INTEREST_CODE
,      SR_ITEM_PK
,      ITEM
,      SR_INV_ORG_PK
,      INV_ORG
,      QUANTITY
,      AMOUNT
,      SR_CUSTOMER_PK
,      CUSTOMER
,      SR_SHIP_TO_LOC_PK
,      SHIP_TO_LOC
,      SR_SALES_CHANNEL_PK
,      SALES_CHANNEL
,      SR_SALES_REP_PK
,      SALES_REP
,      SR_USER_DEFINED1_PK
,      USER_DEFINED1
,      SR_USER_DEFINED2_PK
,      USER_DEFINED2
,      SHIP_DATE
,      WIN_PROBABILITY
,      STATUS
FROM APPS.MSD_SR_OPPORTUNITY_V;

Dependencies

[top of page]

APPS.MSD_SR_OPPORTUNITY_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.MSD_SR_OPPORTUNITY_V is not referenced by any database object