DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_ITEM_PROPERTY_VALUES

Line 800: FROM cz_item_property_values

796:
797: IF(l_tab.COUNT = 0 AND p_item_id IS NOT NULL)THEN
798:
799: SELECT NVL(TO_CHAR(property_num_value), property_value) BULK COLLECT INTO l_tab
800: FROM cz_item_property_values
801: WHERE property_id = p_property_id
802: AND item_id = p_item_id
803: AND deleted_flag = FLAG_NOT_DELETED;
804: