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


TABLE: APPS.ASF_OPP_PRD_MV

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

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

PRODUCT_CAT_SET_ID NUMBER

LEADS NUMBER

BUDGET NUMBER

WIN_LOSS_INDICATOR VARCHAR2 (1)
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
MANAGER_PERSON_ID NUMBER

CONVERSION_PERIOD_TYPE VARCHAR2 (15) Yes
CONVERSION_PERIOD_NAME VARCHAR2 (15) Yes
TO_CURRENCY_CODE VARCHAR2 (15)
PARENT_RESOURCE_ID NUMBER

SALES_GROUP_ID NUMBER

SALESFORCE_ID NUMBER
Yes
CREDIT_TYPE_ID NUMBER

Query Text

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


SELECT PRODUCT_CATEGORY_ID
,      PRODUCT_CAT_SET_ID
,      LEADS
,      BUDGET
,      WIN_LOSS_INDICATOR
,      FORECAST_ROLLUP_FLAG
,      OPP_OPEN_STATUS_FLAG
,      MANAGER_PERSON_ID
,      CONVERSION_PERIOD_TYPE
,      CONVERSION_PERIOD_NAME
,      TO_CURRENCY_CODE
,      PARENT_RESOURCE_ID
,      SALES_GROUP_ID
,      SALESFORCE_ID
,      CREDIT_TYPE_ID
FROM APPS.ASF_OPP_PRD_MV;

Dependencies

[top of page]

APPS.ASF_OPP_PRD_MV does not reference any database object

APPS.ASF_OPP_PRD_MV is not referenced by any database object