ECC iStore, iStore Search

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Minisite Id, Section Id, Organization Id, Inventory Item Id, Item Code, Item Retail Price, Item Your Price, Item Retail Price Range, Item Price Range ...
Imported from Enterprise Command Center
Dataset Key: ibe-search
Query Procedure: IBE_ECC_UTIL_PVT.get_ecc_data_load_info
Security Procedure: ibe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
select
x.*
from
(
SELECT * FROM
		(SELECT ECC_SPEC_ID,
    MINISITE_ID,
    MINISITE_NAME,
    MINISITE_DESCRIPTION,
    SECTION_ID,
    SECTION_NAME,
    SECTION_DESCRIPTION,
    ORGANIZATION_ID,
    INVENTORY_ITEM_ID,
    ITEM_CODE,
    ITEM_DESCRIPTION,
    ITEM_LONG_DESCRIPTION,
    ITEM_RETAIL_PRICE,
    ITEM_YOUR_PRICE,
    ITEM_RETAIL_PRICE_RANGE,
    ITEM_PRICE_RANGE,
    YOUR_PRICE_RANGE,
    SHIPPABLE_ITEM_FLAG,
    CUSTOMER_ORDER_FLAG,
    INTERNAL_ORDER_FLAG,
    SERVICE_ITEM_FLAG,
    INVENTORY_ITEM_FLAG,
    PURCHASING_ENABLED_FLAG,
    CUSTOMER_ORDER_ENABLED_FLAG,
    INTERNAL_ORDER_ENABLED_FLAG,
    RETURNABLE_FLAG,
    ITEM_TYPE,
    ITEM_LENGTH,
    ITEM_WIDTH,
    ITEM_HEIGHT,
    ITEM_WEIGHT,
    WEIGHT_UOM_CODE,
    WEIGHT,
    ITEM_VOLUME,
    VOLUME_UOM_CODE,
    VOLUME,
    MINISITE_ID_TEXT,
    SECTION_ID_TEXT,
    INVENTORY_ITEM_ID_TEXT,
    ORGANIZATION_ID_TEXT,
    PRICE_LIST_ID,
    ITEM_PRIMARY_UOM_CODE,
    CURRENCY_CODE,
    ISCONFIG,
    ISREADYTOBUY,
    ITEM_RETAIL_PRICE_DISPLAY,
    ITEM_YOUR_PRICE_DISPLAY,
    PARTY_ID,
    CUST_ACCT_ID,
    CROSS_REFERENCE_TYPE,
    CROSS_REFERENCE_NUMBER,
    CROSS_REFERENCE_DESCRIPTION,
    CUSTOMER_ITEM_NUMBER,
    CUSTOMER_ID,
    CUSTOMER_ITEM_DESCRIPTION,
    ECC_LAST_UPDATE_DATE,
    LANGUAGE_CODE,
    CONTENT_ITEM_KEY,
     OBJECT_ID,
     IBE_CUSTOM_ATTRIBUTE1,
     IBE_CUSTOM_ATTRIBUTE2,
     IBE_CUSTOM_ATTRIBUTE3,
     IBE_CUSTOM_ATTRIBUTE4,
     IBE_CUSTOM_ATTRIBUTE5,
     IBE_CUSTOM_ATTRIBUTE6,
     IBE_CUSTOM_ATTRIBUTE7,
     IBE_CUSTOM_ATTRIBUTE8,
     IBE_CUSTOM_ATTRIBUTE9,
     IBE_CUSTOM_ATTRIBUTE10,
     IBE_CUSTOM_ATTRIBUTE11,
     IBE_CUSTOM_ATTRIBUTE12,
     IBE_CUSTOM_ATTRIBUTE13,
     IBE_CUSTOM_ATTRIBUTE14,
     IBE_CUSTOM_ATTRIBUTE15,
     ISLIVEPRICE,
     ISOFFLINEPRICE
		FROM IBE_ECC_SEARCH_V )PIVOT
		(max(MINISITE_NAME) as MINISITE_NAME,
		 max(MINISITE_DESCRIPTION) as MINISITE_DESCRIPTION,
		 max(SECTION_NAME) as SECTION_NAME,
		 max(SECTION_DESCRIPTION) as SECTION_DESCRIPTION,
		 max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION,
		 max(ITEM_LONG_DESCRIPTION) as ITEM_LONG_DESCRIPTION,
         max(ITEM_RETAIL_PRICE_DISPLAY) as ITEM_RETAIL_PRICE_DISPLAY,
         max(ITEM_YOUR_PRICE_DISPLAY) as ITEM_YOUR_PRICE_DISPLAY
		 for LANGUAGE_CODE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code
x.organization_id in (select mp.organization_id from mtl_parameters mp where mp.organization_code=:organization_code)
LOV