Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH old_stock AS (
- SELECT A.qty_realization, A.product_id, f_get_product_code(A.product_id) AS old_product_code, f_get_product_name(A.product_id) AS old_product_name
- FROM in_inventory_item A
- INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
- WHERE B.doc_no = 'ADJSQ/1605/000142' AND A.qty_realization < 0
- )
- SELECT A.product_id AS new_product_id, C.product_id AS old_product_id, f_get_product_code(A.product_id) AS new_product_code, C.old_product_code,
- f_get_product_name(A.product_id) AS new_product_name, C.old_product_name,
- A.qty_realization AS new_qty, C.qty_realization AS old_qty
- FROM in_inventory_item A
- INNER JOIN in_inventory B ON A.inventory_id = B.inventory_id
- INNER JOIN old_stock C ON C.qty_realization = (-1 * A.qty_realization)
- WHERE B.doc_no = 'ADJSQ/1605/000142' AND A.qty_realization > 0
- --OLD
- SELECT B.doc_type_id, B.doc_no, B.doc_date, A.gl_amount, *
- FROM gl_journal_trx_item A
- INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
- WHERE A.product_id IN (41058, 41057, 41056, 41055, 41054)
- AND A.gl_amount = 0
- ORDER BY A.product_id, B.doc_date, B.doc_no
- --NEW
- SELECT B.doc_type_id, B.doc_no, B.doc_date, A.gl_amount, *
- FROM gl_journal_trx_item A
- INNER JOIN gl_journal_trx B ON A.journal_trx_id = B.journal_trx_id
- WHERE product_id IN (43520, 43519, 43518, 43517, 43516)
- AND A.gl_amount = 0
- AND A.sign_journal = 'D'
- ORDER BY A.product_id, B.doc_date, B.doc_no
- /*
- MQ19 - 15873.000000000000
- MQ17 - 15873.000000000000
- MQ18 - 15873.000000000000
- MQ16 - 15873.000000000000
- */
- SELECT f_get_product_code(product_id), qty, gl_amount, gl_amount/qty FROM gl_journal_trx_item WHERE journal_trx_id = 691714 ORDER BY ABS(qty)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement