[Home] [Help]
[Dependency Information]
VIEW: APPS.OKX_CUST_SITE_USES_V
Object Details
Object Name: | OKX_CUST_SITE_USES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_CUST_SITE_USES_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 |
Site use identifier |
ID2 |
CHAR |
(1) |
|
(Multi-part) Primary Key |
CUST_ACCT_SITE_ID |
NUMBER |
(15) |
Yes |
Customer Site identifier |
CUST_ACCOUNT_ID |
NUMBER |
(15) |
Yes |
Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL |
PARTY_SITE_ID |
NUMBER |
(15) |
Yes |
Party Site identifier. FK to HZ_PARTY_SITES |
PARTY_ID |
NUMBER |
(15) |
Yes |
Party identifier and foreign key to HZ_PARTIES. |
PARTY_SITE_NAME |
VARCHAR2 |
(240) |
|
A user defined name for the site |
SITE_USE_CODE |
VARCHAR2 |
(30) |
Yes |
Business Purpose |
B_STATUS |
VARCHAR2 |
(1) |
Yes |
Site use status flag; lookup code for 'CODE_STATUS' |
STATUS |
VARCHAR2 |
(1) |
Yes |
Status |
CUST_ACCT_SITE_STATUS |
VARCHAR2 |
(1) |
Yes |
Customer Status flag. Receivables lookup code for CODE_STATUS |
LOCATION_ID |
NUMBER |
(15) |
Yes |
Location Identifier |
NAME |
VARCHAR2 |
(40) |
Yes |
Site use identifier |
COUNTRY |
VARCHAR2 |
(60) |
Yes |
FND_TERRITORY.TERRITORY_CODE |
ADDRESS1 |
VARCHAR2 |
(240) |
Yes |
First line for address |
ADDRESS2 |
VARCHAR2 |
(240) |
|
Second line for address |
ADDRESS3 |
VARCHAR2 |
(240) |
|
Third line for address |
ADDRESS4 |
VARCHAR2 |
(240) |
|
Fourth line for address |
CITY |
VARCHAR2 |
(60) |
|
City |
POSTAL_CODE |
VARCHAR2 |
(60) |
|
Postal code |
STATE |
VARCHAR2 |
(60) |
|
State |
PROVINCE |
VARCHAR2 |
(60) |
|
Province |
COUNTY |
VARCHAR2 |
(60) |
|
County |
LOCATION_DESCRIPTION |
VARCHAR2 |
(2000) |
|
An extensive description of the location |
IDENTIFYING_ADDRESS_FLAG |
VARCHAR2 |
(1) |
Yes |
|
DESCRIPTION |
VARCHAR2 |
(4000) |
|
Formatted address, country specific |
ORG_ID |
NUMBER |
(15) |
|
Operating Unit Identifier |
PRIMARY_UOM_CODE |
VARCHAR2 |
(0) |
|
Used for lines entry, list for UOM. |
PAYMENT_TERM_ID |
NUMBER |
(15) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ID
, PARTY_SITE_ID
, PARTY_ID
, PARTY_SITE_NAME
, SITE_USE_CODE
, B_STATUS
, STATUS
, CUST_ACCT_SITE_STATUS
, LOCATION_ID
, NAME
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, LOCATION_DESCRIPTION
, IDENTIFYING_ADDRESS_FLAG
, DESCRIPTION
, ORG_ID
, PRIMARY_UOM_CODE
, PAYMENT_TERM_ID
FROM APPS.OKX_CUST_SITE_USES_V;
Dependencies
[top of page]
APPS.OKX_CUST_SITE_USES_V references the following:
-
APPS
-
ARP_ADDR_LABEL_PKG
- show dependent code
-
HZ_CUST_ACCT_SITES_ALL
-
HZ_CUST_SITE_USES
-
HZ_LOCATIONS
-
HZ_PARTY_SITES
APPS.OKX_CUST_SITE_USES_V is referenced by following:
-
APPS
-
OKC_HZ_MERGE_PUB
- show dependent code
-
OKC_OC_INT_KTQ_PVT
- show dependent code
-
OKC_OPPORTUNITY_PVT
- show dependent code
-
OKC_PRICE_PUB
- show dependent code
-
OKL_ACTIVATE_CONTRACT_PUB
- show dependent code
-
OKL_AM_INVOICES_PVT
- show dependent code
-
OKL_AM_QA_DATA_INTEGRITY_PVT
- show dependent code
-
OKL_AM_UTIL_PVT
- show dependent code
-
OKL_AM_UTIL_PVT
- show dependent code
-
OKL_ARINTF_PVT
- show dependent code
-
OKL_BILL_UPFRONT_TAX_PVT
- show dependent code
-
OKL_BPD_ALL_CONTRACT_CUST_UV
-
OKL_BPD_AR_INVOICES_V
-
OKL_BPD_CNTR_INVOICE_HDR_BC_V
-
OKL_BPD_CNTR_LVLNG_LOV_UV
-
OKL_BPD_CONS_INV_CUST_UV
-
OKL_BPD_CONTRACT_CUSTOMER_UV
-
OKL_BPD_CUST_LIST_UV
-
OKL_BPD_INVEST_INV_LOV_UV
-
OKL_BPD_INVEST_TRX_SUM_LN_UV
-
OKL_BPD_INVEST_TRX_SUM_UV
-
OKL_BPD_INVOICE_HDR_BC_V
-
OKL_BPD_MANUAL_TRX_UV
-
OKL_CREDITLINES_UV
-
OKL_CREDIT_MEMO_PVT
- show dependent code
-
OKL_CS_SERVICE_ASSETS_UV
-
OKL_CS_TRANSFER_ASSUMPTION_PVT
- show dependent code
-
OKL_CS_WF
- show dependent code
-
OKL_CS_WF
- show dependent code
-
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_INTERNAL_BILLING_PVT
- show dependent code
-
OKL_INTERNAL_TO_EXTERNAL
- show dependent code
-
OKL_INVESTOR_BILLING_PVT
- show dependent code
-
OKL_LA_BILL_TO_UV
-
OKL_OPEN_INTERFACE_PVT
- show dependent code
-
OKL_PAY_CURE_REFUNDS_PVT
- show dependent code
-
OKL_RELEASE_PVT
- show dependent code
-
OKL_REPORT_PVT
- show dependent code
-
OKL_SEC_INVESTORS_UV
-
OKL_SID_PVT
- show dependent code
-
OKL_SSC_WF
- show dependent code
-
OKL_STREAM_BILLING_PVT
- show dependent code
-
OKL_SUBSIDY_PROCESS_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_BILLING_PROFILES_PVT
- show dependent code
-
OKS_BILLPRST_SRVSUBLINE_V
-
OKS_BILL_UTIL_PUB
- show dependent code
-
OKS_CONTRACTS_PUB
- show dependent code
-
OKS_ENTITLEMENTS_PVT
- show dependent code
-
OKS_ENT_UTIL_PVT
- show dependent code
-
OKS_EXTWARPRGM_OSO_PVT
- show dependent code
-
OKS_EXTWARPRGM_PVT
- show dependent code
-
OKS_HEADERS_V
-
OKS_HEADER_DETAILS_V
-
OKS_LINES_V
-
OKS_LINE_DETAILS_V
-
OKS_MASSCHANGE_PVT
- show dependent code
-
OKS_OC_INT_KTO_PVT
- show dependent code
-
OKS_PROD_DETAILS_V
-
OKS_QA_DATA_INTEGRITY
- show dependent code