EBS PO发运匹配审批层(INVOICE_MATCHING)

研究了下订单发运行上的匹配审批层(INVOICE_MATCHING)，想找出对应后台表哪个字段。

一番追查，终于在pll中找出如下代码：

IF ((x_Receipt_Required_Flag = ‘N‘ OR x_Receipt_Required_Flag IS NULL) AND
(x_Inspection_Required_Flag = ‘N‘ OR
x_Inspection_Required_Flag IS NULL)) THEN
Copy(‘2WAY‘, ‘po_shipments.invoice_matching‘);
ELSIF (x_Receipt_Required_Flag = ‘Y‘ AND
(x_Inspection_Required_Flag = ‘N‘ OR
x_Inspection_Required_Flag IS NULL)) THEN
Copy(‘3WAY‘, ‘po_shipments.invoice_matching‘);
ELSIF (x_Receipt_Required_Flag = ‘Y‘ AND
x_Inspection_Required_Flag = ‘Y‘) THEN
Copy(‘4WAY‘, ‘po_shipments.invoice_matching‘);
/* Bug 475621 ecso 4/22/97
* Handle other values; copy null
*/
ELSE
Copy(‘‘, ‘po_shipments.invoice_matching‘);
END IF;

如此得知：

plla(po_line_locations_all)中，receipt_required_flag(R)和inspection_required_flag(I)的值共同决定了该选项。

本文出自 “路漫漫其修远兮…” 博客，请务必保留此出处http://baser.blog.51cto.com/4153192/1394196

EBS PO发运匹配审批层(INVOICE_MATCHING),布布扣,bubuko.com

EBS PO发运匹配审批层(INVOICE_MATCHING)

原文：http://baser.blog.51cto.com/4153192/1394196