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

VIEW: APPS.OKX_ORGANIZATION_DEFS_V

Object Details
Object Name: OKX_ORGANIZATION_DEFS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_ORGANIZATION_DEFS_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 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)
Query Text

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;

Dependencies

[top of page]

APPS.OKX_ORGANIZATION_DEFS_V references the following:

SchemaAPPS
PL/SQL PackageARP_ADDR_LABEL_PKG - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL
SynonymHR_ORGANIZATION_INFORMATION
SynonymMTL_PARAMETERS
APPS.OKX_ORGANIZATION_DEFS_V is referenced by following:

SchemaAPPS
Package BodyOKC_CONTRACT_SEQ_PVT - show dependent code
Package BodyOKC_UTIL - show dependent code
Package BodyOKE_DELIVERABLE_PVT - show dependent code
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code
ViewOKL_CS_LESSOR_UV
Package BodyOKL_ITI_PVT - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PUB - show dependent code
Package BodyOKL_JTOT_CONTACT_EXTRACT_PVT - show dependent code
Package BodyOKL_JTOT_EXTRACT - show dependent code
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
Package BodyOKL_OVD_PVT - show dependent code
Package BodyOKL_VP_JTF_PARTY_NAME_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_OKSCODET_XMLP_PKG - show dependent code