SCC_EXT_ORG_VW2 (SQL View)	Index Back
External Organization View View for Integration purpose of External Organization.

SCC_EXT_ORG_VW2

(SQL View)

External Organization View

View for Integration purpose of External Organization.

SELECT A.EXT_ORG_ID FROM PS_EXT_ORG_TBL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EXT_ORG_TBL A1 WHERE A.EXT_ORG_ID = A1.EXT_ORG_ID AND A1.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID