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


VIEW: APPS.AST_MYTEAM_SALESOPP_NAME_UWQ_V

Object Details
Object Name: AST_MYTEAM_SALESOPP_NAME_UWQ_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAST.AST_MYTEAM_SALESOPP_NAME_UWQ_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
IEU_OBJECT_FUNCTION VARCHAR2 (30)
IEU_OBJECT_PARAMETERS VARCHAR2 (2000)
IEU_MEDIA_TYPE_UUID CHAR (0)
IEU_PARAM_PK_COL CHAR (7)
IEU_PARAM_PK_VALUE VARCHAR2 (40)
LEAD_ID NUMBER
Yes
DESCRIPTION VARCHAR2 (240)
TOTAL_AMOUNT NUMBER

LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PARTY_ID NUMBER
Yes
PARTY_NAME VARCHAR2 (360) Yes
ORG_ID NUMBER

Organization identifier
SALES_STAGE_ID NUMBER

SALES_STAGE_NAME VARCHAR2 (60)
LEAD_NUMBER VARCHAR2 (30) Yes
STATUS_CODE VARCHAR2 (30) Yes
STATUS_MEANING VARCHAR2 (240)
WIN_PROBABILITY NUMBER

PROBABILITY_MEANING VARCHAR2 (80)
RESOURCE_ID NUMBER
Yes
OBJECT_CODE CHAR (11)
RESOURCE_TYPE CHAR (13)
CUSTOMER_BUDGET NUMBER

DECISION_DATE DATE

CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CHANNEL_CODE VARCHAR2 (30)
SALES_CHANNEL VARCHAR2 (80)
CURRENCY_CODE VARCHAR2 (15)
PARENT_PROJECT VARCHAR2 (80)
DECISION_TIMEFRAME_CODE VARCHAR2 (30)
DECISION_TIMEFRAME VARCHAR2 (80)
LAST_UPDATED_BYNAME VARCHAR2 (360)
CONTACT_FIRST_NAME VARCHAR2 (150)
CONTACT_LAST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
CONTACT_FULL_NAME VARCHAR2 (364)
SALUTATION VARCHAR2 (60)
CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
CONTACT_JOB_TITLE VARCHAR2 (100)
CONTACT_PARTY_ID NUMBER

PHONE_ID NUMBER

CONTACT_PHONE_NUMBER VARCHAR2 (83)
SALES_METHODOLOGY_ID NUMBER

SALES_METHODOLOGY_NAME VARCHAR2 (100)
VEHICLE_RESPONSE_CODE VARCHAR2 (30)
VEHICLE_RESPONSE_MEANING VARCHAR2 (80)
SOURCE_PROMOTION_ID NUMBER

ADDRESS_ID NUMBER

ADDRESS1 VARCHAR2 (240)
CITY VARCHAR2 (60)
STATE VARCHAR2 (60)
COUNTRY VARCHAR2 (60)
PROVINCE VARCHAR2 (60)
POSTAL_CODE VARCHAR2 (60)
LOCATION VARCHAR2 (484)
CLOSE_REASON VARCHAR2 (30)
CLOSE_COMPETITOR_ID NUMBER

CLOSE_COMPETITOR_CODE VARCHAR2 (30)
CLOSE_COMPETITOR VARCHAR2 (255)
CLOSE_COMMENT VARCHAR2 (240)
OPEN_FLAG VARCHAR2 (1)
SOURCE_NAME VARCHAR2 (2000)
SOURCE_CODE VARCHAR2 (30)
FORECAST_AMOUNT NUMBER

Query Text

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


SELECT IEU_OBJECT_FUNCTION
,      IEU_OBJECT_PARAMETERS
,      IEU_MEDIA_TYPE_UUID
,      IEU_PARAM_PK_COL
,      IEU_PARAM_PK_VALUE
,      LEAD_ID
,      DESCRIPTION
,      TOTAL_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PARTY_ID
,      PARTY_NAME
,      ORG_ID
,      SALES_STAGE_ID
,      SALES_STAGE_NAME
,      LEAD_NUMBER
,      STATUS_CODE
,      STATUS_MEANING
,      WIN_PROBABILITY
,      PROBABILITY_MEANING
,      RESOURCE_ID
,      OBJECT_CODE
,      RESOURCE_TYPE
,      CUSTOMER_BUDGET
,      DECISION_DATE
,      CREATION_DATE
,      CHANNEL_CODE
,      SALES_CHANNEL
,      CURRENCY_CODE
,      PARENT_PROJECT
,      DECISION_TIMEFRAME_CODE
,      DECISION_TIMEFRAME
,      LAST_UPDATED_BYNAME
,      CONTACT_FIRST_NAME
,      CONTACT_LAST_NAME
,      PERSON_MIDDLE_NAME
,      CONTACT_FULL_NAME
,      SALUTATION
,      CONTACT_EMAIL_ADDRESS
,      CONTACT_JOB_TITLE
,      CONTACT_PARTY_ID
,      PHONE_ID
,      CONTACT_PHONE_NUMBER
,      SALES_METHODOLOGY_ID
,      SALES_METHODOLOGY_NAME
,      VEHICLE_RESPONSE_CODE
,      VEHICLE_RESPONSE_MEANING
,      SOURCE_PROMOTION_ID
,      ADDRESS_ID
,      ADDRESS1
,      CITY
,      STATE
,      COUNTRY
,      PROVINCE
,      POSTAL_CODE
,      LOCATION
,      CLOSE_REASON
,      CLOSE_COMPETITOR_ID
,      CLOSE_COMPETITOR_CODE
,      CLOSE_COMPETITOR
,      CLOSE_COMMENT
,      OPEN_FLAG
,      SOURCE_NAME
,      SOURCE_CODE
,      FORECAST_AMOUNT
FROM APPS.AST_MYTEAM_SALESOPP_NAME_UWQ_V;

Dependencies

[top of page]

APPS.AST_MYTEAM_SALESOPP_NAME_UWQ_V references the following:

SchemaAPPS
ViewAMS_P_SOURCE_CODES_V
ViewAS_ACCESSES_ALL
SynonymAS_FORECAST_PROB_ALL_TL
SynonymAS_LEADS_ALL
SynonymAS_LEAD_CONTACTS_ALL
ViewAS_LOOKUPS
SynonymAS_SALES_METHODOLOGY_TL
SynonymAS_SALES_STAGES_ALL_TL
SynonymAS_STATUSES_TL
SynonymFND_USER
SynonymHZ_CONTACT_POINTS
SynonymHZ_LOCATIONS
SynonymHZ_ORG_CONTACTS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
SynonymJTF_OBJECTS_B
SynonymJTF_RS_RESOURCE_EXTNS
ViewOE_LOOKUPS

APPS.AST_MYTEAM_SALESOPP_NAME_UWQ_V is not referenced by any database object