[Home] [Help] [Dependency Information]
Object Name: | OKX_ORGANIZATION_DEFS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_ORGANIZATION_DEFS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | (15) | Yes | System-generated primary key column. |
ID2 | CHAR | (1) | (Multi-part) Primary Key | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
ORGANIZATION_ID | NUMBER | (15) | Yes | Inventory Organization identifier |
NAME | VARCHAR2 | (240) | Yes | Translated name of the organization |
B_STATUS | VARCHAR2 | (150) | Status | |
STATUS | VARCHAR2 | (1) | Status | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
ORGANIZATION_TYPE | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
SET_OF_BOOKS_ID | VARCHAR2 | (150) | Set of books identifier | |
LEGAL_ENTITY | VARCHAR2 | (150) | Legal Entity | |
OPERATING_UNIT | VARCHAR2 | (150) | Operating Unit | |
DESCRIPTION | VARCHAR2 | (3) | Description (Organization code) | |
INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Developer descriptive flexfield column. |
START_DATE_ACTIVE | DATE | Yes | Start date of the organization. | |
END_DATE_ACTIVE | DATE | End date of the organization. | ||
PARTY_NUMBER | VARCHAR2 | (3) | Organization code | |
ADDRESS | VARCHAR2 | (80) | Organization's address | |
WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Indicates whether the organization is a woman-owned business | |
SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Indicates that the organization is a small business | |
MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (0) | Type of minority-owned business | |
COUNTRY | VARCHAR2 | (60) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (0) | ||
POSTAL_CODE | VARCHAR2 | (30) | ||
STATE | VARCHAR2 | (0) | ||
COUNTY | VARCHAR2 | (0) | ||
CITY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, NAME
, B_STATUS
, STATUS
, ORGANIZATION_CODE
, ORGANIZATION_TYPE
, SET_OF_BOOKS_ID
, LEGAL_ENTITY
, OPERATING_UNIT
, DESCRIPTION
, INFORMATION_TYPE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PARTY_NUMBER
, ADDRESS
, WOMEN_OWNED_FLAG
, SMALL_BUSINESS_FLAG
, MINORITY_GROUP_LOOKUP_CODE
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTAL_CODE
, STATE
, COUNTY
, CITY
FROM APPS.OKX_ORGANIZATION_DEFS_V;
|
|
|