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

VIEW: APPS.AS_TAP_LEADS_V

Object Details
Object Name: AS_TAP_LEADS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_TAP_LEADS_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANS_OBJECT_ID NUMBER
Yes Sales Lead Identifier
SQUAL_NUM02 NUMBER

SQUAL_NUM04 NUMBER
Yes
SQUAL_CHAR08 VARCHAR2 (360)
SQUAL_CHAR09 VARCHAR2 (360)
SQUAL_CURC01 VARCHAR2 (30)
SQUAL_CHAR02 VARCHAR2 (360)
SQUAL_NUM06 NUMBER

SQUAL_CHAR07 VARCHAR2 (360)
SQUAL_CHAR03 VARCHAR2 (360)
SQUAL_NUM01 NUMBER

SQUAL_FC01 VARCHAR2 (3)
SQUAL_CHAR01 VARCHAR2 (360)
SQUAL_NUM05 NUMBER

SQUAL_CHAR06 VARCHAR2 (360)
SQUAL_CHAR05 VARCHAR2 (360)
SQUAL_NUM03 NUMBER

SQUAL_CHAR10 VARCHAR2 (360)
SQUAL_CHAR04 VARCHAR2 (360)
SQUAL_NUM30 NUMBER

SQUAL_NUM31 NUMBER

SQUAL_CURC03 VARCHAR2 (15)
SQUAL_CHAR11 VARCHAR2 (360)
SQUAL_CHAR30 VARCHAR2 (30)
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
Query Text

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


SELECT TRANS_OBJECT_ID
,      SQUAL_NUM02
,      SQUAL_NUM04
,      SQUAL_CHAR08
,      SQUAL_CHAR09
,      SQUAL_CURC01
,      SQUAL_CHAR02
,      SQUAL_NUM06
,      SQUAL_CHAR07
,      SQUAL_CHAR03
,      SQUAL_NUM01
,      SQUAL_FC01
,      SQUAL_CHAR01
,      SQUAL_NUM05
,      SQUAL_CHAR06
,      SQUAL_CHAR05
,      SQUAL_NUM03
,      SQUAL_CHAR10
,      SQUAL_CHAR04
,      SQUAL_NUM30
,      SQUAL_NUM31
,      SQUAL_CURC03
,      SQUAL_CHAR11
,      SQUAL_CHAR30
,      OPP_OPEN_STATUS_FLAG
FROM APPS.AS_TAP_LEADS_V;

Dependencies

[top of page]

APPS.AS_TAP_LEADS_V references the following:

SchemaAPPS
SynonymAS_SALES_LEADS
SynonymAS_STATUSES_B
SynonymJTF_TAE_1001_ACCOUNT_TRANS

APPS.AS_TAP_LEADS_V is not referenced by any database object