DBA Data[Home] [Help]

APPS.ICX_STORE_BATCH_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 84

        SELECT  ATTRIBUTE_LABEL_LONG,ATTRIBUTE_CODE, DISPLAY_VALUE_LENGTH
        FROM    AK_REGION_ITEMS_VL
        WHERE   REGION_CODE = p_region_code
        AND     (NODE_DISPLAY_FLAG = 'Y'
                 OR ATTRIBUTE_CODE = 'ICX_INVENTORY_ITEM_ID')
        ORDER BY DISPLAY_SEQUENCE;