CA_RED_ACCT_ERR

(SQL View)

SELECT LN.CONTRACT_NUM , LN.CONTRACT_LINE_NUM , 'X' FROM PS_CA_DETAIL LN , PS_CA_DTL_RED_DATE RDT WHERE %Join(COMMON_KEYS, CA_DETAIL LN, CA_DTL_RED_DATE RDT) AND %EffdtCheck(CA_DTL_RED_DATE RDT2, RDT, %CURRENTDATEIN) AND (EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_REDUC RED WHERE %Join(COMMON_KEYS, CA_DTL_RED_DATE RDT, CA_DETAIL_REDUC RED) AND RED.COMBO_VALID_FLG <> 'V'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	COMBO_VALID_FLG	Character(1)	VARCHAR2(1) NOT NULL	ChartField Combinatn Valid Flg ?=Validation in Progress V=Valid ChartField Combination X=Invalid ChartField Combo