Skip to Main Content

Oracle Apex Query - Common Name to set of records in tree query

SANPATJul 26 2022

Dear Friends
We want to define a common name for the tree Query for each parent to child , which will help to get the set of records of same family.
Kindly suggest how to achive this . here is the example of Query .
SELECT
LEVEL as Seq_No,
ECN_NO, ROWNUM, ITEM_TYPE, RPAD('/', (level-1)*1, '/') || CHILD_ITEM AS BOM_TREE, TO_CHAR(PARENT_item) PARENT_item, TO_CHAR(PARENT_DESCRIPTION)PARENT_DESCRIPTION, TO_CHAR(CHILD_ITEM) CHILD_ITEM, TO_CHAR(CHILD_DESCRIPTION).CHILD_DESCRIPTION, 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

Comments
Post Details
Added on Jul 26 2022
0 comments
12 views