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_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