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


TABLE: APPS.ASF_VAR_MV

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

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

PARENT_RESOURCE_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
WIN_LOSS_INDICATOR VARCHAR2 (1)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
LEAD_ID NUMBER
Yes
SALES_CREDIT_AMOUNT NUMBER

CUSTOMER_NAME VARCHAR2 (360)
CUSTOMER_ID NUMBER
Yes
OPP_DESCRIPTION VARCHAR2 (240)
WIN_PROBABILITY NUMBER

PARTY_TYPE VARCHAR2 (30)
OPPORTUNITY_CREATION_DATE DATE

CREDIT_TYPE_ID NUMBER

DECISION_DATE DATE

STATUS VARCHAR2 (240)
Query Text

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


SELECT MANAGER_PERSON_ID
,      PARENT_RESOURCE_ID
,      CURRENCY_CODE
,      WIN_LOSS_INDICATOR
,      OPP_OPEN_STATUS_FLAG
,      LEAD_ID
,      SALES_CREDIT_AMOUNT
,      CUSTOMER_NAME
,      CUSTOMER_ID
,      OPP_DESCRIPTION
,      WIN_PROBABILITY
,      PARTY_TYPE
,      OPPORTUNITY_CREATION_DATE
,      CREDIT_TYPE_ID
,      DECISION_DATE
,      STATUS
FROM APPS.ASF_VAR_MV;

Dependencies

[top of page]

APPS.ASF_VAR_MV does not reference any database object

APPS.ASF_VAR_MV is not referenced by any database object