EBS中的退货 原因

小xiaoL

oe_reasons是个表，可以和订单行表做关联

OwenCO

小xiaoL 发表于 2016-7-14 10:25
oe_reasons是个表，可以和订单行表做关联

看了  这个表里面并没有存中文的退货原因描述

Benin

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

OwenCO

Benin 发表于 2016-7-14 14:59
SELECT MEANING, LOOKUP_CODE, DESCRIPTION
  FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'CREDIT_MEMO_REASO ...

哦 查到了 谢谢大神