SEC_LOC2_PR_LN (SQL View)	Index Back
Rel Lng for SEC_LOC2_PR_VW Prompt view for Locations here SCRTY_KEY2 is the first key instead of BUSINESS_UNIT.

SEC_LOC2_PR_LN

(SQL View)

Rel Lng for SEC_LOC2_PR_VW

Prompt view for Locations here SCRTY_KEY2 is the first key instead of BUSINESS_UNIT.

SELECT SETTBL.SETCNTRLVALUE , LOC.LOCATION , L.LANGUAGE_CD , LOC.DESCR FROM PS_LOCATION_TBL LOC , PS_SET_CNTRL_REC SETTBL , PS_LOCATION_LANG L WHERE %EffdtCheck(LOCATION_TBL B, LOC, %CurrentDateIn) AND LOC.SETID = SETTBL.SETID AND L.SETID = LOC.SETID AND L.LOCATION = LOC.LOCATION AND L.EFFDT = LOC.EFFDT AND SETTBL.RECNAME = 'LOCATION_TBL' AND EXISTS ( SELECT 'x' FROM PS_BUS_UNIT_TBL_HR BUS WHERE BUS.BUSINESS_UNIT = SETTBL.SETCNTRLVALUE)

Related Language Record for SEC_LOC2_PR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_KEY2 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for Rowlevelsecurity access to JOB

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_KEY2	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for Rowlevelsecurity access to JOB
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description