Skip to content

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

TABLE: APPS.ASF_OPP_TOP_FRCST_MV

Object Details
Object Name: ASF_OPP_TOP_FRCST_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableASF.ASF_OPP_TOP_FRCST_MV
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LEADS NUMBER

SALES_CREDIT_ID NUMBER
Yes
CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Yes
PARTY_TYPE VARCHAR2 (30)
LEAD_ID NUMBER
Yes
OPP_DESCRIPTION VARCHAR2 (240)
BUDGET NUMBER

CURRENCY_CODE VARCHAR2 (15)
CONVERSION_STATUS_FLAG NUMBER

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Yes
WIN_PROBABILITY NUMBER

DECISION_DATE DATE

SALES_STAGE VARCHAR2 (60)
STATUS VARCHAR2 (240)
PARENT_GROUP_ID NUMBER
Yes
PRODUCT_CATEGORY_ID NUMBER

PRODUCT_CAT_SET_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Yes
IMMEDIATE_PARENT_FLAG VARCHAR2 (1) Yes
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
Query Text

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


SELECT LEADS
,      SALES_CREDIT_ID
,      CUSTOMER_NAME
,      CUSTOMER_ID
,      PARTY_TYPE
,      LEAD_ID
,      OPP_DESCRIPTION
,      BUDGET
,      CURRENCY_CODE
,      CONVERSION_STATUS_FLAG
,      SALES_GROUP_ID
,      CREDIT_TYPE_ID
,      SALESFORCE_ID
,      WIN_PROBABILITY
,      DECISION_DATE
,      SALES_STAGE
,      STATUS
,      PARENT_GROUP_ID
,      PRODUCT_CATEGORY_ID
,      PRODUCT_CAT_SET_ID
,      PERIOD_NAME
,      IMMEDIATE_PARENT_FLAG
,      WIN_LOSS_INDICATOR
,      OPP_OPEN_STATUS_FLAG
,      FORECAST_ROLLUP_FLAG
FROM APPS.ASF_OPP_TOP_FRCST_MV;

Dependencies

[top of page]

APPS.ASF_OPP_TOP_FRCST_MV does not reference any database object

APPS.ASF_OPP_TOP_FRCST_MV is not referenced by any database object