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_VENDORS_V

Object Details

Object Name:	OKX_VENDORS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_VENDORS_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		Yes	Supplier unique identifier
ID2	CHAR	(1)		(Multi-part) Primary Key
NAME	VARCHAR2	(240)		Supplier name
B_STATUS	VARCHAR2	(1)	Yes	Key flexfield summary flag
STATUS	VARCHAR2	(1)		Status
START_DATE_ACTIVE	DATE			Key flexfield start date
END_DATE_ACTIVE	DATE			Key flexfield end date
MINORITY_GROUP_LOOKUP	VARCHAR2	(30)		Type of minority-owned business
WOMEN_OWNED_FLAG	VARCHAR2	(1)		Indicates whether the supplier is a woman-owned business or not
SMALL_BUSINESS_FLAG	VARCHAR2	(1)		Indicates that the supplier is a small business
DESCRIPTION	VARCHAR2	(30)	Yes	Supplier number
SET_OF_BOOKS_ID	NUMBER			Set of Books unique identifier
PARTY_NUMBER	VARCHAR2	(30)	Yes	Supplier number
ADDRESS	VARCHAR2	(0)		Supplier's address
VENDOR_TYPE_LOOKUP_CODE	VARCHAR2	(30)
COUNTRY	VARCHAR2	(0)
ADDRESS1	VARCHAR2	(0)
ADDRESS2	VARCHAR2	(0)
ADDRESS3	VARCHAR2	(0)
ADDRESS4	VARCHAR2	(0)
POSTAL_CODE	VARCHAR2	(0)
STATE	VARCHAR2	(0)
COUNTY	VARCHAR2	(0)
CITY	VARCHAR2	(0)

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      B_STATUS
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      MINORITY_GROUP_LOOKUP
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINESS_FLAG
,      DESCRIPTION
,      SET_OF_BOOKS_ID
,      PARTY_NUMBER
,      ADDRESS
,      VENDOR_TYPE_LOOKUP_CODE
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      POSTAL_CODE
,      STATE
,      COUNTY
,      CITY
FROM APPS.OKX_VENDORS_V;

Dependencies

[top of page]

APPS.OKX_VENDORS_V references the following:

APPS: PO_VENDORS

APPS.OKX_VENDORS_V is referenced by following:

APPS: IEX_EXT_AGNCY_UV; OKC_CREATE_PO_FROM_K_PVT - show dependent code; OKE_DELIVERABLE_PVT - show dependent code; OKE_VERSION_COMPARISON_PKG - show dependent code; OKL_AM_ASSET_CNDTN_FULL_UV; OKL_AM_ASSET_RETURNS_UV; OKL_AM_ASSET_RETURN_WF - show dependent code; OKL_AM_TERMNT_INTERFACE_PVT - show dependent code; OKL_ART_PVT - show dependent code; OKL_ASSET_SUBSIDY_UV; OKL_BPD_DISB_CONTRACT_LOV_UV; OKL_BPD_DISB_LOV_UV; OKL_BPD_MAN_DISB_LOV_UV; OKL_CONTRACT_REBOOK_PVT - show dependent code; OKL_CONTRACT_TOP_LINE_PVT - show dependent code; OKL_CURE_OFFSET_CONTRACTS_UV; OKL_CURE_VENDOR_DUE_UV; OKL_CURE_VENDOR_PROGRAM_UV; OKL_C_V_RULES_UV; OKL_EQUIPMENT_EXCHANGE_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_K_LINE_VENDORS_UV; OKL_K_VENDORS_UV; OKL_K_VENDOR_PROGRAMS_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_POOL_ASSETS_UV; OKL_POOL_PVT - show dependent code; OKL_PSTHRU_BASE_PMNT_DTL_UV; OKL_PSTHRU_EVRGRN_PMNT_DTL_UV; OKL_QA_DATA_INTEGRITY - show dependent code; OKL_REFUND_UV; OKL_SEC_AGREEMENTS_UV; OKL_VENDOR_REFUND_PVT - show dependent code; OKL_VP_JTF_PARTY_NAME_PVT - show dependent code