[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_OPDTL_F |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_OPDTL_F |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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). |
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;
BIL.BIL_BI_OPDTL_F does not reference any database object
BIL.BIL_BI_OPDTL_F is referenced by following:
|
|
|