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

Object Details

Object Name:	AMS_ACCT_INTEREST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_ACCT_INTEREST_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CUSTOMER_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(360)	Yes
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
ANNUAL_REVENUE	NUMBER
NUM_OF_EMPLOYEES	NUMBER
CUSTOMER_CATEGORY_CODE	VARCHAR2	(30)
FISCAL_YEAR_END	VARCHAR2	(12)
CUSTOMER_PROSPECT_CODE	VARCHAR2	(8)
CUSTOMER_ACTIVE	VARCHAR2	(8)
REFERENCE	VARCHAR2	(1)
COMPETITOR	VARCHAR2	(1)
PARTNER	VARCHAR2	(1)
OK_TO_MAIL	VARCHAR2	(1)
ADDRESS_ID	NUMBER	(15)	Yes
KEY_SITE	VARCHAR2	(1)
SITE_ACTIVE	VARCHAR2	(8)
CITY	VARCHAR2	(60)
STATE	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(60)
COUNTY	VARCHAR2	(60)
COUNTRY	VARCHAR2	(60)	Yes
COUNTRY_NAME	VARCHAR2	(80)	Yes
ORG_ID	NUMBER	(15)
ORG_NAME	VARCHAR2	(240)	Yes
SIT_LAST_UPDATED_BY	NUMBER	(15)	Yes
SIT_LAST_UPDATE_DATE	DATE		Yes
SIT_LAST_UPDATED_NAME	VARCHAR2	(4000)
CUS_LAST_UPDATED_BY	NUMBER	(15)	Yes
CUS_LAST_UPDATE_DATE	DATE		Yes
CUS_LAST_UPDATED_NAME	VARCHAR2	(4000)
SITE_INTEREST_TYPE	VARCHAR2	(80)
SITE_PRIMARY_INT_CODE	VARCHAR2	(181)
SITE_SECONDARY_INT_CODE	VARCHAR2	(282)
SITE_PRIMARY_CODE	VARCHAR2	(100)
SITE_SECONDARY_CODE	VARCHAR2	(100)

Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ANNUAL_REVENUE
,      NUM_OF_EMPLOYEES
,      CUSTOMER_CATEGORY_CODE
,      FISCAL_YEAR_END
,      CUSTOMER_PROSPECT_CODE
,      CUSTOMER_ACTIVE
,      REFERENCE
,      COMPETITOR
,      PARTNER
,      OK_TO_MAIL
,      ADDRESS_ID
,      KEY_SITE
,      SITE_ACTIVE
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTY
,      COUNTRY
,      COUNTRY_NAME
,      ORG_ID
,      ORG_NAME
,      SIT_LAST_UPDATED_BY
,      SIT_LAST_UPDATE_DATE
,      SIT_LAST_UPDATED_NAME
,      CUS_LAST_UPDATED_BY
,      CUS_LAST_UPDATE_DATE
,      CUS_LAST_UPDATED_NAME
,      SITE_INTEREST_TYPE
,      SITE_PRIMARY_INT_CODE
,      SITE_SECONDARY_INT_CODE
,      SITE_PRIMARY_CODE
,      SITE_SECONDARY_CODE
FROM APPS.AMS_ACCT_INTEREST_V;

Dependencies

[top of page]

APPS.AMS_ACCT_INTEREST_V references the following:

APPS: AS_INTERESTS_ALL; AS_INTEREST_CODES_VL; AS_INTEREST_TYPES_VL; FND_TERRITORIES_VL; FND_USER_AP_PKG - show dependent code; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.AMS_ACCT_INTEREST_V is not referenced by any database object