Query to check RTP stuck Records in R12



 SELECT RTI.*, rti.DESTINATION_TYPE_CODE,
 rti.interface_transaction_id   --           'interface_transaction_id'
, rhi.header_interface_id       --                 'header_interface_id'
, mp.ORGANIZATION_CODE         --                  'Org'
, rti.source_document_code     --                  'Type'
, pha.segment1                --                   'PO Number'
, pla.line_num                --                   'PO Line'
, to_char(rti.transaction_date, 'dd-MON-yyyy')  -- 'Transaction Date'
, rti.transaction_type      
, rti.PROCESSING_MODE_CODE 
, rti.processing_status_code
, rhi.processing_status_code 
, to_char(rti.creation_date, 'dd-MON-yyyy')  creation_date
, rti.quantity
, msi.segment1                              --     'Item'
, msi.item_type                            --      'Item Type'
, rti.item_description
, poh.error_message
, replace(poh.error_message,chr(10),' ') ,msi.organization_id--,poh.*
--, replace(pot.error_message,chr(10),' ')
FROM   po.po_interface_errors         poh
,      po.po_interface_errors         pot
,      po.rcv_transactions_interface  rti
,      po.rcv_headers_interface       rhi 
,      inv.mtl_parameters             mp
,      po.po_headers_all              pha
,      po.po_lines_all                pla
,      inv.mtl_system_items_b         msi
WHERE 1=1
AND   rti.header_interface_id      = rhi.header_interface_id   (+)
AND   rti.interface_transaction_id = pot.interface_transaction_id (+)
AND   rhi.header_interface_id      = poh.interface_header_id (+)
--    mapping to PO
AND   rti.po_header_id = pha.po_header_id AND pha.org_id=8527
AND   rti.po_header_id = pla.po_header_id
AND   rti.po_line_id = pla.po_line_id 
--    mapping to item
AND   mp.organization_id = msi.organization_id AND msi.organization_id=106
AND   rti.item_id = msi.inventory_item_id
 and   pha.segment1='1008007890' --in ('20231192' ,'20230863')-- PUT PO NUMBER HERE
--AND pla.line_num IN (14,57)
Order by mp.ORGANIZATION_CODE, pha.segment1, pla.line_num

1 Comments :

Multi Channel Inventory Management Software | ERP GOLD
ERP Gold’s Multichannel Inventory management software to assist you track orders, control your inventory, create shipments for all your order ,raise buying and much more.
Main Features of Our Multi Channel Inventory Software is integration with leading marketplace and other channels to make your operation convenient.
EPR Gold’s Multi Channel Selling Software can easily be integrated:
Ebay, Amazon, wallmart, Bestbuy, wish, houzz. Fulfillment by amazon, facebook,
E-commerce Channel Integeration like magento, shopify, woocommerce, nopcommerce, and many more.

Below are the features that our software encompasses:
Manage Inventory
Integrate with current barcode systems or manually administer your master inventory list. It is an Easy Inventory Management software solution.
• Categorization of inventory
• Generating Important Reports with item valuation
• Inventory Import feature(CSV)
• Management of inventory with current barcode system
Additional Features that ERP Gold Inventory software offers :
• It is cloud based with SSL connection
• Business Operation Integration
• Top Level Security with SSL
• Adaptability with fast deployment
For more information, visit our website : https://www.erp.gold/multi-channel-inventory-management-software/
Or Get in touch with us: 1-888-334-4472
Address: Suite 183411, Shelby TWP, MI 48318
Email us: support@erp.gold

Reply

Post a Comment