I'm note quite sure about the question, but as per the understanding you are required to get column value from a particular window by using Custom Events > Online SQL -- Scenario 01) If you are writing the event for the table in which your required field exist you can use something like this,DECLAREtest_ VARCHAR2(100);BEGINtest_ := &NEW:CUSTOMER_NOIn above &NEW:CUSTOMER_NO is the column value which you required. -- Scenario 02) If you are writing the event for different table where your required field isn't exist. In that case you can use a cursor like below, DECLAREtest_ VARCHAR2(100);CURSOR Get_Data ISSELECT NameFROM Customer_InfoWHERE customer_id = '&NEW:CUSTOMER_NO'BEGINOPEN Get_Data;FETCH Get_Data INTO test_;CLOSE Get_Data;Hope this will helps you what you looking for. Cheers
@Adarsh Yes, you can either use a script to create a permission set or you can manually create a new permission set in New Permission Set window. Or the script would look like below, DECLARE role_ VARCHAR2(30) := UPPER('&TEST_PERMISSION');BEGIN IF (Fnd_Role_Api.Get(role_).fnd_role_type IS NOT NULL) THEN Security_SYS.Clear_Role(role_); ELSE Security_SYS.Create_Role(role_, 'Test_Permission is a sample end user role', role_type_ => 'BUILDROLE'); END IF; --- Mandatory Views --- Security_SYS.Grant_View('VMO_ACTIVITY', role_); Security_SYS.Grant_View('VMO_BASE_CODE', role_); Security_SYS.Grant_View('VMO_BASE_CODECHOICE', role_); Security_SYS.Grant_View('VMO_BASE_CODEDEPVALUES', role_); Security_SYS.Grant_View('VMO_BASE_CODEDESC', role_); Security_SYS.Grant_View('VMO_BASE_FEATURE', role_);END;/Hope this answer to your question. Cheers
You can try below steps..In your 3rd page add a custom field Persistent > when selecting data type select Reference > (format of your choice depending on scenario) > you will get a window like below, From the List select your 2nd page custom view, once you select the appropriate view go to Edit under Display text for references. You will get something like below, From that select the correspondent column which you wanted use as LOV then hit next > From the properties window make sure to tick the checkbox List of Values as below, Continue the process, once you add make sure to update the page layout.
You can always use <br/> tag to line separation for example, ATTENTION - A Product Structure Revision has changed:<br/><br/>PN: &NEW:PART_NO<br/>Site : &NEW:CONTRACT<br/>Revision : &NEW:ENG_CHG_LEVEL<br/>
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.