FPM_CA_CTG01_VW (SQL View)	Index Back
Setids for CA categories This view retrieves the setids linked to categories. It is used by the French Public Sector Commitment Accounting functionalities.

FPM_CA_CTG01_VW

(SQL View)

Setids for CA categories

This view retrieves the setids linked to categories. It is used by the French Public Sector Commitment Accounting functionalities.

SELECT DISTINCT A.SETID FROM PS_FPM_CA_CTG_TBL A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FPM_CA_CTG_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.FP_CA_CATG_ID = A_ED.FP_CA_CATG_ID AND A_ED.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID