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


VIEW: APPS.BIL_DIMV_OPTY

Object Details
Object Name: BIL_DIMV_OPTY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_OPTY
Subobject Name:
Status: VALID

View Type

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


BIL_DIMV_OPTY - Dimension view used to provide access to opportunity names.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEAD_ID NUMBER

Lead Id
LEAD_NUMBER VARCHAR2 (80)
Lead number
STATUS VARCHAR2 (30)
Lead status
DESCRIPTION VARCHAR2 (240)
Opportunity Description
Query Text

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


SELECT LEAD_ID
,      LEAD_NUMBER
,      STATUS
,      DESCRIPTION
FROM APPS.BIL_DIMV_OPTY;

Dependencies

[top of page]

APPS.BIL_DIMV_OPTY references the following:

SchemaAPPS
SynonymAS_LEADS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_OPTY is not referenced by any database object