Showing posts from March, 2023
Step-1 : Go to Master table (Classic report) Create new Item (P53_MWAB) Item Default : Type : SQL Query SQL Query : select MAWB_ID ---- Table column Name from DEBIT_MST where ID = :P53_ID This Result : Step-2 : Go to Details Table from and Crea…
Step-1 : Create Interactive Report (SQL Query) select ID, APEX_ITEM.CHECKBOX( 1,ID ,'UNCHECKED') selected , BOOKING_ID, CONSIGNEE, AIRPORT_ORIGIN, AIRPORT_DESTI, COUNTRY_DESTI, …
Step-1 : Create Interactive Grid (table-1-----) Step-2 : Create Interactive Grid (table-2-----) Step-3 : Select ID ( table_1 PK column) Type : Display Only Target : --> Type : URL --> URL : # Link Text : Chose your button …
CREATE OR REPLACE procedure SEAEXPORT_MST_DTL_SAVE ( IN_BOOKING_ID IN VARCHAR2 , IN_BOOKING_DATE IN DATE, IN_SETUP_PARTY_ORG_ID IN NUMBER , IN_SETUP_PARTY_COM_ID IN N…
Logo/Image ========= java.awt.Image 1. Go to Basic Elements and take "Image" 2. Go to Properties --> Click Image and Expression Select $F{LOGO} --- (Column Name) 3. Go to Query Editor --> Class Type -- java.awt.Image ---------------…
Step-1 : Copy to paste this code in Page Load Dynamic Action document.getElementById( "P9_ TOTAL_AMOUNT" ).readOnly = true; document.getElementById( "P9_ DISCOUNT_AMOUNT" ).readOnly = true; document.getElementById( "P9_ VAT…
CREATE OR REPLACE TRIGGER "Update_house_TRG" BEFORE INSERT OR UPDATE ON CONSOL_DTL REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE MAX_FROMDATE DATE ; MIN_FROMDATE DATE ; BEGIN IF INSERTING THE…
