Showing posts from February, 2024
<b style="color:red;">DEDUCT AIT (%)</b>
Region Type: PL/SQL Dynamic Content PL/SQL Code : declare begin FOR X IN ( select CAPACITY_CBM, ALLOCATION, CONTAINER_MODE, TOTAL_ADDED,CONTAINER_NUMBER, CONTAINER_SEAL, TARE_WEIGHT, ID from STUFFING_PLAN_CONT where STUFFING_PLAN_MST_ID = :P124…
Note: Page --> Reload on Submit: Always declare v_type varchar2(10); HAWB_NUMBER varchar2(50); begin SELECT DISTINCT GET_HAWB_DTL('A',:P96_HAWB_ID) HAWB INTO HAWB_NUMBER FROM HAWB_MST; if :P96_REPORT_FORMAT = 'PDF' then v_ty…
