[Home] [Help]
[Dependency Information]
[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_PG_MV
BIL_OBI_PIPE_G_MV
APPS.BIL_OBI_OPTY_PIPE_PG_V is not referenced by any database object
|
|
|
|