Cannot import PR from MRP
(1) i used the SQL:
MSI.SEGMENT1,MSI.DESCRIPTION,
msi.item_type,
PRI.QUANTITY,
PRI.NEED_BY_DATE,
PRI.INTERFACE_SOURCE_CODE,
interface_transaction_id Transaction_Id
, column_name Column_Name
, error_message Error_Message
from PO_REQUISITIONS_INTERFACE_ALL PRI,
po_interface_errors pie,
MTL_SYSTEM_ITEMS_B MSI
WHERE 1=1
and (pie.interface_transaction_id = pri.transaction_id )
AND MSI.INVENTORY_ITEM_ID=PRI.ITEM_ID
AND MSI.ORGANIZATION_ID=207
AND PRI.INTERFACE_SOURCE_CODE='MRP'
out:This item is missing a list price in the item master setup window. Please enter a list price greater than zero (0) in the item master