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_STG

Object Details

Object Name:	BIL_BI_OPDTL_STG
Object Type:	TABLE
Owner:	BIL
FND Design Data:	BIL.BIL_BI_OPDTL_STG
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_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIL_BI_OPDTL_STG_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	LEAD_ID LEAD_LINE_ID SALES_CREDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEAD_ID	NUMBER		Yes	Opportunity identifier
LEAD_LINE_ID	NUMBER			Opportunity purchase line identifier
SALES_CREDIT_ID	NUMBER			Sales credit identifier
TXN_DATE	DATE		Yes	Opportunity last update date
EFFECTIVE_DATE	DATE		Yes	Opportunity decision date
OPTY_CREATION_DATE	DATE			Opportunity creation date in julian format
OPTY_LD_CONVERSION_DATE	DATE			Date an opporunity is converted from a lead expressed in Julian format
VALID_FLAG	VARCHAR2	(1)		Indicates whether the row is valid
REV_FLAG	VARCHAR2	(1)		Reversal flag
TXN_CURRENCY	VARCHAR2	(15)		Transaction currency
PRIM_CONVERSION_RATE	NUMBER			Conversion rate from transaction currency to primary global currency
SALES_GROUP_ID	NUMBER		Yes	Sales group identifier
SALESREP_ID	NUMBER		Yes	Salesrep identifier
PRODUCT_CATEGORY_ID	NUMBER			Product category identifier of the opporunity line
INTEREST_TYPE_ID	NUMBER			Interest type identifier of the opportunity line
PRIMARY_INTEREST_CODE_ID	NUMBER			Primary interest code identifier for the opportunity line
SECONDARY_INTEREST_CODE_ID	NUMBER			Secondary interest code identifier for the opportunity line
ITEM_ID	NUMBER			Item id associated with the opporunity line (optional)
ITEM_ORGANIZATION_ID	NUMBER			The identifier for the organization that item is defined in
CUSTOMER_ID	NUMBER			Customer identifier of the opportunity.
HDR_SOURCE_PROMOTION_ID	NUMBER			Header makerting source promotion id
CAMPAIGN_OBJECT_ID	NUMBER			Campaign or Parent Campaign Object Identifier corresponding to opportunity header source promotion. It represents parent for campaign / event schedules source promotion.
CAMPAIGN_OBJECT_TYPE	VARCHAR2	(30)		Campaign or Parent Campaign Object Type corresponding to opportunity header source promotion. It represents parent for campaign / event schedules source promotion.
CHILD_CAMPAIGN_OBJECT_ID	NUMBER			Campaign Object Identifier corresponding to opportunity header source promotion for campaign / event schedules source promotion.
CHILD_CAMPAIGN_OBJECT_TYPE	VARCHAR2	(30)		Campaign Object Type corresponding to opportunity header source promotion for campaign / event schedules source promotion.
WIN_PROBABILITY	NUMBER			Win probability
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 forecast
LEAD_NUMBER	VARCHAR2	(30)		The opportunity number that user can use to search for an opportunity
OPTY_GLOBAL_AMT	NUMBER			Total opportunity amount. Same as opty_amt in bil_bi_opdtl_f
SALES_CREDIT_AMOUNT	NUMBER			Sales credit amount
DELETE_FLAG	VARCHAR2	(1)		Obsolete. Flag that indicates whether the sales credit was deleted
SECURITY_GROUP_ID	NUMBER			Obsolete. Standard who column
COMPETITOR_ID	NUMBER			Key competitor at the opportunity header level.
OWNER_SALES_GROUP_ID	NUMBER			The owner sales group id of the opportunity header.
OWNER_SALESREP_ID	NUMBER			Owner salesrep id of the opportunity header.
SALES_STAGE_ID	NUMBER			Identifier for the sales stage that the opportunity is in.
STATUS	VARCHAR2	(240)		Current status code of the opportunity.
CLOSE_DATE	DATE			Decision date or close date of an opportunity
OPTY_RANK	NUMBER			Rank of opportunity line by forecast date, used in opportunity count columns.
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
,      LEAD_LINE_ID
,      SALES_CREDIT_ID
,      TXN_DATE
,      EFFECTIVE_DATE
,      OPTY_CREATION_DATE
,      OPTY_LD_CONVERSION_DATE
,      VALID_FLAG
,      REV_FLAG
,      TXN_CURRENCY
,      PRIM_CONVERSION_RATE
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      INTEREST_TYPE_ID
,      PRIMARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE_ID
,      ITEM_ID
,      ITEM_ORGANIZATION_ID
,      CUSTOMER_ID
,      HDR_SOURCE_PROMOTION_ID
,      CAMPAIGN_OBJECT_ID
,      CAMPAIGN_OBJECT_TYPE
,      CHILD_CAMPAIGN_OBJECT_ID
,      CHILD_CAMPAIGN_OBJECT_TYPE
,      WIN_PROBABILITY
,      WIN_LOSS_INDICATOR
,      OPP_OPEN_STATUS_FLAG
,      FORECAST_ROLLUP_FLAG
,      LEAD_NUMBER
,      OPTY_GLOBAL_AMT
,      SALES_CREDIT_AMOUNT
,      DELETE_FLAG
,      SECURITY_GROUP_ID
,      COMPETITOR_ID
,      OWNER_SALES_GROUP_ID
,      OWNER_SALESREP_ID
,      SALES_STAGE_ID
,      STATUS
,      CLOSE_DATE
,      OPTY_RANK
,      CONVERSION_RATE_S
FROM BIL.BIL_BI_OPDTL_STG;

Dependencies

[top of page]

BIL.BIL_BI_OPDTL_STG does not reference any database object

BIL.BIL_BI_OPDTL_STG is referenced by following:

APPS: BIL_BI_OPDTL_STG