/*Sample script to fetch the Receipt Register alon …
/*Sample script to fetch the Receipt Register along with its TDS and WCT details */ SELECT apps.gl_flexfields_pkg.get_description_sql …
Read More/* Sample script to fetch the Invoice Register with tax details */
/* Sample script to fetch the Invoice Register with tax details */ SELECT glcc.segment1, glcc.segment2, glcc.segment4, glcc.segment5, apps.gl_flexfields_pkg.get_description_sql …
Read MoreQuery to fetch Customer Statement of Account Detai …
Query to fetch Customer Statement of Account Details SELECT rc.customer_name “Customer_Name”, rc.customer_number “Customer_Number”, hou.NAME operating_unit, DECODE (ps.CLASS, …
Read MoreQuery to get the details of invoice with tax info…
Query to get the details of invoice with tax information’s select ctx.customer_trx_id, case when ( hrloc.address_line_1 is not null …
Read MoreAdd Row on the Top in the APEX Tabular Form
Step 1: Give the Add row button, Action when Button Clicked as Defined by Dynamic action. Step 2: Create a Dynamic action with Event as Click, Selection Type as Button, Button as Add_row and true action as Execute JavaScript Code with Fire on Page load No and add code as addRowTop(); Step 3: Create a function in page header as function addRowTop() { apex.widget.tabular.addRow(); apex.jQuery(apex.widget.tabular.gTabForm).find(“tr”).last().insertBefore(apex.jQuery(apex.widget.tabular.gTabForm).find(“tr”).first()); }
Read MoreAvoid wrapping of fields in APEX Interactive reports
Due to many columns in the report the data will be wrapped automatically. Resolution: 1. In report attributes, assign the static ID for the column that you want not be shrink. 2. Add the following code in the page header to remove the wrapping. $(function() { $(“td[headers=column_name’]”).attr(“nowrap”,”nowrap”); }); Output:
Read MoreSending Calendar Invite via APEX Application
With the below code we can send individual emails to the users with an ICS file as attachment. ICS is a global format for calendar files widely being utilized by various calendar and email programs including Google Calendar, Apple iCal, and Microsoft Outlook. These files enable users to share and publish information directly from their calendars over email or via uploading it to the world wide web. Step 1 : Compile the below code CREATE OR REPLACE FUNCTION ical_events ( p_summary IN VARCHAR2, p_description IN VARCHAR2, p_start_date IN DATE, p_end_date IN DATE ) RETURN VARCHAR2 AS lv_desc VARCHAR2 (20000); lv_summary VARCHAR2 (10000); lv_dtstart VARCHAR2 (100); lv_date VARCHAR2 (100); lv_dtend VARCHAR2 (100); l_retval VARCHAR2 (32767); l_lf CHAR (1) := CHR (10); BEGIN lv_summary := ‘SUMMARY:’ || p_summary; lv_date := ‘DTSTAMP:’ || TO_CHAR (SYSDATE, ‘RRRR-MM-DD’) || ‘T’ || TO_CHAR (SYSDATE, ‘HH24:MI:SS’); lv_dtstart := ‘DTSTART:’ || TO_CHAR (p_start_date, ‘RRRR-MM-DD’) || ‘T’…
Read MoreDownload hidden column in APEX classic report
Hidden column cannot be downloaded in classic report if, Display As : Hidden Include In Export : Yes This can be achieved using the PLSQL Expression: Column attributes-> Display As : Display as Text Column attributes-> Conditional display-> Condition Type : PLSQL Expression Expression : apex_application.g_excel_format = TRUE
Read MoreManual Pagination In Oracle Apex
Step:1 : Create items to set count of rows and display item to represent pagination. Also create buttons to navigate different pages. PXX_FROM – From Value PXX_TO – To Value PXX_MAX – Max Value PXX_PAGINATION – Rows per page PXX_PAGINATION_DISPLAY – Pagination Display Buttons: Save and Next,Save and Previous, First Page,Last Page Step:2: Restrict data with specified range in report query, Query is displayed as follows SELECT master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT ROWNUM rm, master_item_id, master_item_id_display, master_pdvd_id, item_id, col1, col2, col3, col4, col5, col6, col7, col8, col9, NULL, “Check”, active_ind, SEQUENCE, “replicate_of” FROM (SELECT c001 master_item_id, seq_id master_item_id_display, c002 master_pdvd_id, c003 item_id, c004 col1, c005 col2, c006 col3, c007 col4, c008 col5, c009 col6, b.c010 col7, c011 col8, NULL col9, NULL, NULL “Check”, c012 active_ind, (SELECT display_order FROM pdvd_tb_lov_dict WHERE lov_id = b.c008) SEQUENCE,…
Read MoreLosing Data During Validation In Apex Tabular Form !!! – Check In
Step:1: On Submit, Before Computation and Validation – Insert into Collections. BEGIN apex_collection.add_member (p_collection_name => ‘PDVD_MASTER_ITEM_DTLS’, p_c001 => apex_application.g_f03 (i), p_c002 => NVL (:p77_master_pdvd_id, NULL ), p_c003 => apex_application.g_f04 (i), p_c004 => apex_application.g_f05 (i), p_c005 => apex_application.g_f06 (i), p_c006 => apex_application.g_f07 (i), p_c007 => apex_application.g_f08 (i), p_c008 => apex_application.g_f09 (i), p_c009 => apex_application.g_f10 (i), p_c010 => lv_v_master_repli_of, p_c011 => lv_v_delivery_types, p_c012 => apex_application.g_f15 (i) ); EXCEPTION…
Read More