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]

VIEW: APPS.AST_OPPORTUNITY_BRIEF_V

Object Details

Object Name:	AST_OPPORTUNITY_BRIEF_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEAD_ROWID	ROWID	(10)
LEAD_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
LEAD_NUMBER	VARCHAR2	(30)	Yes
STATUS	VARCHAR2	(30)	Yes
CUSTOMER_ID	NUMBER		Yes
TOTAL_AMOUNT	NUMBER
DESCRIPTION	VARCHAR2	(240)
PARTY_NAME	VARCHAR2	(360)	Yes

Query Text

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


SELECT LEAD_ROWID
,      LEAD_ID
,      CREATION_DATE
,      LEAD_NUMBER
,      STATUS
,      CUSTOMER_ID
,      TOTAL_AMOUNT
,      DESCRIPTION
,      PARTY_NAME
FROM APPS.AST_OPPORTUNITY_BRIEF_V;

Dependencies

[top of page]

APPS.AST_OPPORTUNITY_BRIEF_V references the following:

APPS: AS_LEADS_ALL; HZ_PARTIES

APPS.AST_OPPORTUNITY_BRIEF_V is not referenced by any database object