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

VIEW: APPS.OKL_POOL_SRCH_PAYFREQ_V

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

View Type

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


Securitization - pool search streams view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CUST_OBJECT1_ID1 NUMBER (15) Yes Customer account identifier
LESSEE VARCHAR2 (360) Yes Customer name
SIC_CODE VARCHAR2 (30)
Service industry code
DNZ_CHR_ID NUMBER
Yes Denormalized contract header identifier
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number
PRE_TAX_YIELD NUMBER

Pre-tax yield
BOOK_CLASSIFICATION VARCHAR2 (30)
Deal type
PDT_ID NUMBER

Financial product identifier
ASSIGNABLE_YN VARCHAR2 (3)
Assignable yes no flag. This determines whether contract can be securitized or not
STS_CODE VARCHAR2 (30) Yes Contract status code
START_DATE DATE

ontract effective from date
END_DATE DATE

Contract effective to date
OPERATING_UNIT NUMBER
Yes Contract operatign unit
CURRENCY_CODE VARCHAR2 (15)
Currency code
AUTHORING_ORG_ID NUMBER
Yes Operating unit identifier
TAX_OWNER VARCHAR2 (450)
Contract tax owner
KLE_ID NUMBER

Financial asset line identifier
ASSET_ID NUMBER

Fixed asset identifier
ASSET_NUMBER VARCHAR2 (15)
Asset number
MODEL_NUMBER VARCHAR2 (40)
Model number
MANUFACTURER_NAME VARCHAR2 (360)
Manufacturer name
ITEM_ID1 NUMBER

Financial asset inventory item identifier
VENDOR_ID1 NUMBER

Supplier identifier
OEC NUMBER

Original equipment cost for the financial asset
RESIDUAL_PERCENTAGE NUMBER (5)
Residual percent for the financial asset
STY_ID NUMBER
Yes Stream type identifier
STREAM_TYPE_CODE VARCHAR2 (150) Yes Securitized stream type code
STREAM_TYPE_NAME VARCHAR2 (150) Yes Securitized Stream type name
STREAM_TYPE_SUBCLASS VARCHAR2 (30)
Stream type subclass
STREAM_SAY_CODE VARCHAR2 (30) Yes Stream type status code
STREAM_ACTIVE_YN VARCHAR2 (3) Yes Stream active yes no flag
STREAM_ELEMENT_DUE_DATE DATE
Yes Stream element due date
STREAM_ELEMENT_AMOUNT NUMBER
Yes Stream element amount
STREAM_ELEMENT_DATE_BILLED DATE

Date on which stream element was billed
PAYMENT_FREQ VARCHAR2 (80) Yes Payment frequenct
STM_ID NUMBER
Yes Unique identifier for streams
Query Text

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


SELECT CUST_OBJECT1_ID1
,      LESSEE
,      SIC_CODE
,      DNZ_CHR_ID
,      CONTRACT_NUMBER
,      PRE_TAX_YIELD
,      BOOK_CLASSIFICATION
,      PDT_ID
,      ASSIGNABLE_YN
,      STS_CODE
,      START_DATE
,      END_DATE
,      OPERATING_UNIT
,      CURRENCY_CODE
,      AUTHORING_ORG_ID
,      TAX_OWNER
,      KLE_ID
,      ASSET_ID
,      ASSET_NUMBER
,      MODEL_NUMBER
,      MANUFACTURER_NAME
,      ITEM_ID1
,      VENDOR_ID1
,      OEC
,      RESIDUAL_PERCENTAGE
,      STY_ID
,      STREAM_TYPE_CODE
,      STREAM_TYPE_NAME
,      STREAM_TYPE_SUBCLASS
,      STREAM_SAY_CODE
,      STREAM_ACTIVE_YN
,      STREAM_ELEMENT_DUE_DATE
,      STREAM_ELEMENT_AMOUNT
,      STREAM_ELEMENT_DATE_BILLED
,      PAYMENT_FREQ
,      STM_ID
FROM APPS.OKL_POOL_SRCH_PAYFREQ_V;

Dependencies

[top of page]

APPS.OKL_POOL_SRCH_PAYFREQ_V references the following:

SchemaAPPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
ViewOKL_POOL_ASSETS_UV
ViewOKL_POOL_CONTRACTS_UV
ViewOKL_POOL_CUSTOMERS_UV
ViewOKL_POOL_STREAMS_PAY_UV

APPS.OKL_POOL_SRCH_PAYFREQ_V is not referenced by any database object