[Home] [Help] [Dependency Information]
Object Name: | PV_CHN_BIN_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | PV.PV_CHN_BIN_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 0 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_RESOURCE_ID | NUMBER | |||
CHANNEL_CODE | VARCHAR2 | (30) | ||
CNT | NUMBER | |||
TOTAL_AMOUNT | NUMBER | |||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | ||
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PERIOD_TYPE | VARCHAR2 | (15) | Yes | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
LEAD_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_RESOURCE_ID
, CHANNEL_CODE
, CNT
, TOTAL_AMOUNT
, WIN_LOSS_INDICATOR
, OPP_OPEN_STATUS_FLAG
, CURRENCY_CODE
, PERIOD_TYPE
, PERIOD_NAME
, LEAD_ID
FROM APPS.PV_CHN_BIN_MV;
APPS.PV_CHN_BIN_MV does not reference any database object
APPS.PV_CHN_BIN_MV is not referenced by any database object
|
|
|