Queries
Wednesday, 4 July 2018
Oracle Forms - Show Calendar
›
1.To show calendar for date fields like start_date/end_date, set ENABLE_LIST_LAMP property of LOV. 2.Give calendar.show in KEY-LISTVAL tri...
Oracle Forms - Disable Show Navigator Icon
›
There are two ways we can access Show Navigator in Oracle Forms. 1.View - Show Navigator Command to disable: set_menu_item_property(...
Wednesday, 14 May 2014
R12 :Query for Bank Book Report
›
SELECT xe.event_type_code,to_char(ac.check_number) check_number,to_char(ac.check_date,'DD-MON-RRRR') check_date,ai.doc_sequence_val...
Tuesday, 18 March 2014
Oracle R12 Query to find self consumption of finished goods
›
SELECT msi.segment1 itemcode,msi.description fg_descr, msi.primary_unit_of_measure fg_uom, ROUND(ABS((SELECT SUM (mmt1.transacti...
Wednesday, 26 February 2014
Oracle R12 Parameter mandatory based on another parameter
›
Objective: Generally we can enable to disable a parameter based on dependent value sets method. There may be scena...
›
Home
View web version