OI_TREE_NAME_VW

(SQL View)
 Index Back

OTBI Tree Prompt view

OTBI Tree Prompt view

SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_ACCOUNT) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_DEPT) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_ALTACCT) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_PROJID) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_BUDREF) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_CLASSFD) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_FUNDCD) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_OPRUNIT) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_PROGCD) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_PRODUCT) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_CF1) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_CF2) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME UNION SELECT DISTINCT F.CHARTFIELD ,T.TREE_NAME ,T.DESCR FROM %Table(OI_CF_DFLT_TREE) F ,PSTREESTRCT S ,PSTREEDEFN T ,%Table(OI_TFLT_CF3) A WHERE (F.CHARTFIELD = S.DTL_FIELDNAME OR F.CHARTFIELD = S.NODE_FIELDNAME) AND T.TREE_STRCT_ID = S.TREE_STRCT_ID AND T.TREE_NAME = A.TREE_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description