IFS Applications Oracle SQL Query Generator (Shop Orders, Stock, Orders)

SELECT order_no, release_no, sequence_no, part_no, contract, state,
       revised_qty_due, qty_complete, revised_due_date
FROM   shop_ord
WHERE  contract = 'SITE1'
AND    part_no = 'PN-48213'
AND    revised_due_date BETWEEN TO_DATE('2026-10-01', 'YYYY-MM-DD')
                         AND TO_DATE('2026-12-31', 'YYYY-MM-DD')
ORDER BY revised_due_date;

SELECT contract, part_no, location_no, lot_batch_no, serial_no,
       qty_onhand, qty_reserved
FROM   inventory_part_in_stock
WHERE  contract = 'SITE1'
AND    part_no = 'PN-48213'
AND    qty_onhand <> 0
ORDER BY location_no;

SELECT order_no, line_no, rel_no, line_item_no, catalog_no,
       buy_qty_due, qty_shipped, planned_due_date, state
FROM   customer_order_line
WHERE  contract = 'SITE1'
AND    catalog_no = 'PN-48213'
AND    planned_due_date BETWEEN TO_DATE('2026-10-01', 'YYYY-MM-DD')
                            AND TO_DATE('2026-12-31', 'YYYY-MM-DD')
ORDER BY planned_due_date;