[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_PIPELINE_STG |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_PIPELINE_STG |
Subobject Name: | |
Status: | VALID |
Staging table for sales open and pipeline amounts
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_PIPELINE_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SNAP_DATE
LEAD_ID LINE_ID CREDIT_ID |
BIL_BI_PIPELINE_STG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
SNAP_DATE
SALES_GROUP_ID SALESREP_ID LEAD_ID ITEM_ID ITEM_ORGANIZATION_ID PRODUCT_CATEGORY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_ID | NUMBER | Yes | Opportunity identifier | |
SALES_GROUP_ID | NUMBER | Yes | Sales group identifier | |
SALESREP_ID | NUMBER | Yes | Salesrep identifier | |
SNAP_DATE | DATE | Yes | The date on which the snapshot is taken. Snapshot before 6pm are considered taken for previous day. | |
EFFECTIVE_DATE | DATE | Yes | Opportunity decision date | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier of opporunity purchase line | ||
ITEM_ID | NUMBER | Item identifier associated with the opporunity purchase line (optional) | ||
ITEM_ORGANIZATION_ID | NUMBER | The identifier for the organization that item is defined in. | ||
TXN_CURRENCY | VARCHAR2 | (15) | Transaction currency | |
PRIM_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | Flag that indicates whether the opportunity was won or lost or not an opportunity | |
OPP_OPEN_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates whether the opportunity is open or closed | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Flag that indicates whether the sales credit amount is added to the pipeline for forecasting | |
WIN_PROBABILITY | NUMBER | Win probability for the opportunity | ||
SALES_CREDIT_AMOUNT | NUMBER | Sales credit amount | ||
LEAD_NUMBER | VARCHAR2 | (30) | Lead number is the user level identifier for an opportunity | |
LINE_ID | NUMBER | Lead line identifier | ||
CREDIT_ID | NUMBER | sales credit identifier | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency |
Cut, paste (and edit) the following text to query this object:
SELECT LEAD_ID
, SALES_GROUP_ID
, SALESREP_ID
, SNAP_DATE
, EFFECTIVE_DATE
, PRODUCT_CATEGORY_ID
, ITEM_ID
, ITEM_ORGANIZATION_ID
, TXN_CURRENCY
, PRIM_CONVERSION_RATE
, WIN_LOSS_INDICATOR
, OPP_OPEN_STATUS_FLAG
, FORECAST_ROLLUP_FLAG
, WIN_PROBABILITY
, SALES_CREDIT_AMOUNT
, LEAD_NUMBER
, LINE_ID
, CREDIT_ID
, CONVERSION_RATE_S
FROM BIL.BIL_BI_PIPELINE_STG;
BIL.BIL_BI_PIPELINE_STG does not reference any database object
BIL.BIL_BI_PIPELINE_STG is referenced by following:
|
|
|