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

Object Details

Object Name:	ARBV_CUSTOMERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.ARBV_CUSTOMERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows customer information. A customer is any organization or individual who purchases goods or services.

[View Source]

Columns

Name	Datatype	Length	Mandatory
CUSTOMER_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(50)
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
ALTERNATE_NAME	VARCHAR2	(320)
_LA:ACTIVE_FLAG	CHAR	(44)
PROSPECT_FLAG	CHAR	(8)
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes
_LA:CUSTOMER_TYPE	CHAR	(53)
CUSTOMER_CLASS	VARCHAR2	(30)
_LA:CUSTOMER_CATEGORY	CHAR	(56)
TAX_CODE	VARCHAR2	(50)
SIC_CODE	VARCHAR2	(30)
TAXPAYER_ID	VARCHAR2	(20)
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
_LA:TAX_ROUNDING_RULE	CHAR	(64)
_LA:TAX_HEADER_LEVEL_FLAG	CHAR	(54)
_LA:GSA_INDICATOR	CHAR	(50)
_LA:SHIP_PARTIAL_FLAG	CHAR	(45)
FREIGHT_CARRIER	VARCHAR2	(30)
_LA:FOB_POINT	CHAR	(39)
_LA:FREIGHT_TERMS	CHAR	(52)
_LA:SALES_CHANNEL	CHAR	(55)
NUMBER_OF_EMPLOYEES	NUMBER
YEAR_ESTABLISHED	NUMBER
FISCAL_YEAR_END_MONTH	VARCHAR2	(30)
ANALYSIS_YEAR	VARCHAR2	(5)
CURRENT_YEAR_REVENUE	NUMBER
NEXT_YEAR_REVENUE	NUMBER
_LA:SALES_PARTNER_FLAG	CHAR	(46)
_LA:USE_AS_REFERENCE_FLAG	CHAR	(48)
_LA:COMPETITOR_FLAG	CHAR	(45)
MISSION_STATEMENT	VARCHAR2	(2000)
_LA:ACCOUNT_STATUS	CHAR	(55)
_LA:CREDIT_RATING	CHAR	(53)
PERCENT_COLLECTABLE	NUMBER
_LA:RISK_CODE	CHAR	(45)
_LA:CREDIT_CHECK_FLAG	CHAR	(48)
_LA:CREDIT_HOLD_FLAG	CHAR	(44)
STANDARD_TERMS	VARCHAR2	(0)
_LA:OVERRIDE_TERMS_FLAG	CHAR	(47)
_LA:ALLOW_DISCOUNT_FLAG	CHAR	(47)
DISCOUNT_GRACE_DAYS	NUMBER
RECEIPT_GRACE_DAYS	NUMBER
_LA:DISPUTED_ITEM_FLAG	CHAR	(60)
_LA:SEND_STATEMENT_FLAG	CHAR	(48)
_LA:SEND_CREDIT_BALANCE	CHAR	(58)
_LA:SEND_DUNNING_LETTER_FLAG	CHAR	(48)
_LA:CONSOLIDATED_BILL_FLAG	CHAR	(46)
_LA:CONSOLIDATED_BILL_FORMAT	CHAR	(52)
_LA:CHARGE_INTEREST_FLAG	CHAR	(49)
_LA:COMPOUND_INTEREST_FLAG	CHAR	(62)
INTEREST_PERIOD_DAYS	NUMBER
_LA:TAX_PRINTING_OPTION	CHAR	(65)
CLEARING_DAYS	NUMBER	(5)
_LA:LOCKBOX_MATCHING_OPTION	CHAR	(72)
CUSTOMER_WEB_SITE	VARCHAR2	(2000)
WAREHOUSE_ID	NUMBER	(15)
PRIMARY_SALESREP_ID	NUMBER	(15)
DUNNING_SITE_USE_ID	NUMBER
STATEMENT_SITE_USE_ID	NUMBER
ORDER_TYPE_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ALTERNATE_NAME
,      _LA:ACTIVE_FLAG
,      PROSPECT_FLAG
,      ORIGINAL_SYSTEM_REFERENCE
,      _LA:CUSTOMER_TYPE
,      CUSTOMER_CLASS
,      _LA:CUSTOMER_CATEGORY
,      TAX_CODE
,      SIC_CODE
,      TAXPAYER_ID
,      TAX_REGISTRATION_NUMBER
,      _LA:TAX_ROUNDING_RULE
,      _LA:TAX_HEADER_LEVEL_FLAG
,      _LA:GSA_INDICATOR
,      _LA:SHIP_PARTIAL_FLAG
,      FREIGHT_CARRIER
,      _LA:FOB_POINT
,      _LA:FREIGHT_TERMS
,      _LA:SALES_CHANNEL
,      NUMBER_OF_EMPLOYEES
,      YEAR_ESTABLISHED
,      FISCAL_YEAR_END_MONTH
,      ANALYSIS_YEAR
,      CURRENT_YEAR_REVENUE
,      NEXT_YEAR_REVENUE
,      _LA:SALES_PARTNER_FLAG
,      _LA:USE_AS_REFERENCE_FLAG
,      _LA:COMPETITOR_FLAG
,      MISSION_STATEMENT
,      _LA:ACCOUNT_STATUS
,      _LA:CREDIT_RATING
,      PERCENT_COLLECTABLE
,      _LA:RISK_CODE
,      _LA:CREDIT_CHECK_FLAG
,      _LA:CREDIT_HOLD_FLAG
,      STANDARD_TERMS
,      _LA:OVERRIDE_TERMS_FLAG
,      _LA:ALLOW_DISCOUNT_FLAG
,      DISCOUNT_GRACE_DAYS
,      RECEIPT_GRACE_DAYS
,      _LA:DISPUTED_ITEM_FLAG
,      _LA:SEND_STATEMENT_FLAG
,      _LA:SEND_CREDIT_BALANCE
,      _LA:SEND_DUNNING_LETTER_FLAG
,      _LA:CONSOLIDATED_BILL_FLAG
,      _LA:CONSOLIDATED_BILL_FORMAT
,      _LA:CHARGE_INTEREST_FLAG
,      _LA:COMPOUND_INTEREST_FLAG
,      INTEREST_PERIOD_DAYS
,      _LA:TAX_PRINTING_OPTION
,      CLEARING_DAYS
,      _LA:LOCKBOX_MATCHING_OPTION
,      CUSTOMER_WEB_SITE
,      WAREHOUSE_ID
,      PRIMARY_SALESREP_ID
,      DUNNING_SITE_USE_ID
,      STATEMENT_SITE_USE_ID
,      ORDER_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.ARBV_CUSTOMERS;

Dependencies

[top of page]

APPS.ARBV_CUSTOMERS references the following:

APPS: HZ_CUSTOMER_PROFILES; HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.ARBV_CUSTOMERS is not referenced by any database object