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


TABLE: APPS.ASF_LEADS_CHN_MAIN_MV

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

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

BUDGETAMOUNT NUMBER

CURRENCY_CODE CHAR (3)
CHANNEL_CODE VARCHAR2 (30)
MANAGER_PERSON_ID NUMBER

PERIOD_NAME VARCHAR2 (15) Yes
PERIOD_TYPE VARCHAR2 (15) Yes
PARENT_RESOURCE_ID NUMBER

Query Text

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


SELECT CHANNELS
,      BUDGETAMOUNT
,      CURRENCY_CODE
,      CHANNEL_CODE
,      MANAGER_PERSON_ID
,      PERIOD_NAME
,      PERIOD_TYPE
,      PARENT_RESOURCE_ID
FROM APPS.ASF_LEADS_CHN_MAIN_MV;

Dependencies

[top of page]

APPS.ASF_LEADS_CHN_MAIN_MV does not reference any database object

APPS.ASF_LEADS_CHN_MAIN_MV is not referenced by any database object