Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select f_get_ou_code(A.ou_id) ou,f_get_warehouse_name(A.warehouse_id) warehouse,
- f_get_product_code(A.product_id) code,f_get_product_name(A.product_id) nama ,A.qty
- from in_summary_monthly_qty A
- inner join m_product B On A.product_id = B.product_id
- WHERE doc_type_id = -99
- and date_year_month = '202111'
- and warehouse_id = 22
- AND b.product_code IN (
- 'BST 251',
- 'DLP 002',
- 'DLP 081',
- 'DLP 169',
- 'DLP 172',
- 'DLP 173',
- 'DLP 174',
- 'EFO 003',
- 'FAL 011',
- 'FIL 042',
- 'GTL 002',
- 'GTL 003',
- 'GTL 005',
- 'GTR 164',
- 'HKK 061',
- 'OLI 070'
- )
- order by code asc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement