销售订单退货原因对应的快码
在项目中,系统自带的退货原因不足以满足客户需求,需要我们手工增加。在界面上找到退货原因字段:
对应SQL:
SELECT MEANING, LOOKUP_CODE, DESCRIPTION
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'CREDIT_MEMO_REASON'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN (NVL(START_DATE_ACTIVE, SYSDATE)) AND
TRUNC(NVL(END_DATE_ACTIVE, SYSDATE))
ORDER BY MEANING;
界面: