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

VIEW: APPS.AS_TAP_OPPORTUNITIES_V

Object Details
Object Name: AS_TAP_OPPORTUNITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_TAP_OPPORTUNITIES_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 Lead identifier
SQUAL_NUM02 NUMBER

Transaction Detail Object Id. Foreign key to JTF_TAE_1001_ACCOUNT
SQUAL_NUM04 NUMBER
Yes Transaction Object Id. Foreign key to JTF_TAE_1001_ACCOUNT
SQUAL_CHAR08 VARCHAR2 (360)
squal_char08 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR09 VARCHAR2 (360)
squal_char09 from JTF_TAE_1001_ACCOUNT
SQUAL_CURC01 VARCHAR2 (30)
squal_curc01 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR02 VARCHAR2 (360)
squal_char02 from JTF_TAE_1001_ACCOUNT
SQUAL_NUM06 NUMBER

squal_num06 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR07 VARCHAR2 (360)
squal_char07 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR03 VARCHAR2 (360)
squal_char03 from JTF_TAE_1001_ACCOUNT
SQUAL_NUM01 NUMBER

squal_num01 from JTF_TAE_1001_ACCOUNT
SQUAL_FC01 VARCHAR2 (3)
squal_fc01 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR01 VARCHAR2 (360)
squal_char01 from JTF_TAE_1001_ACCOUNT
SQUAL_NUM05 NUMBER

squal_num05 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR06 VARCHAR2 (360)
squal_char06 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR05 VARCHAR2 (360)
squal_char05 from JTF_TAE_1001_ACCOUNT
SQUAL_NUM03 NUMBER

squal_num03 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR10 VARCHAR2 (360)
squal_char10 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR04 VARCHAR2 (360)
squal_char04 from JTF_TAE_1001_ACCOUNT
SQUAL_CHAR40 VARCHAR2 (30)
Lead Channel Code
SQUAL_NUM40 NUMBER

Lead Promotion identifier
SQUAL_CHAR41 VARCHAR2 (30)
Lead status
SQUAL_NUM41 NUMBER

Total Lead amount
SQUAL_CURC07 VARCHAR2 (15)
Lead currency code
SQUAL_CHAR11 VARCHAR2 (360)
squal_char11 from JTF_TAE_1001_ACCOUNT
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
Lead Open Status indicator
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_CHAR40
,      SQUAL_NUM40
,      SQUAL_CHAR41
,      SQUAL_NUM41
,      SQUAL_CURC07
,      SQUAL_CHAR11
,      OPP_OPEN_STATUS_FLAG
FROM APPS.AS_TAP_OPPORTUNITIES_V;

Dependencies

[top of page]

APPS.AS_TAP_OPPORTUNITIES_V references the following:

SchemaAPPS
SynonymAS_LEADS_ALL
SynonymAS_STATUSES_B
SynonymJTF_TAE_1001_ACCOUNT_TRANS

APPS.AS_TAP_OPPORTUNITIES_V is not referenced by any database object