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_PIPELINE_STG

Object Details

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

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

BIL.BIL_BI_PIPELINE_STG does not reference any database object

BIL.BIL_BI_PIPELINE_STG is referenced by following:

APPS: BIL_BI_PIPELINE_STG