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


VIEW: APPS.OKL_TIME_UNITS_V

Object Details
Object Name: OKL_TIME_UNITS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_TIME_UNITS_V
Subobject Name:
Status: VALID

View Type

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


OKL_TIME_UNITS_V contains all the frequency time units used in Lease Management.It based on lookup code 'OKL_FREQUENCY'. This view is used as object source for jtf_object OKL_TUOM.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 VARCHAR2 (30) Yes Primary key column
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (80) Yes Time unit name
DESCRIPTION VARCHAR2 (240)
Time unit description
START_DATE_ACTIVE DATE

Effective from date
END_DATE_ACTIVE DATE

Effective to date
STATUS VARCHAR2 (1)
Indicates whether time unit is active or inactive
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measure code for time unit
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      ENABLED_FLAG
,      PRIMARY_UOM_CODE
FROM APPS.OKL_TIME_UNITS_V;

Dependencies

[top of page]

APPS.OKL_TIME_UNITS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.OKL_TIME_UNITS_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_CALC_QUOTE_PYMNT_PVT - show dependent code
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_TOP_LINE_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
PL/SQL PackageOKL_DEAL_CHARGES_PVT - show dependent code
Package BodyOKL_K_LINE_FIN_EXT_PVT - show dependent code
ViewOKL_LA_FEE_LINES_UV
ViewOKL_LA_SERVICE_LINES_UV
Package BodyOKL_LA_STREAM_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_PAYMENT_SPLIT_PVT - show dependent code
PL/SQL PackageOKL_POOL_PVT - show dependent code
ViewOKL_POOL_STREAMS_PAY_UV
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code