DBA Data[Home] [Help]

APPS.CZ_LOGIC_GEN dependencies on CZ_ITEM_PROPERTY_VALUES

Line 811: FROM cz_item_property_values

807:
808: IF(l_tab.COUNT = 0 AND p_item_id IS NOT NULL)THEN
809:
810: SELECT NVL(TO_CHAR(property_num_value), property_value) BULK COLLECT INTO l_tab
811: FROM cz_item_property_values
812: WHERE property_id = p_property_id
813: AND item_id = p_item_id
814: AND deleted_flag = FLAG_NOT_DELETED;
815: