[Home] [Help] [Dependency Information]
Object Name: | BIL_OBI_OPTY_PIPE_PG_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Summarized view on periods for sales pipeline
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_TIME_ID | NUMBER | Effective time id for opportunity | ||
PARENT_SALES_GROUP_ID | NUMBER | Parent sales group id | ||
SALES_GROUP_ID | NUMBER | Sales group id | ||
SALESREP_ID | NUMBER | Sales rep id | ||
PRODUCT_CATEGORY_ID | NUMBER | Product category id | ||
ITEM_ID | NUMBER | item id | ||
ROLLUP_FLAG | VARCHAR2 | (1) | flag for rolled-up and non rolled up data | |
PIPELINE_AMT | NUMBER | Pipeline amt in primary currency | ||
WTD_PIPELINE_AMT | NUMBER | Weighted pipeline amount in primary currency | ||
OPEN_AMT | NUMBER | Open amount in primary currecy | ||
PERIOD_OPEN_AMT | NUMBER | Period open amount in primary currency | ||
PIPELINE_AMT_S | NUMBER | Pipeline amt in secondary currency | ||
WTD_PIPELINE_AMT_S | NUMBER | weighted pipeline amount in secondary currency | ||
OPEN_AMT_S | NUMBER | Open amt in secondary currency | ||
PERIOD_OPEN_AMT_S | NUMBER | Period open amount in secondary currency | ||
WON_OPTY_AMT | NUMBER | Won opportunity amt in primary currency | ||
LOST_OPTY_AMT | NUMBER | Lost opportunity amount in primary currency | ||
NO_OPTY_AMT | NUMBER | No opportunity amt in primary currency | ||
NEW_OPTY_AMT | NUMBER | New opportunity amt in primary currency | ||
CNV_OPTY_AMT | NUMBER | Converted opty opportunity amt in primary currency | ||
NFP_YR | NUMBER | New for year opportunity amount in primay currency | ||
NFP_QTR | NUMBER | New for quarter opportunity amt in primary currency | ||
NFP_PER | NUMBER | New for month opportunity amt in primary currency | ||
WON_OPTY_AMT_S | NUMBER | Won opportunity amount in secondary currency | ||
LOST_OPTY_AMT_S | NUMBER | Lost opportunity amt in secondary currency | ||
NO_OPTY_AMT_S | NUMBER | No opportunity amt in secondary currency | ||
NEW_OPTY_AMT_S | NUMBER | New opportuninty amt in secondary currency | ||
CNV_OPTY_AMT_S | NUMBER | Converted opportunity amt in secondary currency | ||
NFP_YR_S | NUMBER | New for year opportunity amount in secondary currency | ||
NFP_QTR_S | NUMBER | New for quarter opportunity amt in secondary curency | ||
NFP_PER_S | NUMBER | New for month opportunity amt in secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_TIME_ID
, PARENT_SALES_GROUP_ID
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ROLLUP_FLAG
, PIPELINE_AMT
, WTD_PIPELINE_AMT
, OPEN_AMT
, PERIOD_OPEN_AMT
, PIPELINE_AMT_S
, WTD_PIPELINE_AMT_S
, OPEN_AMT_S
, PERIOD_OPEN_AMT_S
, WON_OPTY_AMT
, LOST_OPTY_AMT
, NO_OPTY_AMT
, NEW_OPTY_AMT
, CNV_OPTY_AMT
, NFP_YR
, NFP_QTR
, NFP_PER
, WON_OPTY_AMT_S
, LOST_OPTY_AMT_S
, NO_OPTY_AMT_S
, NEW_OPTY_AMT_S
, CNV_OPTY_AMT_S
, NFP_YR_S
, NFP_QTR_S
, NFP_PER_S
FROM APPS.BIL_OBI_OPTY_PIPE_PG_V;
APPS.BIL_OBI_OPTY_PIPE_PG_V is not referenced by any database object
|
|
|