1.the quantity in the requisition interface is 1.1
select pri.quantity,pri.transaction_id,pri.destination_type_code,pri.authorization_status,
pri.autosource_flag,pri.req_number_segment1,pri.item_id,pri.org_id,pri.source_subinventory
from po.po_requisitions_interface_allpri
where pri.transaction_id=194849
QUANTITY
TRANSACTION_ID
DESTINATION_TYPE_CODE
AUTHORIZATION_STATUS
AUTOSOURCE_FLAG
REQ_NUMBER_SEGMENT1
ITEM_ID
ORG_ID
SOURCE_SUBINVENTORY
1.1
194849
INVENTORY
INCOMPLETE
P
009999
297900
89
GXCPH1
2.after submit request:'requisition import'
I find the quantity changed to 2.
SELECT RL.QUANTITY,RL.ITEM_ID,RL.SOURCE_SUBINVENTORY,RL.ORG_ID
FROM PO_REQUISITION_LINES_ALL RL,PO_REQUISITION_HEADERS_ALL RH
WHERE RL.REQUISITION_HEADER_ID=RH.REQUISITION_HEADER_ID
AND RH.SEGMENT1='009999'
QUANTITY
ITEM_ID
SOURCE_SUBINVENTORY
ORG_ID
2
297900
GXCPH1
89 |