CA_L_ACCT_ERR

(SQL View)
 Index Back

SELECT LN.CONTRACT_NUM , LN.CONTRACT_LINE_NUM , 'X' FROM PS_CA_DETAIL LN , PS_CA_DTL_DST_DATE DSTDATE WHERE %Join(COMMON_KEYS, CA_DETAIL LN, CA_DTL_DST_DATE DSTDATE) AND %EffdtCheck(CA_DTL_DST_DATE DSTDATE2, DSTDATE, %CURRENTDATEIN) AND ( (EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_DST DST WHERE %Join(COMMON_KEYS, CA_DTL_DST_DATE DSTDATE, CA_DETAIL_DST DST) AND DST.COMBO_VALID_FLG <> 'V' ) OR EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_DFR DFR WHERE %Join(COMMON_KEYS, CA_DTL_DST_DATE DSTDATE, CA_DETAIL_DFR DFR) AND DFR.COMBO_VALID_FLG <> 'V' ) OR EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_UAR UAR WHERE %Join(COMMON_KEYS, CA_DTL_DST_DATE DSTDATE, CA_DETAIL_UAR UAR) AND UAR.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