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

VIEW: APPS.OKL_ST_MAP_PERIODIC_FEES_V

Object Details
Object Name: OKL_ST_MAP_PERIODIC_FEES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_ST_MAP_PERIODIC_FEES_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
TRANSACTION_NUMBER NUMBER
Yes order or sequence within "parent"
SFE_TYPE VARCHAR2 (10) Yes
SIF_ID NUMBER

Foreign key to view OKL_STREAM_INTERFACES_V
KLE_ID NUMBER

Foreign key to view OKL_K_LINES_V
SIL_ID NUMBER

Foreign key to view OKL_SIF_LINES_V
STRUCTURE VARCHAR2 (200)
Structure
CASH_EFFECT_YN VARCHAR2 (3)
Cash Effect YN flag
TAX_EFFECT_YN VARCHAR2 (3)
Tax Effect YN flag
DAYS_IN_PERIOD NUMBER

Days in Period
DATE_START DATE

First due date for a recurring fee
QUERY_LEVEL_YN VARCHAR2 (10)
LEVEL_TYPE VARCHAR2 (30)
FEE_INDEX_NUMBER NUMBER
Yes Index to determine relationship with Asset
DESCRIPTION VARCHAR2 (1995)
Recurring Fee- Fee Type
LEVEL_INDEX_NUMBER NUMBER (3)
NUMBER_OF_PERIODS NUMBER (6)
PERIOD VARCHAR2 (30)
ADVANCE_OR_ARREARS VARCHAR2 (10) Yes Should be one setting for the contract
AMOUNT NUMBER

Start date for contract
LOCK_LEVEL_STEP VARCHAR2 (10)
RATE NUMBER (18)
STREAM_INTERFACE_ATTRIBUTE01 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE02 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE03 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE04 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE05 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE06 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE07 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE08 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE09 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE10 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE11 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE12 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE13 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE14 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE15 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE16 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE17 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE18 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE19 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE20 VARCHAR2 (450)
DATE_PAID DATE

First due date for a recurring fee
Query Text

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


SELECT TRANSACTION_NUMBER
,      SFE_TYPE
,      SIF_ID
,      KLE_ID
,      SIL_ID
,      STRUCTURE
,      CASH_EFFECT_YN
,      TAX_EFFECT_YN
,      DAYS_IN_PERIOD
,      DATE_START
,      QUERY_LEVEL_YN
,      LEVEL_TYPE
,      FEE_INDEX_NUMBER
,      DESCRIPTION
,      LEVEL_INDEX_NUMBER
,      NUMBER_OF_PERIODS
,      PERIOD
,      ADVANCE_OR_ARREARS
,      AMOUNT
,      LOCK_LEVEL_STEP
,      RATE
,      STREAM_INTERFACE_ATTRIBUTE01
,      STREAM_INTERFACE_ATTRIBUTE02
,      STREAM_INTERFACE_ATTRIBUTE03
,      STREAM_INTERFACE_ATTRIBUTE04
,      STREAM_INTERFACE_ATTRIBUTE05
,      STREAM_INTERFACE_ATTRIBUTE06
,      STREAM_INTERFACE_ATTRIBUTE07
,      STREAM_INTERFACE_ATTRIBUTE08
,      STREAM_INTERFACE_ATTRIBUTE09
,      STREAM_INTERFACE_ATTRIBUTE10
,      STREAM_INTERFACE_ATTRIBUTE11
,      STREAM_INTERFACE_ATTRIBUTE12
,      STREAM_INTERFACE_ATTRIBUTE13
,      STREAM_INTERFACE_ATTRIBUTE14
,      STREAM_INTERFACE_ATTRIBUTE15
,      STREAM_INTERFACE_ATTRIBUTE16
,      STREAM_INTERFACE_ATTRIBUTE17
,      STREAM_INTERFACE_ATTRIBUTE18
,      STREAM_INTERFACE_ATTRIBUTE19
,      STREAM_INTERFACE_ATTRIBUTE20
,      DATE_PAID
FROM APPS.OKL_ST_MAP_PERIODIC_FEES_V;

Dependencies

[top of page]

APPS.OKL_ST_MAP_PERIODIC_FEES_V references the following:

SchemaAPPS
SynonymOKL_SIF_FEES
SynonymOKL_STREAM_INTERFACES

APPS.OKL_ST_MAP_PERIODIC_FEES_V is not referenced by any database object