TMG_WHR_USED_VW

(SQL View)
 Index Back

Timing Code Where-Used View


SELECT a.setid , a.pay_trms_time_id , b.pymnt_terms_cd , c.effdt , c.eff_status FROM ps_pymt_trms_time a , ps_pymt_trms_hdr b , ps_pymt_trms_cntl c WHERE b.setid = a.setid AND b.pymnt_terms_type = 'S' AND c.setid = b.setid AND c.pymnt_terms_cd = b.pymnt_terms_cd AND (EXISTS ( SELECT 'X' FROM PS_TMG_NET_XREF_VW i WHERE i.setid = a.setid AND i.pay_trms_time_id = a.pay_trms_time_id AND i.pymnt_terms_cd = c.pymnt_terms_cd AND i.effdt = c.effdt AND i.net_trm_nbr_occurs > 0) OR EXISTS ( SELECT 'X' FROM ps_tmg_dsc_xref_vw j WHERE j.setid = a.setid AND j.pay_trms_time_id = a.pay_trms_time_id AND j.pymnt_terms_cd = c.pymnt_terms_cd AND j.effdt = c.effdt AND j.dsc_trm_nbr_occurs > 0))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 PAY_TRMS_TIME_ID Character(3) VARCHAR2(3) NOT NULL Timing Definition ID

Prompt Table: PYMT_TRMS_TIME

3 SNGL_PYMNT_TRMS_CD Character(5) VARCHAR2(5) NOT NULL Single-Payment Terms ID
4 EFFDT Date(10) DATE NOT NULL Effective Date
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive