[Home] [Help] [Dependency Information]
Object Name: | OKL_ST_MAP_FEES_ONEOFF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_ST_MAP_FEES_ONEOFF_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" | |
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 | ||
FEE_INDEX_NUMBER | NUMBER | Yes | Index to determine relationship with Asset | |
DESCRIPTION | VARCHAR2 | (1995) | Recurring Fee- Fee Type | |
DATE_PAID | DATE | assume start date | ||
AMOUNT | NUMBER | Start date for contract | ||
INCOME_OR_EXPENSE | VARCHAR2 | (10) | Yes | Always send income |
IDC_ACCOUNTING_FLAG | VARCHAR2 | (10) | From fee type set up | |
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) | ||
ORIG_CONTRACT_LINE_ID | NUMBER | Foreign key to table okc_k_lines_b |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_NUMBER
, SIF_ID
, KLE_ID
, SIL_ID
, FEE_INDEX_NUMBER
, DESCRIPTION
, DATE_PAID
, AMOUNT
, INCOME_OR_EXPENSE
, IDC_ACCOUNTING_FLAG
, 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
, ORIG_CONTRACT_LINE_ID
FROM APPS.OKL_ST_MAP_FEES_ONEOFF_V;
APPS.OKL_ST_MAP_FEES_ONEOFF_V is not referenced by any database object
|
|
|