Dear Friends
I am trying to create a 12c Form where on one side it should show Tree structure and on another side it should show the details wherever the user will click on the tree Item.
secondly when I had only the tree structure , Its identified that when I create any item its getting repeated in the same second group
Code
DECLARE
rg_id RECORDGROUP;
ret_code NUMBER;
BEGIN
Set_Window_Property(Forms_MDI_WINDOW, WINDOW_STATE, MAXIMIZE);
Set_Window_Property('window1', WINDOW_STATE, MAXIMIZE);
/* If the record group already exists, delete it. */
rg_id := FIND_GROUP('RG_TREE');
IF NOT ID_NULL(rg_id) THEN
DELETE_GROUP(rg_id);
END IF;
/* Create the record group using a query */
rg_id := CREATE_GROUP_FROM_QUERY('RG_TREE','SELECT -1,
LEVEL,
GROUP_Name,
NULL,
to_char(AC_GROUP_ID)
FROM BOM
CONNECT BY PRIOR AC_GROUP_ID=Parent_ID
START WITH Parent_ID IS NULL
ORDER SIBLINGS BY AC_GROUP_ID');
/* Populate the record group using data from the query with which it was /created */
ret_code := POPULATE_GROUP(rg_id);
/* If the above populate is a success then set tree property as follows */
IF (ret_code = 0) THEN
FTREE.SET_TREE_PROPERTY('BLOCK_TREE.TREE_LOAD',FTREE.RECORD_GROUP, rg_id);
END IF;
go_block('ERP_BLOCK');
execute_query;
go_block('ac_group');
execute_query;
END;
Sanjay