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

VIEW: APPS.OKL_STRM_TYPE_V

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

View Type

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


The payment types and their details are stored here. e.g. a payment of type RENT could be TAXABLE,
BILLABLE, FUNDABLE and PERIODIC.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
ID NUMBER
Yes Primary key column
NAME VARCHAR2 (150) Yes A unique name given for a type
VERSION VARCHAR2 (24) Yes Version
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
CODE VARCHAR2 (150) Yes Internal code for the stream type.
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
STREAM_TYPE_SCOPE VARCHAR2 (30) Yes Scope of the stream type.
STREAM_TYPE_SUBCLASS VARCHAR2 (30)
Stream type subclass
STREAM_TYPE_PURPOSE VARCHAR2 (30)
Stream type purpose
CONTINGENCY VARCHAR2 (30)
Contingency
SHORT_DESCRIPTION VARCHAR2 (600)
User entered short description of the stream type.
DESCRIPTION VARCHAR2 (1995)
A brief description of a stream type
START_DATE DATE
Yes Start date
END_DATE DATE

End date
BILLABLE_YN VARCHAR2 (30) Yes Whether billable.
TAXABLE_DEFAULT_YN VARCHAR2 (30) Yes Whether it is taxable or not
CUSTOMIZATION_LEVEL VARCHAR2 (30) Yes Lookup code to identify whether stream types are seeded or not. Valid values are S & U.
FUNDABLE_YN VARCHAR2 (30)
Whether fundable.
PERIODIC_YN VARCHAR2 (30)
Whether periodic.
STREAM_TYPE_CLASS VARCHAR2 (30) Yes Class of the stream type e.g. FEES, EXPENSE etc.
CAPITALIZE_YN VARCHAR2 (30)
Whether part of capitalizable.
ACCRUAL_YN VARCHAR2 (30) Yes Whether it is taxable or not
ALLOCATION_FACTOR VARCHAR2 (30)
Allocation basis based on which a stream type can be allocated from contract to assets.
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
STYB_PURPOSE_MEANING VARCHAR2 (4000)
Stream Purpose Meaning
CONTINGENCY_ID NUMBER

Contingency Identifier
Query Text

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


SELECT ROW_ID
,      ID
,      NAME
,      VERSION
,      OBJECT_VERSION_NUMBER
,      CODE
,      SFWT_FLAG
,      STREAM_TYPE_SCOPE
,      STREAM_TYPE_SUBCLASS
,      STREAM_TYPE_PURPOSE
,      CONTINGENCY
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      START_DATE
,      END_DATE
,      BILLABLE_YN
,      TAXABLE_DEFAULT_YN
,      CUSTOMIZATION_LEVEL
,      FUNDABLE_YN
,      PERIODIC_YN
,      STREAM_TYPE_CLASS
,      CAPITALIZE_YN
,      ACCRUAL_YN
,      ALLOCATION_FACTOR
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      STYB_PURPOSE_MEANING
,      CONTINGENCY_ID
FROM APPS.OKL_STRM_TYPE_V;

Dependencies

[top of page]

APPS.OKL_STRM_TYPE_V references the following:

SchemaAPPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL
APPS.OKL_STRM_TYPE_V is referenced by following:

