VIEW: APPS.OKL_OR_AS_ADDON_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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