Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE tt_in_summary_monthly_amount_remain
- SET summary_monthly_product_id = (
- SELECT MAX(A.summary_monthly_product_id)
- FROM tt_in_summary_monthly_product A
- WHERE A.session_id = pSessionId AND
- tt_in_summary_monthly_amount_remain.session_id = A.session_id AND
- tt_in_summary_monthly_amount_remain.date_year_month = A.date_year_month AND
- tt_in_summary_monthly_amount_remain.tenant_id = A.tenant_id AND
- tt_in_summary_monthly_amount_remain.ou_bu_id = A.ou_bu_id AND
- tt_in_summary_monthly_amount_remain.product_id = A.product_id AND
- A.doc_type_id IN (311,431,526,521,413,313,560,537) AND
- A.flg_amount = 'MONTHLY_AVG')
- WHERE session_id = pSessionId AND qty = 0 AND gl_amount <> 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement