Good morning, I would likie to know if there is a possibility to use two views/tables in Data Soursce Constructor?If yes, how to do this? I need to combine data from two different views and present it on one lobby object. I have alredy tried with adding two views in “View” box (separetad with “ , ” or “ ; ”) but it didn’t work.Second idea was to use SQL construction JOIN in “Where” boxeg. &AO.company_person_all.emp_no = &AO.company_person.emp_no Thanks!
Hi! I need your help and advice. I was asked to prepare a report with list of shop orders and WIP Status from that View (Cost/posting type & WIP Statistic)I used debug console and as far I can see there is a procedure Calculate_Wip BEGINBEGIN &AO.Shop_Order_Cost_Util_API.Calculate_Wip( :p0 , :p1 , :p2 , :p3 , :p4 , :p5 , :p6 , :p7 , :p8 , :p9 , :p10 , :p11 , :p12 , :p13 , :p14 , :p15 , :p16 , :p17 , :p18 , :p19 , :p20 , :p21 ); END;EXCEPTIONWHEN &AO.Error_SYS.Err_Security_Checkpoint THENraise;WHEN OTHERS THENrollback;raise;END; I am familiar only with T-SQL. Does anyone can help me how to call this procedure and get results for all orders ?Thank ypu in advance, Izabella
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.