And thats the debug code when the “Connect Object” opening. DECLARE -- p0 -> __g_Bind.s[0] p0_ VARCHAR2(32000) := ''; -- p1 -> __g_Bind.s[1] p1_ VARCHAR2(32000) := ''; -- p2 -> __g_Bind.s[2] p2_ VARCHAR2(32000) := ''; -- p3 -> __g_Bind.s[3] p3_ VARCHAR2(32000) := ''; -- p4 -> __g_Bind.s[4] p4_ VARCHAR2(32000) := ''; -- p5 -> __g_Bind.s[5] p5_ VARCHAR2(32000) := ''; -- p6 -> __g_Bind.s[6] p6_ VARCHAR2(32000) := ''; -- p7 -> __g_Bind.s[7] p7_ VARCHAR2(32000) := ''; -- p8 -> __g_Bind.s[8] p8_ VARCHAR2(32000) := ''; -- p9 -> __g_Bind.s[9] p9_ VARCHAR2(32000) := '';BEGIN IFSAPP.Log_SYS.Init_Debug_Session_('en'); IFSAPP.Object_Connection_SYS.Get_Lov_Properties_( p0_ , p1_ , p2_ , p3_ , p4_ , p5_ , p6_ , p7_ , p8_ , p9_ );END;
Hello @anmise thank you for help. But i need another thing actually, probably did not explain clearly. I just need standart “Object Connection” tab for ECO screen. For example “Change Request” screen has Object Conn. as default. You can look the pic. standart object connection tab on CHANGE REQUESTI want to same thing on ECO screen. If i make it, i can add “Supplier For Purchase Part” object or something to inside on new tab directly. Best Regards. I missed the second picture here. I need clear Connect Object form as additional like that on the ECO screen.
Hello @anmise thank you for help. But i need another thing actually, probably did not explain clearly.I just need standart “Object Connection” tab for ECO screen.For example “Change Request” screen has Object Conn. as default. You can look the pic.standart object connection tab on CHANGE REQUESTI want to same thing on ECO screen. If i make it, i can add “Supplier For Purchase Part” object or something to inside on new tab directly.Best Regards.
Thanks @ADNAN its very usefull syntax usage.
Link is broken. Can i get IFS Data Migration link please? @Sandun Madola @eqbstal
Hello @durette thank you again Yes i cant view that page. So What i should do for being an authorized user?
Hello @durette thank you so much for help. I modified your code a little bit, so i want to share for future requests. I specified changes with red background color. Kind Regards. SELECT ps.part_no AS parent_part, RPAD('+', LEVEL, '+') || ps.component_part AS child_part, LEVEL, SYS_CONNECT_BY_PATH(ps.component_part, '/'), CONNECT_BY_ISLEAF, CASE WHEN ps.QTY_PER_ASSEMBLY<0 then 'BY-PRODUCT' else 'COMPONENTS' end as TYPE /* for seperate by-products and components*/ FROM prod_structure_head psh JOIN part_revision pr ON pr.contract = psh.contract AND pr.part_no = psh.part_no AND pr.eng_chg_level = psh.eng_chg_level JOIN prod_struct_alternate psa ON psa.contract = psh.contract AND psa.part_no = psh.part_no AND psa.eng_chg_level = psh.eng_chg_level AND psa.bom_type_db = psh.bom_type_db AND psa.alternative_no = '*'
Hello @durette can it possible to write same code for product structure? I want to see structure levels for parts from '0' as top product until last one. I tried to wroten that code but a part can exist in case x at level 2, same part can exist in case y at level 4. So we had to use LISTAGG maybe idk. Can u help me for this problem?
Hello @hansend Thanks for informations. That was improvement my mind about this case. So i wonder, when i connect to document folder as manually it is working this procedure, “IFSAPP.DOC_REFERENCE_OBJECT_API.Insert_Docs” I did not wrote any online/sql before. The problem is when a document inserted to system it will be automatically worked that procedure for predefined matches (doc class and doc folders). Can u write for that code for me? I am trying too but probably it will be wrong ;) Thank you so much for help.
Already have an account? Login
No account yet? Create an account
Enter your username or 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.