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

Object Details

Object Name:	ARFV_CUSTOMERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.ARFV_CUSTOMERS
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	Mandatory
CUSTOMER_ID	NUMBER	(15)	Yes
CUSTOMER_NAME	VARCHAR2	(360)	Yes
CUSTOMER_NUMBER	VARCHAR2	(30)	Yes
ALTERNATE_NAME	VARCHAR2	(320)
_LA:ACTIVE_FLAG	CHAR	(51)
_LA:PROSPECT_FLAG	CHAR	(131)
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes
_LA:CUSTOMER_TYPE	CHAR	(60)
CUSTOMER_CLASS	VARCHAR2	(30)
_LA:CUSTOMER_CATEGORY	CHAR	(60)
TAX_CODE	VARCHAR2	(50)
SIC_CODE	VARCHAR2	(30)
TAXPAYER_ID	VARCHAR2	(20)
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
_LA:TAX_ROUNDING_RULE	CHAR	(71)
_LA:TAX_HEADER_LEVEL_FLAG	CHAR	(61)
_LA:GSA_INDICATOR	CHAR	(107)
_LA:SHIP_PARTIAL_FLAG	CHAR	(52)
FREIGHT_CARRIER	VARCHAR2	(30)
_LA:FOB_POINT	CHAR	(46)
PRICE_LIST	VARCHAR2	(240)
_LA:FREIGHT_TERMS	CHAR	(59)
_LA:SALES_CHANNEL	CHAR	(65)
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	(15)
_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)
STATEMENT_CYCLE	VARCHAR2	(15)
_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)
INVOICE_LINE_GROUPING_RULE	VARCHAR2	(40)
CLEARING_DAYS	NUMBER	(5)
AUTOCASH_RULE_SET	VARCHAR2	(30)
_LA:LOCKBOX_MATCHING_OPTION	CHAR	(72)
REMAINDER_RULE_SET	VARCHAR2	(30)
CUSTOMER_WEB_SITE	VARCHAR2	(2000)
WAREHOUSE	VARCHAR2	(240)
SALESPERSON	VARCHAR2	(360)
DUNNING_SITE	VARCHAR2	(0)
STATEMENT_SITE	VARCHAR2	(0)
ORDER_TYPE	VARCHAR2	(30)
_DF:CUST	CHAR	(32)
_DF:CUST_PROFILE	CHAR	(30)
_DF:GLOBAL_FLEX	CHAR	(33)
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
,      _LA: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
,      PRICE_LIST
,      _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
,      STATEMENT_CYCLE
,      _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
,      INVOICE_LINE_GROUPING_RULE
,      CLEARING_DAYS
,      AUTOCASH_RULE_SET
,      _LA:LOCKBOX_MATCHING_OPTION
,      REMAINDER_RULE_SET
,      CUSTOMER_WEB_SITE
,      WAREHOUSE
,      SALESPERSON
,      DUNNING_SITE
,      STATEMENT_SITE
,      ORDER_TYPE
,      _DF:CUST
,      _DF:CUST_PROFILE
,      _DF:GLOBAL_FLEX
,      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.ARFV_CUSTOMERS;

Dependencies

[top of page]

APPS.ARFV_CUSTOMERS references the following:

APPS: AR_AUTOCASH_HIERARCHIES; AR_STATEMENT_CYCLES; HR_ALL_ORGANIZATION_UNITS; HZ_CUSTOMER_PROFILES; HZ_CUST_ACCOUNTS; HZ_PARTIES; QP_PRICE_LIST_PVT - show dependent code; RA_GROUPING_RULES; RA_SALESREPS; RA_TERMS; SO_ORDER_TYPES; SO_PRICE_LISTS

APPS.ARFV_CUSTOMERS is not referenced by any database object