Displaying Classical Report in Full page with Less Columns
Step 1: Create classical report with less number of columns in a page. Step 2: Go to the page header, in CSS under Inline CSS mention the code as table.uReportContainer,…
Read MoreBreadcrumbs Using Page Items
According to the customer’s requirement, there is a table which contains both parent parts and child parts in one table. Once we create a part, a link must be available…
Read MoreCalculating Sum of 2 or More Fields in Oracle Apex
Step 1: Create all the items which you need to calculate Step 2: In items level Element à HTML Form Element Attributes à Call a function on Key up onkeyup=”total();”…
Read MoreDisplaying of a select list and a button based on conditions in one Tabular Form Column
Requirement: For already existing records in data base a select list must display, and for newly added records a button must display for deleting the newly added record Resolution Steps:…
Read MoreFile Type Validation using Java Script
Step 1: Create a File browse item. Step 2: Create a button to submit the page. Give the Action when Clicked as Defined by Dynamic Action. Step 3: Create a…
Read MoreDynamically ordering of rows
Step 1: Create a tabular form with the query and add a null column at last Step 2: Report attributes à NULL column à HTML Expression <img id=”down_#ROWNUM#” style=”cursor:pointer;” onclick=”f_row_down(this)”…
Read MoreModal Dialog in Apex 4.2
Requirement: A modal dialog has to open on button click in Oracle Apex 4.2. Step 1: Create a page Step 2: Create a HTML static Region and create a…
Read MoreFunction to convert Item quantity from one UOM to another UOM
Oracle Standard function APPS.INV_CONVERT.INV_UM_CONVERT can be used to convert quantity from one UOM to another UOM. Eg: To convert from primary UOM to Base UOM DECLARE v_primary_uom VARCHAR2…
Read MoreQuery to get transactions of inventory items with available onhand quantity
SELECT recs.doc_type, recs.item_number, recs.doc_no, recs.po_number, recs.organization_id, recs.inventory_item_id, recs.primary_quantity, recs.transaction_date FROM ( /* receipt transactions*/ …
Read MoreQuery to get current onhand quantity of inventory Items.
SELECT ALL mtl.organization_id, orgs.NAME organization_name, mtl.inventory_item_id, mtl.segment1 item_number, mtl.description item_description, mtl.item_type, mtl.inventory_item_status_code, mtl.primary_uom_code, …
Read More