/*LevelNo|Iskey|RecordName|FieldName|ParentRecName*/

SELECT A.BCSCROLL || '|' || DECODE(B.FIELDNAME , NULL , 'FALSE' , 'TRUE') || '|' || A.RECNAME || '|' || A.FIELDNAME || '|' || NVL(C.PARENT
,' ') FIELDVAL FROM ( SELECT FIELDNAME ,RECNAME FROM PSKEYDEFN WHERE INDEXID='_' )B, PSBCITEM A, ( SELECT DISTINCT A.RECNAME PARENT
,B.RECNAME CHILD FROM PSBCITEM A ,( SELECT BCNAME ,RECNAME ,BCTYPE ,BCSCROLL -1 BCSCROLL FROM PSBCITEM WHERE BCTYPE=4) B WHERE B.BCNAME=A.BCNAME(+)
AND B.BCTYPE=A.BCTYPE(+) AND B.BCTYPE=4 AND A.RECNAME !=' ' AND B.BCSCROLL=A.BCSCROLL(+) AND B.BCNAME='BCC_DIM_MAP_CI') C
WHERE A.RECNAME=B.RECNAME(+)
AND A.FIELDNAME=B.FIELDNAME(+)
AND A.BCNAME = 'BCC_DIM_MAP_CI'
AND A.BCTYPE =4
AND A.RECNAME =C.CHILD
AND A.BCNAME ='BCC_DIM_MAP_CI'
ORDER BY BCSCROLL,SEQUENCE_NBR_6