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

VIEW: APPS.BIL_OBI_OPDTL_V

Object Details
Object Name: BIL_OBI_OPDTL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Detail view for sales opprtunity


[View Source]

Columns
Name Datatype Length Mandatory Comments
OPTY_NUMBER VARCHAR2 (30)
Opportunity Number
OPTY_ID NUMBER
Yes Opportunity ID
SALES_GROUP_ID NUMBER
Yes Sales group Id
SALESREP_ID NUMBER
Yes Sales rep id
PRODUCT_CATEGORY_ID NUMBER

Product category id
OPTY_CLOSE_TIME_ID NUMBER
Yes Opty close time id
OPTY_NAME VARCHAR2 (240)
Name of opportunity
CUSTOMER_ID NUMBER

Customer ID
CUST_NAME VARCHAR2 (360)
Name of the customer
SALES_CREDIT_AMT NUMBER

Sales credit amount in primary currency
SALES_CREDIT_AMT_S NUMBER

Sales credit amount in secondary currency
SALES_STAGE VARCHAR2 (60)
Stage for the opportunity
STATUS VARCHAR2 (240)
Status for opportunity
WIN_PROBABILITY NUMBER

Win probability
OPEN_STATUS_FLAG VARCHAR2 (1)
Open status flag for opportunity
WIN_LOSS_INDICATOR VARCHAR2 (1)
Win loss indicator for opportunity
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
Forecast rollup flag for opportunity
Query Text

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


SELECT OPTY_NUMBER
,      OPTY_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      OPTY_CLOSE_TIME_ID
,      OPTY_NAME
,      CUSTOMER_ID
,      CUST_NAME
,      SALES_CREDIT_AMT
,      SALES_CREDIT_AMT_S
,      SALES_STAGE
,      STATUS
,      WIN_PROBABILITY
,      OPEN_STATUS_FLAG
,      WIN_LOSS_INDICATOR
,      FORECAST_ROLLUP_FLAG
FROM APPS.BIL_OBI_OPDTL_V;

Dependencies

[top of page]

APPS.BIL_OBI_OPDTL_V references the following:

SchemaAPPS
SynonymAS_LEADS_ALL
ViewAS_SALES_STAGES_ALL_VL
ViewAS_STATUSES_VL
TableBIL_BI_OPDTL_MV
SynonymHZ_PARTIES

APPS.BIL_OBI_OPDTL_V is not referenced by any database object