[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_PRODUCTS_V

Object Details

Object Name:	OKL_PRODUCTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_PRODUCTS_V
Subobject Name:
Status:	VALID

View Type

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

DEFINITION
Products are defined to characterize the basics of a contract. The characteristics for this are defined from the following:
- Assign a product template to inherit basic characteristics
- Assign a value for each of the product qualities assigned to the product template
- Assign accounting template set to define the accounting rules to be used for the contract that uses this product
- Assign the options and also their corresponding valid option values for later assignment during the contract authoring process
EXAMPLE
Operating Lease, Capital Lease - Tax, Capital Lease - Non Tax etc.
MISCELLANEOUS
To reduce the data setup during the contract authoring time, all the static information is grouped and setup one time as Product.
The setup for Product includes the following:
Template Quality and Values
Product Quality and Values
Option and Values
Product Template
Product

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      AES_ID
,      PTL_ID
,      NAME
,      DESCRIPTION
,      LEGACY_PRODUCT_YN
,      FROM_DATE
,      VERSION
,      TO_DATE
,      REPORTING_PDT_ID
,      PRODUCT_STATUS_CODE
,      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
FROM APPS.OKL_PRODUCTS_V;

Dependencies

[top of page]

APPS

OKL_PRODUCTS

APPS

IEX_WRITEOFFOBJ_PUB - show dependent code

OKL_ACCOUNTING_UTIL - show dependent code

OKL_ACCOUNT_DIST_PVT - show dependent code

OKL_ACCRUAL_SEC_PVT - show dependent code

OKL_ACTIVATE_ASSET_PVT - show dependent code

OKL_ACTIVATE_ASSET_PVT - show dependent code

OKL_AM_AMORTIZE_PVT - show dependent code

OKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code

OKL_AM_LEASE_TRMNT_PVT - show dependent code

OKL_AM_OFF_LSE_TRX_UPD_UV

OKL_AM_RESIDUAL_VALUE_WD_UV

OKL_AM_SALVAGE_VALUE_WD_UV

OKL_ASE_PVT - show dependent code

OKL_CONTRACT_BOOK_PVT - show dependent code

OKL_CONTRACT_PVT - show dependent code

OKL_CONTRACT_STATUS_PVT - show dependent code

OKL_CREATE_STREAMS_PVT - show dependent code

OKL_DEAL_CREATE_PUB - show dependent code

OKL_DEAL_CREATE_PUB - show dependent code

OKL_DEAL_CREAT_PVT - show dependent code

OKL_DEAL_CREAT_PVT - show dependent code

OKL_ETH_PVT - show dependent code

OKL_EVERGREEN_BILLING_PVT - show dependent code

OKL_EXPENSE_STREAMS_PVT - show dependent code

OKL_GENERATE_ACCRUALS_PVT - show dependent code

OKL_GENERATE_ACCRUALS_PVT - show dependent code

OKL_INVESTOR_INVOICE_DISB_PVT - show dependent code

OKL_ISG_UTILS_PVT - show dependent code

OKL_ISG_UTILS_PVT - show dependent code

OKL_KBK_APPROVALS_WF - show dependent code

OKL_K_RATE_PARAMS_PVT - show dependent code

OKL_K_RATE_PARAMS_PVT - show dependent code

OKL_LA_JE_PVT - show dependent code

OKL_LA_STREAM_PVT - show dependent code

OKL_LA_STREAM_PVT - show dependent code

OKL_LA_VALIDATION_UTIL_PVT - show dependent code

OKL_LOSS_PROV_PVT - show dependent code

OKL_MAINTAIN_FEE_PVT - show dependent code

OKL_MISC_TRANS_PVT - show dependent code

OKL_MLA_CREATE_UPDATE_PUB - show dependent code

OKL_MULTIGAAP_ENGINE_PVT - show dependent code

OKL_MULTI_GAAP_PVT - show dependent code

OKL_MULTI_GAAP_PVT - show dependent code

OKL_OPEN_INTERFACE_PVT - show dependent code

OKL_PDT_PVT - show dependent code

OKL_PDT_PVT - show dependent code

OKL_PIT_PVT - show dependent code

OKL_PON_PVT - show dependent code

OKL_POPULATE_PRCENG_RST_PUB - show dependent code

OKL_PQV_PVT - show dependent code

OKL_PRICING_PVT - show dependent code

OKL_PRICING_UTILS_PVT - show dependent code

OKL_PROCESS_STREAMS_PVT - show dependent code

OKL_PRODUCTS_UV

OKL_PSY_PVT - show dependent code

OKL_QA_DATA_INTEGRITY - show dependent code

OKL_QA_DATA_INTEGRITY - show dependent code

OKL_QTE_PVT - show dependent code

OKL_REPORT_GENERATOR_PVT - show dependent code

OKL_SEC_AGREEMENT_PVT - show dependent code

OKL_SEEDED_FUNCTIONS_PVT - show dependent code

OKL_SETUPDQUALITYS_PVT - show dependent code

OKL_SETUPOVERULES_PVT - show dependent code

OKL_SETUPPDTTEMPLATES_PVT - show dependent code

OKL_SETUPPMVALUES_PVT - show dependent code

OKL_SETUPPOPTIONS_PVT - show dependent code

OKL_SETUPPOVALUES_PVT - show dependent code

OKL_SETUPPQVALUES_PVT - show dependent code

OKL_SETUPPRODUCTS_PVT - show dependent code

OKL_SETUPPRODUCTS_PVT - show dependent code

OKL_SETUPPSTYPES_PVT - show dependent code

OKL_SETUPTQUALITYS_PVT - show dependent code

OKL_SPLIT_ASSET_PVT - show dependent code

OKL_STREAMS_UTIL - show dependent code

OKL_STREAMS_WF - show dependent code

OKL_STREAM_BILLING_PVT - show dependent code

OKL_STREAM_GENERATOR_PVT - show dependent code

OKL_STREAM_MIGRATION_PVT - show dependent code

OKL_STRM_TMPT_CONTRACTS_UV

OKL_STRM_TMPT_CONTRACT_UV

OKL_STRM_TMPT_FULL_UV

OKL_STRM_TMPT_LINES_UV

OKL_STRM_TMPT_PRC_PARAMS_UV

OKL_STRM_TMPT_PRIMARY_UV

OKL_TCN_PVT - show dependent code

OKL_TRANS_PRICING_PARAMS_PVT - show dependent code

OKL_VR_DOCUMENT_PVT - show dependent code