請高手幫我解釋下面的script的作用,多謝
begin
SRW.REFERENCE(:P_LOC_STRUCT);
SRW.USER_EXIT ('FND FLEXSQL
CODE = "MTLL"
APPL_SHORT_NAME = "INV"
OUTPUT = "P_LOC_RANGE_FLEX"
MODE = "WHERE"
NUM = ":P_LOC_STRUCT"
TABLEALIAS = "MIL"
OPERATOR = "BETWEEN"
OPERAND1 = ":P_LOC_LO"
OPERAND2 = ":P_LOC_HI"');
exception
when srw.user_exit_failure then srw.message(120,'Failed in before report trigger, Locator where. ');
raise;
end;
begin
SRW.REFERENCE(:P_LOC_STRUCT);
SRW.USER_EXIT ('FND FLEXSQL
CODE = "MTLL"
APPL_SHORT_NAME = "INV"
OUTPUT = "P_LOC_RANGE_FLEX"
MODE = "WHERE"
NUM = ":P_LOC_STRUCT"
TABLEALIAS = "MIL"
OPERATOR = "BETWEEN"
OPERAND1 = ":P_LOC_LO"
OPERAND2 = ":P_LOC_HI"');
exception
when srw.user_exit_failure then srw.message(120,'Failed in before report trigger, Locator where. ');
raise;
end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/2830/viewspace-479848/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
稅金的處理問題，請高手支招
下一篇：
有哪位高手能幫我优化一下該sql
请登录后发表评论
登录
全部评论
