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.AS_TAP_ACCOUNTS_V

Object Details

Object Name:	AS_TAP_ACCOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AS.AS_TAP_ACCOUNTS_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	Comments
TRANS_OBJECT_ID	NUMBER		Identifier for the party. Foreign key to the HZ_PARTIES table.
TRANS_DETAIL_OBJECT_ID	NUMBER	(15)	Party site identifier
SQUAL_NUM02	NUMBER	(15)	Party site identifier
SQUAL_NUM04	NUMBER		Identifier for the party. Foreign key to the HZ_PARTIES table.
SQUAL_CHAR08	VARCHAR2	(10)	phone_area_code from HZ_CONTACT_POINTS
SQUAL_CHAR09	VARCHAR2	(30)	Party Category code. Foreign key to the HZ_PARTIES table
SQUAL_CURC01	VARCHAR2	(30)	Preferred functional currency. Foreign key to HZ_ORGANIZATION_PROFILES
SQUAL_CHAR02	VARCHAR2	(60)	Location City. Forieng key to HZ_LOCATIONS
SQUAL_NUM06	NUMBER		Potential Revenue. Foreign key to HZ_ORGANIZATION_PROFILES
SQUAL_CHAR07	VARCHAR2	(60)	Location Country from HZ_LOCATIONS
SQUAL_CHAR03	VARCHAR2	(60)	Location County from HZ_LOCATIONS
SQUAL_NUM01	NUMBER		Identifier for the party. Foreign key to the HZ_PARTIES table
SQUAL_FC01	VARCHAR2	(1)	First Char of Party Name
SQUAL_CHAR01	VARCHAR2	(360)	Party Name from HZ_PARTIES
SQUAL_NUM05	NUMBER		Total employees from HZ_PARTIES
SQUAL_CHAR06	VARCHAR2	(60)	Postal code from HZ_PARTIES
SQUAL_CHAR05	VARCHAR2	(60)	Province from HZ_PARTIES
SQUAL_NUM03	NUMBER		Identifier for the party. Foreign key to the HZ_PARTIES
SQUAL_CHAR10	VARCHAR2	(62)	SIC Code Type:Sic Code from HZ_PARTIES
SQUAL_CHAR04	VARCHAR2	(60)	State from HZ_PARTIES
SQUAL_CHAR11	VARCHAR2	(30)	DUNS number from HZ_PARTIES

Query Text

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


SELECT TRANS_OBJECT_ID
,      TRANS_DETAIL_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_CHAR11
FROM APPS.AS_TAP_ACCOUNTS_V;

Dependencies

[top of page]

APPS.AS_TAP_ACCOUNTS_V references the following:

APPS: HZ_CONTACT_POINTS; HZ_LOCATIONS; HZ_ORGANIZATION_PROFILES; HZ_PARTIES; HZ_PARTY_SITES

APPS.AS_TAP_ACCOUNTS_V is not referenced by any database object