[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_DENLOG_STG |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_DENLOG_STG |
Subobject Name: | |
Status: | VALID |
Temporary staging table to be used by the pipeline base summary collection program
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_DENLOG_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEAD_LINE_ID | NUMBER | Lead line identifier | ||
SALES_CREDIT_ID | NUMBER | sales credit identifier | ||
SALESGROUP_ID | NUMBER | Sales group identifier | ||
SALESFORCE_ID | NUMBER | Salesrep identifier | ||
LEAD_ID | NUMBER | Lead identifier | ||
WIN_PROBABILITY | NUMBER | win probability | ||
CURRENCY_CODE | VARCHAR2 | (240) | Currency code | |
WIN_LOSS_INDICATOR | VARCHAR2 | (1) | win loss indicator | |
FORECAST_ROLLUP_FLAG | VARCHAR2 | (1) | Indicates whether opportunity is included in forecast | |
ITEM_ID | NUMBER | Item identifier | ||
ITEM_ORGANIZATION_ID | NUMBER | Organization identifier | ||
LEAD_NUMBER | VARCHAR2 | (30) | Lead Number | |
PRODUCT_CATEGORY_ID | NUMBER | Product category identifier | ||
OPEN_STATUS_FLAG | VARCHAR2 | (1) | Indicates whether opportunity is in open status | |
CREDIT_AMOUNT | NUMBER | credit amount | ||
LAST_UPDATE_DATE | DATE | Last update date | ||
DECISION_DATE | DATE | Decision date | ||
PRIM_CONVERSION_RATE | NUMBER | Conversion rate for primary currency | ||
CONVERSION_RATE_S | NUMBER | Conversion rate for secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT LEAD_LINE_ID
, SALES_CREDIT_ID
, SALESGROUP_ID
, SALESFORCE_ID
, LEAD_ID
, WIN_PROBABILITY
, CURRENCY_CODE
, WIN_LOSS_INDICATOR
, FORECAST_ROLLUP_FLAG
, ITEM_ID
, ITEM_ORGANIZATION_ID
, LEAD_NUMBER
, PRODUCT_CATEGORY_ID
, OPEN_STATUS_FLAG
, CREDIT_AMOUNT
, LAST_UPDATE_DATE
, DECISION_DATE
, PRIM_CONVERSION_RATE
, CONVERSION_RATE_S
FROM BIL.BIL_BI_DENLOG_STG;
BIL.BIL_BI_DENLOG_STG does not reference any database object
BIL.BIL_BI_DENLOG_STG is referenced by following:
|
|
|