[Home] [Help] [Dependency Information]
Object Name: | AS_TAP_LEADS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_TAP_LEADS_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 | 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) |
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;
APPS.AS_TAP_LEADS_V is not referenced by any database object
|
|
|