GLRN_APPRVRS_VW

(SQL View)
 Index Back

Account Recon Approvers

Account Reconciliation Approvers

SELECT A.GLRN_SET , A.GLRN_RULE , A.BUSINESS_UNIT , A.AS_OF_DATE , A.SEQUENCE_NBR_9 , B.USERID FROM PS_GLRN_RECON_TBL A , PS_GLRN_RECON_ASGN B WHERE B.GLRN_SET = A.GLRN_SET AND B.GLRN_RULE = A.GLRN_RULE AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AS_OF_DATE = A.AS_OF_DATE AND B.SEQUENCE_NBR_9 = A.SEQUENCE_NBR_9 AND B.GLRN_USER_FUNCTION = 'A' AND EXISTS( SELECT 'X' FROM PS_GLRN_SECURITY WHERE GLRN_ASGN_TYPE ='U') UNION SELECT A.GLRN_SET , A.GLRN_RULE , A.BUSINESS_UNIT , A.AS_OF_DATE , A.SEQUENCE_NBR_9 , C.ROLEUSER FROM PS_GLRN_RECON_TBL A , PS_GLRN_RECON_ASGN B , PSROLEUSER C WHERE B.GLRN_SET = A.GLRN_SET AND B.GLRN_RULE = A.GLRN_RULE AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.AS_OF_DATE = A.AS_OF_DATE AND B.SEQUENCE_NBR_9 = A.SEQUENCE_NBR_9 AND B.GLRN_USER_FUNCTION = 'A' AND B.USERID=C.ROLENAME AND C.DYNAMIC_SW='N' AND EXISTS( SELECT 'X' FROM PS_GLRN_SECURITY WHERE GLRN_ASGN_TYPE ='R')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
2 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 AS_OF_DATE Date(10) DATE As of Date
5 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).