BI_IUINDR_CLSVW

(SQL View)
 Index Back

BI IU Indirect Class View


SELECT B.OPRCLASS , FB.BUSINESS_UNIT , TB.BUSINESS_UNIT , A.DESCR , A.DESCRSHORT FROM PS_BUS_UNIT_TBL_FS A , PS_BUS_UNIT_TBL_GL FB , PS_SET_CNTRL_GROUP FS , PS_IU_INTER_TRAN FT , PS_BUS_UNIT_TBL_GL TB , PS_SET_CNTRL_GROUP TS , PS_IU_INTER_TRAN TT , PS_SEC_BU_CLS B WHERE FS.SETCNTRLVALUE = FB.BUSINESS_UNIT AND FS.SETCNTRLVALUE = A.BUSINESS_UNIT AND FS.REC_GROUP_ID = 'FS_59' AND FT.SETID = FS.SETID AND FT.IU_INTER_TMPLT_CD = TB.IU_INTER_TMPLT_CD AND FT.IU_TRAN_CD = 'BIIVC' AND TS.SETCNTRLVALUE = TB.BUSINESS_UNIT AND TS.REC_GROUP_ID = 'FS_59' AND TT.SETID = TS.SETID AND TT.IU_INTER_TMPLT_CD = FB.IU_INTER_TMPLT_CD AND TT.IU_TRAN_CD = 'BIIVC' AND FS.SETCNTRLVALUE = B.BUSINESS_UNIT AND FS.SETCNTRLVALUE = A.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description