How to Add more addition colum in list using fnd_key_flex.define
Hi ,
now I apply function FND_KEY_FLEX.DEFINE on When-new-form-instance to retrieve GL segment value with filtering security rule (Oracle Forms Version : 10.1.2.3.0) as below script:
------------------------------------------------------------------------------------------------------------------
FND_KEY_FLEX.DEFINE (
BLOCK => 'EXP_LINE',
FIELD => 'AC_CC_NO',
DESCRIPTION => '',
DISPLAYABLE => '3',--'ALL',
ALLOWNULLS => 'Y',
APPL_SHORT_NAME => 'SQLGL',
CODE => 'GL#',
ID => 'CODE_COMBINATION_CCID',
NUM => TO_CHAR (:parameter.p_coa_id),
VRULE => --'\\nSUMMARY_FLAG\\nI\\nAPPL=SQLAP;NAME=AP_NO_PARENT_SEGMENT\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nI\\nAPPL=SQLAP;NAME=AP_POSTING_NOT_ALLOWED\\nY',
'\\nSUMMARY_FLAG\\nI\\nAPPL=SQLGL;NAME=GL_NO_PARENT_SEGMENT_ALLOWED\\nN\\0GL_GLOBAL\\nDETAIL_POSTING_ALLOWED\\nE\\nAPPL=SQLGL;NAME=GL_VRULE_POSTING\\nN',