Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin;
- select
- sl_get_sales_order_list_for_inquiry_so_rabat(
- 'sts123',--session
- 11,--tenant
- 1000038, --user
- 1000007, --role
- '20211206103600', --datetime,
- -99, --ou
- '20211001', -- doc date from
- '20211031',--doc date to
- 'SOPB-21-2110-000066', --so no
- '', --salesman code name
- '',-- customer code name
- -99, --warehouse
- '', --product code name
- '', -- rgto no
- '20211001', -- do date from
- '20211031',--do date to
- '',--do no
- '', --dkb no
- '', -- resi no
- '', --si no
- '', --dor no
- 'ALL', --stat so
- 'ALL', --cetak so
- 'ALL', --stat rgto
- 'ALL', --stat do
- 'ALL', --stat dkb
- 'ALL', --stat invoice
- 'ALL', --stat dor,
- 25, --limit
- 0 -- offset
- );
- fetch all "refDetail";
- --rollback
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement