eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BIL.BIL_BI_DENLOG_STG

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIL_BI_DENLOG_STG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

BIL.BIL_BI_DENLOG_STG does not reference any database object

BIL.BIL_BI_DENLOG_STG is referenced by following:

APPS: BIL_BI_DENLOG_STG