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