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_OPDTL_F

Object Details

Object Name:	BIL_BI_OPDTL_F
Object Type:	TABLE
Owner:	BIL
FND Design Data:	BIL.BIL_BI_OPDTL_F
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIL_BI_OPDTL_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	SALES_CREDIT_ID
BIL_BI_OPDTL_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ITEM_ID ITEM_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OPTY_ID	NUMBER		Yes	Identifier for the opportunity
TXN_TIME_ID	NUMBER		Yes	Last update date of the transaction expressed in Julian format
OPTY_CREATION_TIME_ID	NUMBER			Opportunity creation date expressed in Julian format
OPTY_CLOSE_TIME_ID	NUMBER		Yes	Opportunity line forecast date for open & won status, close date for other statuses
OPTY_LD_CONVERSION_TIME_ID	NUMBER			Date when opportunity is converted from a lead expressed in Julian format.
SALES_GROUP_ID	NUMBER		Yes	Sales group who gets the sales credit
SALESREP_ID	NUMBER		Yes	Salesperson who gets sales credit
PRODUCT_CATEGORY_ID	NUMBER		Yes	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.
CUSTOMER_ID	NUMBER			Customer identifier of the opportunity.
CAMPAIGN_OBJECT_ID	NUMBER			Obsolete
CAMPAIGN_OBJECT_TYPE	VARCHAR2	(30)		Obsolete
CHILD_CAMPAIGN_OBJECT_ID	NUMBER			Obsolete
CHILD_CAMPAIGN_OBJECT_TYPE	VARCHAR2	(30)		Obsolete
WIN_PROBABILITY	NUMBER			Win probability for the opportunity
WIN_LOSS_INDICATOR	VARCHAR2	(1)		Flag that indicates whether the opportunity was won or lost or not an opportunity
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
REV_FLAG	VARCHAR2	(1)		Obsolete column. Do not use.
SALES_CREDIT_AMT	NUMBER			Sales credit amount in primary global currency
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update record
PROGRAM_ID	NUMBER			Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE	DATE			Last date concurrent program updated record
SECURITY_GROUP_ID	NUMBER			Obsolete. Standard who column
TXN_DATE	DATE			Obsolete column, do not use. Transaction date -last update date of the opportunity
EFFECTIVE_DATE	DATE			Obsolete column. Do not use. Decision date for the opportunity
WON_AMT	NUMBER			Obsolete column. Do not use. Won amount
LOST_AMT	NUMBER			Obsolete column. Do not use. Lost amount
NO_OPTY_AMT	NUMBER			Obsolete column. Do not use. No opportunity amount
PIPELINE_AMT	NUMBER			Obsolete column. Do not use. Pipeline amount
WTD_PIPELINE_PB1	NUMBER			Obsolete column. Do not use. Pipeline with win probability between 0 and 25 percent
WTD_PIPELINE_PB2	NUMBER			Obsolete column. Do not use. Pipeline with win probability between 26 and 50 percent
WTD_PIPELINE_PB3	NUMBER			Obsolete column. Do not use. Pipeline with win probability between 51 and 75 percent
WTD_PIPELINE_PB4	NUMBER			Obsolete column. Do not use. Pipeline with win probability between 76 and 99 percent
WTD_PIPELINE_PB5	NUMBER			Obsolete column. Do not use. Pipeline with win probability 100 percent
COMPETITOR_ID	NUMBER			Key competitor at the opportunity header level.
HDR_SOURCE_PROMOTION_ID	NUMBER			Header marketing source promotion identifier
OWNER_SALES_GROUP_ID	NUMBER			The owner sales group id of the opportunity header.
OWNER_SALESREP_ID	NUMBER			Ownere sales rep id of the opportunity header.
OPTY_AMT	NUMBER			Total opportunity amount in primary global currency (from the header).
SALES_STAGE_ID	NUMBER			Identifier for the sales stage that the opportunity is in.
LEAD_NUMBER	VARCHAR2	(30)		Lead number is the user level identifier for an opportunity
STATUS	VARCHAR2	(30)		Current status code of the opportunity.
LEAD_LINE_ID	NUMBER			Lead line identifier
SALES_CREDIT_ID	NUMBER			Sales credit identifier
OPTY_EFFECTIVE_TIME_ID	NUMBER			Close time is of an opportunity
OPTY_RANK	NUMBER			Rank of opportunity line by forecast date, used in opportunity count columns.
SALES_CREDIT_AMT_S	NUMBER			Sales Credit Amount In Secondary Global Currency
OPTY_AMT_S	NUMBER			Total opportunity amount in secondary global currency (from the header).

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OPTY_ID
,      TXN_TIME_ID
,      OPTY_CREATION_TIME_ID
,      OPTY_CLOSE_TIME_ID
,      OPTY_LD_CONVERSION_TIME_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      ITEM_ID
,      ITEM_ORGANIZATION_ID
,      CUSTOMER_ID
,      CAMPAIGN_OBJECT_ID
,      CAMPAIGN_OBJECT_TYPE
,      CHILD_CAMPAIGN_OBJECT_ID
,      CHILD_CAMPAIGN_OBJECT_TYPE
,      WIN_PROBABILITY
,      WIN_LOSS_INDICATOR
,      OPEN_STATUS_FLAG
,      FORECAST_ROLLUP_FLAG
,      REV_FLAG
,      SALES_CREDIT_AMT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SECURITY_GROUP_ID
,      TXN_DATE
,      EFFECTIVE_DATE
,      WON_AMT
,      LOST_AMT
,      NO_OPTY_AMT
,      PIPELINE_AMT
,      WTD_PIPELINE_PB1
,      WTD_PIPELINE_PB2
,      WTD_PIPELINE_PB3
,      WTD_PIPELINE_PB4
,      WTD_PIPELINE_PB5
,      COMPETITOR_ID
,      HDR_SOURCE_PROMOTION_ID
,      OWNER_SALES_GROUP_ID
,      OWNER_SALESREP_ID
,      OPTY_AMT
,      SALES_STAGE_ID
,      LEAD_NUMBER
,      STATUS
,      LEAD_LINE_ID
,      SALES_CREDIT_ID
,      OPTY_EFFECTIVE_TIME_ID
,      OPTY_RANK
,      SALES_CREDIT_AMT_S
,      OPTY_AMT_S
FROM BIL.BIL_BI_OPDTL_F;

Dependencies

[top of page]

BIL.BIL_BI_OPDTL_F does not reference any database object

BIL.BIL_BI_OPDTL_F is referenced by following:

APPS: BIL_BI_OPDTL_F; BIL_BI_OPDTL_MV; ENI_DBI_TOO_MV