DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_ORG_PARTIES_V

Object Details
Object Name: OKX_ORG_PARTIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ORG_PARTIES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays information about parties such as organizations, people, and groups, including the identifying address information for the party.


[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
ADDRESS VARCHAR2 (80)
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
Query Text

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


SELECT ID1
,      ID2
,      DESCRIPTION
,      PARTY_NUMBER
,      ADDRESS
,      NAME
,      PARTY_TYPE
,      B_STATUS
,      STATUS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINESS_FLAG
,      MINORITY_GROUP_LOOKUP_CODE
FROM APPS.OKX_ORG_PARTIES_V;

Dependencies

[top of page]

APPS.OKX_ORG_PARTIES_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_PARTIES

APPS.OKX_ORG_PARTIES_V is not referenced by any database object