/*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

Views: 71

Reply to This

Replies to This Discussion

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service