[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mo.line_id mo_line_id,
h.order_number ,
d.line_id order_line_id,
mo.quantity_detailed,
mo.quantity_delivered,
NVL( (-1) * sum(itp.trans_qty), 0) trans_qty,
NVL( (-1) * sum(itp.trans_qty2), 0) trans_qty2
FROM ic_txn_request_lines mo,
oe_order_headers_all h,
oe_order_lines_all d,
ic_tran_pnd itp
WHERE itp.line_id(+) = mo.txn_source_line_id
AND mo.txn_source_line_id = d.line_id
AND d.header_id = h.header_id
AND itp.doc_type(+) = 'OMSO'
AND itp.staged_ind(+) = 1
AND itp.delete_mark(+) = 0
AND NVL(mo.quantity_delivered, 0) > NVL(mo.quantity_detailed, 0)
AND mo.line_status IN (3, 7)
GROUP BY mo.line_id, h.order_number, d.line_id, mo.quantity_detailed, mo.quantity_delivered
ORDER by h.order_number;
SELECT mol.line_id mo_line_id,
soh.order_number ,
sol.line_id order_line_id,
moh.request_number
FROM ic_txn_request_lines mol,
ic_txn_request_headers moh,
oe_order_headers_all soh,
oe_order_lines_all sol
WHERE moh.header_id = mol.header_id
AND soh.header_id = sol.header_id
AND sol.line_id = mol.txn_source_line_id
AND NVL(mol.quantity_delivered, 0) = NVL(mol.quantity_detailed, 0)
AND NVL(mol.quantity_detailed, 0) = NVL(mol.quantity, 0)
AND mol.line_status IN (3, 7)
ORDER by moh.request_number;
UPDATE ic_txn_request_lines
SET quantity_delivered = mo_line.trans_qty,
secondary_quantity_delivered = mo_line.trans_qty2,
quantity_detailed = mo_line.trans_qty,
secondary_quantity_detailed = mo_line.trans_qty2
WHERE line_id = mo_line.mo_line_id;
UPDATE ic_txn_request_lines
SET line_status = 5
WHERE line_id = mo_line_stat.mo_line_id;