TP_PPAY_CNAD_VW (SQL View)	Index Back
Pre Payment Plan Contract Add This view will be used to display the valid Pre Payment Plan Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'R' and TP_STATUS = Active

TP_PPAY_CNAD_VW

(SQL View)

Pre Payment Plan Contract Add

This view will be used to display the valid Pre Payment Plan Contracts and will be used to populate the dropdownlist for update/display functions - TP_CON_TYPE = 'R' and TP_STATUS = Active

SELECT A.BUSINESS_UNIT ,A.CONTRACT_NUM FROM PS_TP_CONTRACT A WHERE A.TP_CON_TYPE = 'R' AND A.TP_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number