SchemaAPPS
ViewIEX_AVAIL_CONS_INVOICES_V
ViewIEX_AVAIL_CONTRACTS_V
ViewIEX_AVAIL_OKL_INVOICES_V
ViewIEX_OKL_PAYMENTS_V
Package BodyIEX_SCORE_CASE_PVT - show dependent code
ViewIEX_WRITEOFF_INVOICES_V
Package BodyOKL_ACCRUAL_DEPRN_ADJ_PVT - show dependent code
ViewOKL_AEL_GL_CTR_V
ViewOKL_AEL_GL_QTE_V
ViewOKL_AEL_GL_TRX_V
ViewOKL_AEL_SL_V
ViewOKL_AE_TEMPLATES_UV
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_AM_LEASE_TRMNT_PVT - show dependent code
ViewOKL_AM_PAYMENT_SCHDLE_DTLS_UV
ViewOKL_AM_QUOTE_AMOUNTS_UV
ViewOKL_AM_QUOTE_AMT_SUMMARY_UV
ViewOKL_AM_QUOTE_LINE_STRM_UV
Package BodyOKL_AM_SECURITIZATION_PVT - show dependent code
Package BodyOKL_AM_TERMINATE_INV_AGMT_PVT - show dependent code
ViewOKL_AP_INVOICE_LINES_V
Package BodyOKL_ARFETCH_PUB - show dependent code
PL/SQL PackageOKL_ARINTF_PVT - show dependent code
Package BodyOKL_ARINTF_PVT - show dependent code
ViewOKL_AR_TRX_LINE_UV
Package BodyOKL_ASE_PVT - show dependent code
Package BodyOKL_AVL_PVT - show dependent code
Package BodyOKL_BILLING_CONTROLLER_PVT - show dependent code
PL/SQL PackageOKL_BILLING_CONTROLLER_PVT - show dependent code
Package BodyOKL_BILL_STATUS_PVT - show dependent code
Package BodyOKL_BPD_ADVANCED_BILLING_PVT - show dependent code
ViewOKL_BPD_AP_DISBURS_SMRY_UV
ViewOKL_BPD_AP_DISB_DTL_LN_UV
ViewOKL_BPD_AP_INV_LINES_UV
ViewOKL_BPD_AR_ADJ_LINES_V
ViewOKL_BPD_AR_INV_LN_DTLS_V
ViewOKL_BPD_ASSIGN_FORMATS_UV
ViewOKL_BPD_CONTRACT_REMAINING_V
ViewOKL_BPD_DISB_STREAMS_LOV_UV
ViewOKL_BPD_RECEIPT_APPLIC_UV
ViewOKL_BPD_RECEIPT_ASSET_UV
PL/SQL PackageOKL_BPD_TERMINATION_ADJ_PVT - show dependent code
Package BodyOKL_BPD_TERMINATION_ADJ_PVT - show dependent code
ViewOKL_BPD_TRX_SUM_ALL_STRMS_UV
ViewOKL_BPD_TRX_SUM_RCPT_DTLS_UV
Package BodyOKL_CAF_PVT - show dependent code
Package BodyOKL_CNTR_GRP_BILLING_PVT - show dependent code
PL/SQL PackageOKL_CONS_BILL - show dependent code
Package BodyOKL_CONS_BILL - show dependent code
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_INFO - show dependent code
Package BodyOKL_CONTRACT_REBOOK_PVT - show dependent code
Package BodyOKL_CREATE_ADJST_PVT - show dependent code
Package BodyOKL_CREDIT_DATAPOINTS_PVT - show dependent code
PL/SQL PackageOKL_CSH_ORDER_SEQ_PVT - show dependent code
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
ViewOKL_CS_PROPERTY_TAX_UV
Package BodyOKL_DAILY_INTEREST_CALC_PVT - show dependent code
Package BodyOKL_EVERGREEN_BILLING_PVT - show dependent code
Package BodyOKL_EXPENSE_STREAMS_PVT - show dependent code
Package BodyOKL_EXT_BILLING_CHARGES_PVT - show dependent code
Package BodyOKL_FUNDING_PVT - show dependent code
ViewOKL_FUND_REQ_LINES_UV
Package BodyOKL_GENERATE_ACCRUALS_PVT - show dependent code
PL/SQL PackageOKL_GENERATE_ACCRUALS_PVT - show dependent code
Package BodyOKL_GTL_PVT - show dependent code
Package BodyOKL_ILS_PVT - show dependent code
Package BodyOKL_INSURANCE_POLICIES_PVT - show dependent code
Package BodyOKL_INTERNAL_BILLING_PVT - show dependent code
Package BodyOKL_INTERNAL_TO_EXTERNAL - show dependent code
PL/SQL PackageOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_INVESTOR_BILLING_PVT - show dependent code
Package BodyOKL_INVESTOR_INVOICE_DISB_PVT - show dependent code
Package BodyOKL_ISG_UTILS_PVT - show dependent code
PL/SQL PackageOKL_ISG_UTILS_PVT - show dependent code
ViewOKL_KLE_STRM_V
Package BodyOKL_K_RATE_PARAMS_PVT - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
ViewOKL_LA_PT_EVG_STRM_TYPE_UV
Package BodyOKL_LA_STREAM_PVT - show dependent code
PL/SQL PackageOKL_LA_STREAM_PVT - show dependent code
ViewOKL_LA_STX_SMRY_UV
PL/SQL PackageOKL_LOSS_PROV_PVT - show dependent code
Package BodyOKL_LOSS_PROV_PVT - show dependent code
Package BodyOKL_LSM_PVT - show dependent code
Package BodyOKL_LTE_CHRG_PVT - show dependent code
Package BodyOKL_LTE_INT_PVT - show dependent code
Package BodyOKL_MASS_REBOOK_PVT - show dependent code
ViewOKL_MISC_TMPL_UV
Package BodyOKL_MULTIGAAP_ENGINE_PVT - show dependent code
Package BodyOKL_MULTI_GAAP_PVT - show dependent code
PL/SQL PackageOKL_MULTI_GAAP_PVT - show dependent code
ViewOKL_PAYMENT_SCHDLE_DTLS_ALL_UV
Package BodyOKL_PAY_INVOICES_DISB_PVT - show dependent code
Package BodyOKL_POC_PVT - show dependent code
ViewOKL_POOL_CONTENTS_UV
PL/SQL PackageOKL_POOL_PVT - show dependent code
Package BodyOKL_POOL_PVT - show dependent code
ViewOKL_POOL_STREAMS_PAY_UV
ViewOKL_POOL_STREAMS_UV
ViewOKL_POOL_STREAM_ELEMENTS_UV
ViewOKL_POOL_TRANS_CONTENTS_UV
Package BodyOKL_PROCESS_STREAMS_PVT - show dependent code
Package BodyOKL_PROPERTY_TAX_STATEMENT_PVT - show dependent code
Package BodyOKL_PROP_TAX_ADJ_PVT - show dependent code
Package BodyOKL_PSY_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
PL/SQL PackageOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_QA_SECURITIZATION - show dependent code
Package BodyOKL_QLS_PVT - show dependent code
ViewOKL_QUOTE_AMT_SMRY_ALL_UV
Package BodyOKL_REBOOK_CM_PVT - show dependent code
Package BodyOKL_REPORT_GENERATOR_PVT - show dependent code
Package BodyOKL_REPORT_PVT - show dependent code
ViewOKL_SEC_BUYBACK_STREAMS_UV
Package BodyOKL_SEC_CONCURRENT_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_SETUPPRODUCTS_PVT - show dependent code
Package BodyOKL_SETUPPSTYPES_PVT - show dependent code
Package BodyOKL_SETUP_STREAMTYPES_PVT - show dependent code
Package BodyOKL_SIT_PVT - show dependent code
Package BodyOKL_STM_PVT - show dependent code
Package BodyOKL_STREAMS_RECON_PVT - show dependent code
PL/SQL PackageOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_STREAM_GENERATOR_PVT - show dependent code
Package BodyOKL_STREAM_MIGRATION_PVT - show dependent code
ViewOKL_STRM_TMPT_ALL_TYPES_UV
ViewOKL_STRM_TMPT_CONTRACTS_UV
ViewOKL_STRM_TMPT_CONTRACT_UV
ViewOKL_STRM_TMPT_PRIMARY_UV
ViewOKL_STRM_TMPT_SET_TYPE_UV
ViewOKL_STRM_TMPT_TYPES_ALL_UV
ViewOKL_STRM_TYPE_PURPOSE_UV
PL/SQL PackageOKL_STY_PVT - show dependent code
Package BodyOKL_STY_PVT - show dependent code
Package BodyOKL_ST_CODE_CONVERSIONS - show dependent code
Package BodyOKL_SUBSIDY_PROCESS_PVT - show dependent code
Package BodyOKL_TCL_PVT - show dependent code
Package BodyOKL_TIL_PVT - show dependent code
Package BodyOKL_TPL_PVT - show dependent code
Package BodyOKL_TQL_PVT - show dependent code
ViewOKL_TRX_LINE_UV
ViewOKL_TXL_CNTRCT_LNS_UV
Package BodyOKL_UBB_PVT - show dependent code
PL/SQL PackageOKL_UPDT_CASH_DTLS - show dependent code
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code
Package BodyOKL_VARIABLE_INT_UTIL_PVT - show dependent code
Package BodyOKL_VAR_INT_CATCHUP_PVT - show dependent code
Package BodyOKL_VAR_INT_FLOAT_FACTOR_PVT - show dependent code
Package BodyOKL_VAR_INT_FLOAT_PVT - show dependent code
Package BodyOKL_VAR_INT_REAMORT_PVT - show dependent code
Package BodyOKL_VR_DOCUMENT_PVT - show dependent code