[Home] [Help] [Dependency Information]
Object Name: | AS_TAP_OPPORTUNITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_TAP_OPPORTUNITIES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.AS_TAP_OPPORTUNITIES_V is not referenced by any database object
|
|
|