[Home] [Help]
[Dependency Information]
VIEW: APPS.OKX_PARTIES_V
Object Details
Object Name: | OKX_PARTIES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_PARTIES_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 |
Party Identifier |
ID2 |
CHAR |
(1) |
|
(Multi-part) Primary Key |
DESCRIPTION |
VARCHAR2 |
(30) |
Yes |
Description (party number) |
PARTY_NUMBER |
VARCHAR2 |
(30) |
Yes |
Party number |
CUSTOMER_PROSPECT_CODE |
VARCHAR2 |
(8) |
|
Party's address |
NAME |
VARCHAR2 |
(360) |
Yes |
Party name |
PARTY_TYPE |
VARCHAR2 |
(30) |
Yes |
Type of party |
B_STATUS |
VARCHAR2 |
(1) |
Yes |
Party status flag |
STATUS |
VARCHAR2 |
(1) |
Yes |
Status |
START_DATE_ACTIVE |
DATE |
|
|
Date record becomes active |
END_DATE_ACTIVE |
DATE |
|
|
Date record becomes inactive |
WOMEN_OWNED_FLAG |
VARCHAR2 |
(0) |
|
Indicates whether the party is a woman-owned business |
SMALL_BUSINESS_FLAG |
VARCHAR2 |
(0) |
|
Indicates that the party is a small business |
MINORITY_GROUP_LOOKUP_CODE |
VARCHAR2 |
(0) |
|
Type of minority-owned business |
PRIMARY_UOM_CODE |
VARCHAR2 |
(0) |
|
Used for lines entry, list of UOM. |
GSA_INDICATOR_FLAG |
VARCHAR2 |
(1) |
|
Y if the organization is a public sector service agency |
COUNTRY |
VARCHAR2 |
(60) |
|
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. |
ADDRESS1 |
VARCHAR2 |
(240) |
|
First line of the Identifying address |
ADDRESS2 |
VARCHAR2 |
(240) |
|
Second line of the Identifying address |
ADDRESS3 |
VARCHAR2 |
(240) |
|
Third line of the Identifying address |
ADDRESS4 |
VARCHAR2 |
(240) |
|
Fourth line of the Identifying address |
CITY |
VARCHAR2 |
(60) |
|
City of the Identifying address |
POSTAL_CODE |
VARCHAR2 |
(60) |
|
Postal Code of the Identifying address |
STATE |
VARCHAR2 |
(60) |
|
State of the Identifying address |
PROVINCE |
VARCHAR2 |
(60) |
|
Province of the Identifying address |
COUNTY |
VARCHAR2 |
(60) |
|
County of the Identifying address |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, DESCRIPTION
, PARTY_NUMBER
, CUSTOMER_PROSPECT_CODE
, NAME
, PARTY_TYPE
, B_STATUS
, STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, WOMEN_OWNED_FLAG
, SMALL_BUSINESS_FLAG
, MINORITY_GROUP_LOOKUP_CODE
, PRIMARY_UOM_CODE
, GSA_INDICATOR_FLAG
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
FROM APPS.OKX_PARTIES_V;
Dependencies
[top of page]
APPS.OKX_PARTIES_V references the following:
-
APPS
-
HZ_PARTIES
APPS.OKX_PARTIES_V is referenced by following:
-
APPS
-
IEX_EXCLUSION_ELIGIBLE_UV
-
OKC_OKS_PUB
- show dependent code
-
OKC_TEST
- show dependent code
-
OKE_CUST_SITE_USES_V
-
OKE_FUNDSOURCE_PVT
- show dependent code
-
OKI_K_PARTIES_V
-
OKL_ACCRUAL_OVERRIDE_UV
-
OKL_AEL_GL_CTR_V
-
OKL_BPD_ALL_CONTRACT_CUST_UV
-
OKL_BPD_BATCH_CONT_LINES_UV
-
OKL_BPD_CNTR_INVOICE_HDR_BC_V
-
OKL_BPD_CONS_INV_CUST_UV
-
OKL_BPD_CONTRACT_CUSTOMER_UV
-
OKL_BPD_INVESTOR_LOV_UV
-
OKL_BPD_INVOICE_HDR_BC_V
-
OKL_CREDITLINES_UV
-
OKL_CREDIT_PUB
- show dependent code
-
OKL_CREDIT_PUB
- show dependent code
-
OKL_CS_WF
- show dependent code
-
OKL_CUSTOMER_ACCT_UV
-
OKL_CUSTOMER_UV
-
OKL_DEAL_CHARGES_PVT
- show dependent code
-
OKL_DEAL_CREATE_PUB
- show dependent code
-
OKL_DEAL_CREAT_PVT
- show dependent code
-
OKL_FUNDING_WF
- show dependent code
-
OKL_INVESTOR_BILLING_PVT
- show dependent code
-
OKL_JTOT_CONTACT_EXTRACT_PUB
- show dependent code
-
OKL_JTOT_CONTACT_EXTRACT_PVT
- show dependent code
-
OKL_JTOT_EXTRACT
- show dependent code
-
OKL_LA_FEE_LINES_UV
-
OKL_LA_VALIDATION_UTIL_PVT
- show dependent code
-
OKL_MAINTAIN_FEE_PVT
- show dependent code
-
OKL_OPEN_INTERFACE_PVT
- show dependent code
-
OKL_POOLCONC_PVT
- show dependent code
-
OKL_QA_DATA_INTEGRITY
- show dependent code
-
OKL_QA_SECURITIZATION
- show dependent code
-
OKL_RECONCILE_DISPLAY_UV
-
OKL_REFUND_UV
-
OKL_REPORT_PVT
- show dependent code
-
OKL_SEC_CONCURRENT_PVT
- show dependent code
-
OKL_SEC_INVESTORS_UV
-
OKL_SEC_INVESTOR_PVT
- show dependent code
-
OKL_SO_CREDIT_APP_WF
- show dependent code
-
OKL_STRMS_STD_HDR_UV
-
OKL_VP_JTF_PARTY_NAME_PVT
- show dependent code
-
OKS_AUTH_UTIL_PVT
- show dependent code
-
OKS_AUTH_UTIL_PVT
- show dependent code
-
OKS_AUTO_REMINDER
- show dependent code
-
OKS_BILLING_PROFILES_PVT
- show dependent code
-
OKS_BILLPRST_SRVSUBLINE_V
-
OKS_BILL_REC_PUB
- show dependent code
-
OKS_BILL_UTIL_PUB
- show dependent code
-
OKS_CT_EVENTS_WFA
- show dependent code
-
OKS_ENTITLEMENTS_PVT
- show dependent code
-
OKS_ENTITLEMENTS_WEB
- show dependent code
-
OKS_ENT_UTIL_PVT
- show dependent code
-
OKS_EXTWARPRGM_OSO_PVT
- show dependent code
-
OKS_EXTWARPRGM_PVT
- show dependent code
-
OKS_MASSCHANGE_PVT
- show dependent code
-
OKS_OCINT_PUB
- show dependent code
-
OKS_OKSCODET_XMLP_PKG
- show dependent code
-
OKS_PROD_DETAILS_V
-
OKS_SALES_COMPENSATION_V
-
OKS_SERV_CUSTEXC_V