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


TABLE: APPS.ASF_OPP_CHN_FRCST_MV

Object Details
Object Name: ASF_OPP_CHN_FRCST_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableASF.ASF_OPP_CHN_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

LEAD_ID NUMBER
Yes
CHANNEL_CODE VARCHAR2 (30)
BUDGET NUMBER

CURRENCY_CODE VARCHAR2 (15)
CONVERSION_STATUS_FLAG NUMBER

SALES_GROUP_ID NUMBER

CREDIT_TYPE_ID NUMBER

SALESFORCE_ID NUMBER
Yes
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
,      LEAD_ID
,      CHANNEL_CODE
,      BUDGET
,      CURRENCY_CODE
,      CONVERSION_STATUS_FLAG
,      SALES_GROUP_ID
,      CREDIT_TYPE_ID
,      SALESFORCE_ID
,      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_CHN_FRCST_MV;

Dependencies

[top of page]

APPS.ASF_OPP_CHN_FRCST_MV does not reference any database object

APPS.ASF_OPP_CHN_FRCST_MV is not referenced by any database object