Dear Friends
I would like to create a Tree structure on form along with select tree details on the right. already created the Sql query for tree structure, but unable to design in forms.
Created a blank form . in that selected the following query . now in the attribute what i should select as per this query.
Please suggest.
SELECT
LEVEL as Seq_No, ECN_NO, ITEM_TYPE,
RPAD('/', (level-1)*1, '/') || CHILD_ITEM AS BOM_TREE,
TO_CHAR(PARENT_item) PARENT_item, TO_CHAR(CHILD_ITEM) CHILD_ITEM,
PRODUCED_QUANTITY, CONSUMED_QUANTITY, ROUND(CONSUMED_QUANTITY / PRODUCED_QUANTITY,7)RATIO, FIXED_LEAD_TIME
FROM view_FINAL_ecn
CONNECT BY PRIOR CHILD_ITEM=PARENT_ITEM
START WITH item_type ='A'
ORDER SIBLINGS BY (item_type)
Sanjay