GPMX_CAL_FN_VW

(SQL View)
Index Back

Finalized Calendar Groups View

Finalized Calendar Groups View

SELECT A.CAL_RUN_ID ,A.DESCR FROM PS_GP_CAL_RUN A WHERE A.RUN_FINALIZED_IND = 'Y' AND A.COUNTRY = 'MEX' AND(EXISTS ( SELECT B.CAL_RUN_ID FROM PS_GPMX_RC_IAC_TBL B WHERE A.CAL_RUN_ID = B.CAL_RUN_ID AND B.RUN_FINAL_IND = 'N') OR NOT EXISTS( SELECT C.CAL_RUN_ID FROM PS_GPMX_RC_IAC_TBL C WHERE A.CAL_RUN_ID = C.CAL_RUN_ID AND C.RUN_FINAL_IND = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description