Please can you advice me what the probelm in below script as it run in sql but in forms no:
SELECT 1, LEVEL, name, '', TO_CHAR(id),FCS_CST_ID
WHERE FCS_CST_ID IS NULL
OR FCS_CST_ID IN (SELECT FCS_CST_ID
WHERE UPPER(USERNAME)=UPPER(:GLOBAL.USER) )
CONNECT BY PRIOR id = PARENT_ID
START WITH PARENT_ID IS NULL
Well, "it does not run" is not a very specific description of your error. Provide more details about what does not work correctly. For working with trees you might check this http://andreas.weiden.orcl.over-blog.de/article-29307730.html
More than likely is your use of the Analytical Function. Remember, the PL/SQL Client in Oracle Forms is at least one version behind the database - if not more, depending on your Forms version.
Speaking of the Forms Version - in order for anyone to offer valuable feedback, we ALWAYS need to know what product versions you are using, which Operating Systems are involved, client side information (browser, jre, os, etc), and if an error is involved, what are the details of the error.