Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_RESIDUAL_VALUE_WD_UV |
SELECT KHR.ID KHR_ID
, KHR.CONTRACT_NUMBER
, KHR.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, KLE.ID KLE_ID
, KLE.NAME ASSET_NUMBER
, KLE.ITEM_DESCRIPTION ITEM_DESCRIPTION
, MOD.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, MCG.DESCRIPTION CATEGORY_DESCRIPTION
, KLE.RESIDUAL_VALUE RESIDUAL_VALUE
, KHR.PDT_ID PDT_ID
, PDT.NAME PRODUCT_NAME
, PDT.DESCRIPTION PRODUCT_DESCRIPTION
, KHR.CURRENCY_CODE CURRENCY_CODE
, KHR.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, KHR.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, KHR.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, KHR.SCS_CODE KHR_SCS_CODE
, KLE.STS_CODE KLE_STS_CODE
, KHR.AUTHORING_ORG_ID ORG_ID
FROM OKL_K_LINES_FULL_V KLE
, OKX_MODEL_LINES_V MOD
, OKL_K_HEADERS_FULL_V KHR
, OKL_PRODUCTS_V PDT
, MTL_SYSTEM_ITEMS_B MSI
, MTL_ITEM_CATALOG_GROUPS_V MCG
WHERE MOD.PARENT_LINE_ID = KLE.ID
AND KLE.CHR_ID = KHR.ID
AND KHR.PDT_ID = PDT.ID
AND KHR.INV_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MOD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ITEM_CATALOG_GROUP_ID = MCG.ITEM_CATALOG_GROUP_ID(+)
AND KLE.STS_CODE = 'BOOKED'
AND KLE.RESIDUAL_VALUE > 0