View: OKL_OR_AS_ADDON_V

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_OR_AS_ADDON_V

View Text

SELECT CLEB_ADDON.ID CLEV_ADDON_ID
, CLEB_ADDON.DNZ_CHR_ID
, CLEB_ADDON.PRICE_UNIT
, CLEB_ADDON.CLE_ID
, CIM_ADDON.OBJECT1_ID1 INVENTORY_ITEM_ID
, CIM_ADDON.OBJECT1_ID2 INVENTORY_ORG_ID
, CIM_ADDON.JTOT_OBJECT1_CODE
, CIM_ADDON.NUMBER_OF_ITEMS
, MSIT.DESCRIPTION INVENTORY_ITEM_NAME
, KLE_ADDON.MANUFACTURER_NAME
, KLE_ADDON.MODEL_NUMBER
, KLE_ADDON.YEAR_OF_MANUFACTURE
, POV.VENDOR_NAME
, CPL_ADDON.ID CPL_ID
, CPL_ADDON.OBJECT1_ID1 VENDOR_ID
, CPL_ADDON.OBJECT1_ID2
, CPL_ADDON.RLE_CODE
, CLET_ADDON.COMMENTS NOTES
FROM OKL_K_LINES KLE_ADDON
, OKC_K_LINES_B CLEB_ADDON
, OKC_K_LINES_TL CLET_ADDON
, OKC_K_ITEMS CIM_ADDON
, OKC_LINE_STYLES_B LSE_ADDON
, MTL_SYSTEM_ITEMS_B MSIB
, MTL_SYSTEM_ITEMS_TL MSIT
, OKC_K_PARTY_ROLES_B CPL_ADDON
, PO_VENDORS POV
WHERE CLEB_ADDON.ID = KLE_ADDON.ID
AND CLEB_ADDON.ID = CLET_ADDON.ID
AND CLET_ADDON.LANGUAGE = USERENV('LANG')
AND CPL_ADDON.DNZ_CHR_ID(+) = CLEB_ADDON.DNZ_CHR_ID
AND CPL_ADDON.CLE_ID(+) = CLEB_ADDON.ID
AND CPL_ADDON.RLE_CODE(+) = 'OKL_VENDOR'
AND CPL_ADDON.CHR_ID IS NULL
AND CLEB_ADDON.LSE_ID = LSE_ADDON.ID
AND LSE_ADDON.LTY_CODE = 'ADD_ITEM'
AND CIM_ADDON.CLE_ID = CLEB_ADDON.ID
AND CIM_ADDON.DNZ_CHR_ID = CLEB_ADDON.DNZ_CHR_ID
AND CIM_ADDON.OBJECT1_ID1 = MSIB.INVENTORY_ITEM_ID
AND CIM_ADDON.OBJECT1_ID2 = MSIB.ORGANIZATION_ID
AND CIM_ADDON.JTOT_OBJECT1_CODE = 'OKX_SYSITEM'
AND MSIB.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID = MSIT.ORGANIZATION_ID
AND MSIT.LANGUAGE = USERENV('LANG')
AND POV.VENDOR_ID (+) = CPL_ADDON.OBJECT1_ID1

Columns