CA_PGP_DTL_VW

(SQL View)
 Index Back

proxy for CA_CHG_DTL in PGP

this record is used to select data from PS_CA_DETAIL/PS_CA_CHG_DTL in the CA_PGP_DTL_LINK page. field ORIGIN_SLCT_FLG is used to indicate where the data comes from: - "L" - Line, came from CA_DETAIL - "A" - Amendment, came from CA_CHG_DTL

SELECT CONTRACT_NUM ,CA_PGP_SEQ ,CONTRACT_LINE_NUM FROM PS_CA_DETAIL WHERE CA_PGP_SEQ > 0 AND CA_LINE_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CA_PGP_SEQ Number(3,0) SMALLINT NOT NULL Progress Payment Sequence
3 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

Prompt Table: CA_PGP_DTL_SRCH