定义

FND_KEY_FLEX.DEFINE(BLOCK           => 'LINES',
                          FIELD           => 'ACCOUNTING_FLEXFIELD',
                          APPL_SHORT_NAME => 'SQLGL',
                          CODE            => 'GL#',
                          NUM             => TO_CHAR(GL_ACCESS_SET.COA_ID),
                          DESCRIPTION     => 'ACCOUNTING_FLEX_DESC',
                          ID              => 'CODE_COMBINATION_ID',
                          VALIDATE        => 'FULL',
                          VDATE           => ':HEADER.DEFAULT_EFFECTIVE_DATE',
                          COPY            => 'LINES.ACCOUNT_NUM\\nGL_ACCOUNT\\0' ||
                                             'WORLD.DEFAULT_BALANCING\\nGL_BALANCING',
                          DERIVED         => 'LINES.ACCOUNT_TYPE\\nGL_ACCOUNT_TYPE\\0' ||
                                             'LINES.CONTROL_ACCOUNT_SOURCE\\nGL_CONTROL_ACCOUNT',
                          REQUIRED        => 'N',
                          ALLOWNULLS      => 'Y',
                          READ_ONLY       => 'Y',
                          USEDBFLDS       => 'N',
                          QUERY_SECURITY  => 'Y',
                          WHERE_CLAUSE    => 'summary_flag != ''Y''');

说明

WHERE_CLAUSE： 在确认时才会验证这个条件