EBS Po_Requisition_Lines_All.REQS_IN_POOL_FLAG字段说明

最近遇到Po_Requisition_Lines_All.REQS_IN_POOL_FLAG被修改为空的情况，实际上这个pr还没有被转成po，在metalink上查了一下这个字段的说明

P=PR已经被审批并且转为了PO，有对应的PO订单；

Y=可以转换为PO，但是还未转换成PO;

N=行被取消；

以下为metalink原文 Doc ID 2481786.1

This field is a flag to indicate if the requisitions are available for purchase order creation :

• P = It is approved and there is a purchase order
• Y = It is in the Pool to be converted into a PO (Is available in the Document Builder)
• N = It is not in the Pool to be converted into a PO (ie: Line is Canceled)

The POR_REQUISITION_LINES stores information about requisition lines. The user needs one row for each requisition line you create.

Each row contains the line number, item number, item category, item description, need-by date, deliver-to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisition line.

PARENT_REQ_LINE_ID contains the REQUISITION_LINE_ID from the original requisition line if user has exploded or multisourced this requisition line.

POR_REQUISITION_LINES is one of three tables storing requisition information. This table corresponds to the Lines region of the Requisitions window.