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

Object Details

Object Name:	OKX_CUSTOMER_ACCOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_CUSTOMER_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	Mandatory	Comments
ID1	NUMBER	(15)	Yes	Customer Account Identifier.
ID2	CHAR	(1)		(Multi-part) Primary Key
PARTY_ID	NUMBER	(15)	Yes	A foreign key to the HZ_PARTY table.
NAME	VARCHAR2	(360)		A user defined name for the account.
DESCRIPTION	VARCHAR2	(30)	Yes	Account Number
CUSTOMER_TYPE	VARCHAR2	(30)		Receivables lookup code for ?CUSTOMER_TYPE? (?I? for internal customers; ?R? for external customers)
B_STATUS	VARCHAR2	(1)	Yes	Customer status flag. Lookup code for CODE_STATUS
STATUS	VARCHAR2	(1)	Yes	Status
COTERMINATE_DAY_MONTH	VARCHAR2	(6)		Identifies the date on which services ordered by the customer will end. Values for this column will take the form DD-MON.
ACCOUNT_ESTABLISHED_DATE	DATE			Date when Account is established
CUSTOMER_CLASS_CODE	VARCHAR2	(30)		Customer class indentifier
PRIMARY_UOM_CODE	VARCHAR2	(0)		Used for lines entry, list for UOM.
SALES_CHANNEL_CODE	VARCHAR2	(30)
GSA_INDICATOR	VARCHAR2	(1)
EMAIL_ADDRESS	VARCHAR2	(2000)

Query Text

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


SELECT ID1
,      ID2
,      PARTY_ID
,      NAME
,      DESCRIPTION
,      CUSTOMER_TYPE
,      B_STATUS
,      STATUS
,      COTERMINATE_DAY_MONTH
,      ACCOUNT_ESTABLISHED_DATE
,      CUSTOMER_CLASS_CODE
,      PRIMARY_UOM_CODE
,      SALES_CHANNEL_CODE
,      GSA_INDICATOR
,      EMAIL_ADDRESS
FROM APPS.OKX_CUSTOMER_ACCOUNTS_V;

Dependencies

[top of page]

APPS.OKX_CUSTOMER_ACCOUNTS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_PARTIES

APPS.OKX_CUSTOMER_ACCOUNTS_V is referenced by following:

APPS: OKC_PRICE_PUB - show dependent code; OKE_VERSION_COMPARISON_PKG - show dependent code; OKL_AM_INVOICES_PVT - show dependent code; OKL_BPD_ADV_MON_RPT_PVT - show dependent code; OKL_BPD_ALL_CONTRACT_CUST_UV; OKL_BPD_CNTR_LVLNG_LOV_UV; OKL_BPD_CONTRACT_CUSTOMER_UV; OKL_BPD_MANUAL_TRX_UV; OKL_CONTRACT_PVT - show dependent code; OKL_CREDITLINES_UV; OKL_CREDIT_PUB - show dependent code; OKL_CREDIT_PUB - show dependent code; OKL_CS_SERVICE_ASSETS_UV; OKL_CURE_RECON_PVT - show dependent code; OKL_CUSTOMER_ACCT_UV; OKL_DEAL_CREATE_PUB - show dependent code; OKL_DEAL_CREAT_PVT - show dependent code; OKL_LA_VALIDATION_UTIL_PVT - show dependent code; OKL_LCKBX_CSH_APP_PVT - show dependent code; OKL_OPEN_INTERFACE_PVT - show dependent code; OKL_PAY_CURE_REFUNDS_PVT - show dependent code; OKL_QA_DATA_INTEGRITY - show dependent code; OKL_RCA_PVT - show dependent code; OKL_RCT_PVT - show dependent code; OKL_SUBSIDY_PROCESS_PVT - show dependent code; OKL_TAS_PVT - show dependent code; OKS_ARFEEDER_PUB - show dependent code; OKS_ATTR_DEFAULTS_PVT - show dependent code; OKS_AUTH_UTIL_PVT - show dependent code; OKS_AUTH_UTIL_PVT - show dependent code; OKS_BILLING_PROFILES_PVT - show dependent code; OKS_BILLPRST_SRVSUBLINE_V; OKS_BILL_UTIL_PUB - show dependent code; OKS_BPE_PVT - show dependent code; OKS_ENTITLEMENTS_PVT - show dependent code; OKS_ENTITLEMENTS_WEB - show dependent code; OKS_ENT_UTIL_PVT - show dependent code; OKS_EXTWARPRGM_PVT - show dependent code; OKS_IBINT_PUB - show dependent code; OKS_IB_UTIL_PVT - show dependent code; OKS_LINES_V; OKS_LINE_DETAILS_V; OKS_OMINT_PUB - show dependent code; OKS_PROD_DETAILS_V; OKS_QA_DATA_INTEGRITY - show dependent code