[Home] [Help] [Dependency Information]
Object Name: | OKX_ORG_PARTIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_ORG_PARTIES_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.OKX_ORG_PARTIES_V is not referenced by any database object
|
|
|