Showing posts from June, 2023
Step 1 : Create Dynamic Action Name : Calculate Grand Total Event : Lose Focus Selection Type : Region Region : (Select Grid Region) True Action : Execute JavaScript Code Code : var model = apex.region(&…
Step 1 : Go to Login From And Create User "Supper-Admin" . Don't Any Company Select. Step 2 : Create New Page And Create Two Region 1- All Company 2- My Company 👉1- All Company Type : Classic Report SQL Query : SELECT I…
Step 1 : Go to IR Report Query and new column Add with HTML '<div style="margin-bottom: 10px; text-align: center" > <a href="'||apex_util.prepare_url('f?p='||:APP_ID||':'||177||'…
Step 1 : Create New Page And Create Classic Report Create New Item : P158_AIREXP_MST_ID Query Condition : from AIREXPORT_MST and ID = :P158_AIREXP_MST_ID Attributes : Template : Value Attribute Pairs-Column Create Button : COPY_BOOKING Create …
Unique Validation ============ Create Validation on SUPPLIER_NAME item. Validation Name: Unique_supplier_name Type: No Rows Returned --> SQL Query : select SUPPLIER_NAME from SUPPLIER where upper(SUPPLIER_NAME) = upper(:P8_SUPPLIER_NAME); --…
Step 1 : Select Item P213_RCV_TYPE Type : Radio Group. Static Value : In Credit = CR In Cash = CA Step 2 : Create Dynamic Action . Action Name : show_payment Event : Change Client-side Condition…