[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_PIPE_G_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.BIL_BI_PIPE_G_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRP_TOTAL_FLAG | NUMBER | |||
PARENT_SALES_GROUP_ID | NUMBER | |||
SALES_GROUP_ID | NUMBER | |||
SALESREP_ID | NUMBER | |||
SNAP_DATE | DATE | |||
PRODUCT_CATEGORY_ID | NUMBER | |||
ITEM_ID | NUMBER | |||
PIPELINE_AMT_DAY | NUMBER | |||
PIPELINE_AMT_WEEK | NUMBER | |||
PIPELINE_AMT_PERIOD | NUMBER | |||
PIPELINE_AMT_QUARTER | NUMBER | |||
PIPELINE_AMT_YEAR | NUMBER | |||
WTD_PIPELINE_AMT_DAY | NUMBER | |||
WTD_PIPELINE_AMT_WEEK | NUMBER | |||
WTD_PIPELINE_AMT_PERIOD | NUMBER | |||
WTD_PIPELINE_AMT_QUARTER | NUMBER | |||
WTD_PIPELINE_AMT_YEAR | NUMBER | |||
OPEN_AMT_DAY | NUMBER | |||
OPEN_AMT_WEEK | NUMBER | |||
OPEN_AMT_PERIOD | NUMBER | |||
OPEN_AMT_QUARTER | NUMBER | |||
OPEN_AMT_YEAR | NUMBER | |||
PIPELINE_AMT_DAY_S | NUMBER | |||
PIPELINE_AMT_WEEK_S | NUMBER | |||
PIPELINE_AMT_PERIOD_S | NUMBER | |||
PIPELINE_AMT_QUARTER_S | NUMBER | |||
PIPELINE_AMT_YEAR_S | NUMBER | |||
WTD_PIPELINE_AMT_DAY_S | NUMBER | |||
WTD_PIPELINE_AMT_WEEK_S | NUMBER | |||
WTD_PIPELINE_AMT_PERIOD_S | NUMBER | |||
WTD_PIPELINE_AMT_QUARTER_S | NUMBER | |||
WTD_PIPELINE_AMT_YEAR_S | NUMBER | |||
OPEN_AMT_DAY_S | NUMBER | |||
OPEN_AMT_WEEK_S | NUMBER | |||
OPEN_AMT_PERIOD_S | NUMBER | |||
OPEN_AMT_QUARTER_S | NUMBER | |||
OPEN_AMT_YEAR_S | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT GRP_TOTAL_FLAG
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, SNAP_DATE
, PRODUCT_CATEGORY_ID
, ITEM_ID
, PIPELINE_AMT_DAY
, PIPELINE_AMT_WEEK
, PIPELINE_AMT_PERIOD
, PIPELINE_AMT_QUARTER
, PIPELINE_AMT_YEAR
, WTD_PIPELINE_AMT_DAY
, WTD_PIPELINE_AMT_WEEK
, WTD_PIPELINE_AMT_PERIOD
, WTD_PIPELINE_AMT_QUARTER
, WTD_PIPELINE_AMT_YEAR
, OPEN_AMT_DAY
, OPEN_AMT_WEEK
, OPEN_AMT_PERIOD
, OPEN_AMT_QUARTER
, OPEN_AMT_YEAR
, PIPELINE_AMT_DAY_S
, PIPELINE_AMT_WEEK_S
, PIPELINE_AMT_PERIOD_S
, PIPELINE_AMT_QUARTER_S
, PIPELINE_AMT_YEAR_S
, WTD_PIPELINE_AMT_DAY_S
, WTD_PIPELINE_AMT_WEEK_S
, WTD_PIPELINE_AMT_PERIOD_S
, WTD_PIPELINE_AMT_QUARTER_S
, WTD_PIPELINE_AMT_YEAR_S
, OPEN_AMT_DAY_S
, OPEN_AMT_WEEK_S
, OPEN_AMT_PERIOD_S
, OPEN_AMT_QUARTER_S
, OPEN_AMT_YEAR_S
FROM APPS.BIL_BI_PIPE_G_V;
APPS.BIL_BI_PIPE_G_V is not referenced by any database object
|
|
|