Oracle rcv_transactions transaction_type

最新推荐文章于 2024-05-28 15:13:18 发布

转载最新推荐文章于 2024-05-28 15:13:18 发布 · 2.3k 阅读

EBS PO 专栏收录该内容

8 篇文章

订阅专栏

本文详细列举了不同交易类型与目的地类型的组合方式，并说明了这些操作对库存的影响情况。具体包括：CORRECT到RECEIVING不减库存；CORRECT到INVENTORY减库存；RETURNTORECEIVING减库存；RETURNTOVENDOR不减库存；ACCEPT和REJECT不影响库存。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> select distinct(transaction_type||' '||destination_type_code) FROM apps.rcv_transactions;

(TRANSACTION_TYPE||''||DESTINA
------------------------------------------------------
ACCEPT    RECEIVING
CORRECT    EXPENSE
CORRECT    INVENTORY
CORRECT    RECEIVING
CORRECT    SHOP FLOOR
DELIVER    EXPENSE
DELIVER    INVENTORY
DELIVER    SHOP FLOOR
RECEIVE    RECEIVING
REJECT    RECEIVING
RETURN TO RECEIVING    EXPENSE
RETURN TO RECEIVING    INVENTORY
RETURN TO RECEIVING    RECEIVING
RETURN TO RECEIVING    SHOP FLOOR
RETURN TO VENDOR    RECEIVING
TRANSFER    RECEIVING