AV_MB_TNDR_SRCH

(SQL View)
 Index Back

Srch Rec to Edt Tndr Dtls


SELECT A.BUSINESS_UNIT , A.SESSION_NO , B.MBR_PMT_NO , B.TENDER_TYPE , C.DESCR , B.EMPLID , B.EXT_ORG_ID FROM PS_AV_SESSION_TBL A , PS_AV_MBR_DTL B , PS_AV_TENDER_TBL C WHERE A.AV_SESS_TYPE IN ('M','AM') AND A.SESS_STATUS = 'P' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.ADJUSTMENT_FLG = 'N' AND B.TENDER_TYPE = C.TENDER_TYPE AND C.GIFT_SPCL_FLD IN ('G','S') AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_AV_TENDER_TBL C1 WHERE C.TENDER_TYPE = C1.TENDER_TYPE AND C1.EFFDT <= %CurrentDateIn) AND C.EFF_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: AV_OPR_DEF_TBL.BUSINESS_UNIT

Prompt Table: AV_BUS_UNIT_TBL

2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Number
3 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
4 TENDER_TYPE Character(6) VARCHAR2(6) NOT NULL Tender Type

Prompt Table: AV_TNDR_TYPE_VW

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: AV_PEOPLE_SRCH

7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

Prompt Table: AV_EXT_ORG_SRCH