VIEW: APPS.OKL_AM_RESIDUAL_VALUE_WD_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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