[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