Create Bulk GL Code Combinations Using API
DECLARE CURSOR c1 IS SELECT a.rowid row_id,a.* FROM temp_gl_code a WHERE process_flag= ‘N’; l_segment1 …
Read MoreSales Order details with India Localization tax
SELECT h.header_id header_id, party.party_name sold_to, h.order_number order_number, NVL (TO_CHAR (h.ordered_date, ‘DD-MON-YYYY’), TO_CHAR (h.request_date, ‘DD-MON-YYYY’) …
Read MoreQuery to get opening,purchasing,receive,sales and closing quantity of items
SELECT * FROM (SELECT b.item_code, b.item_description item_description, b.primary_uom, b.sub_inventory, b.LOCATOR, b.opening_qty opening_qty,…
Read MoreAPEX 5- Using Images as an Top Navigation Menu
Overview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screen shots. 5. Conclusion. 1. Purpose: This document describes how to Use an Favicons in Apex 5 Top Navigation Menu. In Apex 5, Navigation Menu Position is…
Read MoreAPEX – Reports with Row Details
Overview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screenshots. 5. Conclusion. 1. Purpose: This document describes how to show a Apex Reports with Row Details In Apex, Report is an important tool which is in classical,…
Read MoreDeep Linking in Oracle APEX :
Deep linking refers to the ability to link to an Oracle Application Express page out of context . When you link to a page out of context and the application…
Read MoreWord Wrap in APEX IR:
One of the common problems with APEX IR is word wrap. Add the below code in Column formatting in column attribute: <table style=“word-break: break-all; width:100px”> <tr> <td >#COLUMN_NAME# </td> </tr> </table>
Read MoreAPEX – Report Rows Clickable to detailed page
Overview: 1. Purpose. 2. Benefits. 3. Steps 4. Conclusion. 1. Purpose: This document describes how to make a Apex Reports clickable to detailed page with an option of entire row selection. In Apex,…
Read MoreFreeze Columns in Tabular Form/ Report (Classical Report)
Today I would like to share “How to Freeze/Fix Column Header Row of a Classic Report” which I found very useful when the number of report columns/rows are more per…
Read MoreItem Category Conversion Categoriesare the method …
Item Category Conversion Categories are the method by which the items in inventory can be separated logically and functionally for planning, purchasing and other activities.You can use categories and category…
Read More