fnd_key_flex.define(BLOCK           => 'BLOCKNAME'
                   ,FIELD           => 'INVENTORY_ITEM'
                   ,CODE            => 'MSTK'
                   ,APPL_SHORT_NAME => 'INV'
                   ,ID              => 'INVENTORY_ITEM_ID'
                   ,REQUIRED        => 'N'
                   ,NUM             => '101'
                   ,VALIDATE        => 'FULL'
                   ,USEDBFLDS       => 'N'
                   ,WHERE_CLAUSE    => 'segment1 like ''%''' || :blockname.inv_item_like || '''%'' and inventory_item_status_code = ''Active'''
                   ,DINSERT         => 'N'
                   ,NO_COMBMSG      => 'FLEX-COMBINATION DISABLED'
                   --,ALLOWNULLS      => 'Y'
                   --,INSERTABLE      => 'ALL'
                   --,UPDATEABLE      => 'ALL'
                   ,LONGLIST        => 'Y');