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

VIEW: APPS.OKL_STRMTYP_SOURCE_V

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

View Type

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


Source for jtf object OKL_STRMTYP.
Stream types.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Primary key column. Foreign key to OKL_STRM_TYPE_B.ID
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (150) Yes Stream type name
DESCRIPTION VARCHAR2 (1995)
Stream type description
VERSION VARCHAR2 (24) Yes Version
CODE VARCHAR2 (150) Yes Unique code for stream type
STREAM_TYPE_SCOPE VARCHAR2 (30) Yes stream type scope
START_DATE_ACTIVE DATE
Yes Effective from date for stream type record
END_DATE_ACTIVE DATE

Effective to date for stream type record
STATUS VARCHAR2 (1)
Indicates whether stream type is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (0)
Stream type primary unit of measure code
BILLABLE_YN VARCHAR2 (30) Yes Indicates whether stream type is billable or not
TAXABLE_DEFAULT_YN VARCHAR2 (30) Yes Indicates whether stream type is taxable by default or not
CUSTOMIZATION_LEVEL VARCHAR2 (30) Yes Customization level
FUNDABLE_YN VARCHAR2 (30)
Indicates whether stream type is fundable or not
PERIODIC_YN VARCHAR2 (30)
Indicates whether stream type is periodic or not
STREAM_TYPE_CLASS VARCHAR2 (30) Yes Stream type class
CAPITALIZE_YN VARCHAR2 (30)
Indicates whether stream type can be capitalized or not
ACCRUAL_YN VARCHAR2 (30) Yes Indicates whether sream type is eligible for accrual or not
STREAM_TYPE_PURPOSE VARCHAR2 (30)
The purpose code of the stream type
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      VERSION
,      CODE
,      STREAM_TYPE_SCOPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      BILLABLE_YN
,      TAXABLE_DEFAULT_YN
,      CUSTOMIZATION_LEVEL
,      FUNDABLE_YN
,      PERIODIC_YN
,      STREAM_TYPE_CLASS
,      CAPITALIZE_YN
,      ACCRUAL_YN
,      STREAM_TYPE_PURPOSE
FROM APPS.OKL_STRMTYP_SOURCE_V;

Dependencies

[top of page]

APPS.OKL_STRMTYP_SOURCE_V references the following:

SchemaAPPS
SynonymOKL_STRM_TYPE_B
SynonymOKL_STRM_TYPE_TL
APPS.OKL_STRMTYP_SOURCE_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_CALC_QUOTE_PYMNT_PVT - show dependent code
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_CONTRACT_INFO - show dependent code
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code
Package BodyOKL_CONTRACT_TOP_LINE_PVT - show dependent code
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
PL/SQL PackageOKL_DEAL_CHARGES_PVT - show dependent code
Package BodyOKL_DEAL_TERMS_PVT - show dependent code
ViewOKL_FEE_SERVICE_STRMS_UV
PL/SQL PackageOKL_LA_PAYMENTS_PVT - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
ViewOKL_LA_PAYMENTS_SUMMARY_UV
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code
Package BodyOKL_LEASE_QUOTE_ASSET_PVT - show dependent code
Package BodyOKL_MAINTAIN_FEE_PVT - show dependent code
PL/SQL PackageOKL_MAINTAIN_FEE_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_PAYMENT_APPLICATION_PVT - show dependent code
Package BodyOKL_PAYMENT_SPLIT_PVT - show dependent code
ViewOKL_PYMTS_FEE_INSTS_UV
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_QA_SECURITIZATION - show dependent code