EX_L_RCPT_AW_VW (SQL View)	Index Back
Expense Report Line Receipt Expense Report Line Receipt view for AW

EX_L_RCPT_AW_VW

(SQL View)

Expense Report Line Receipt

Expense Report Line Receipt view for AW

SELECT B.SHEET_ID ,B.LINE_NBR, B.EX_NO_RCPT_REASON , C.DESCR50 FROM PS_EX_SHEET_LINE A , PS_EX_SHEET_L_RCPT B , PS_REASON_CD C , PS_EX_SHEET_HDR Z WHERE Z.SHEET_ID = A.SHEET_ID AND A.SHEET_ID = B.SHEET_ID AND A.LINE_NBR = B.LINE_NBR AND Z.SETID = C.SETID AND B.EX_NO_RCPT_REASON = C.REASON_CD AND C.REASON_TYPE = 'EX03' AND C.EFF_STATUS = 'A' AND C.EFFDT >= ( SELECT MAX(D.EFFDT) FROM PS_REASON_CD D WHERE C.SETID = D.SETID AND C.REASON_TYPE = D.REASON_TYPE AND C.REASON_CD = D.REASON_CD AND D.EFF_STATUS = 'A' AND D.EFFDT <= %CurrentDateIn)

Parent record: EX_SHEET_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
Default Value: 1

3 EX_NO_RCPT_REASON Character(10) VARCHAR2(10) NOT NULL No Receipt Reason
Prompt Table: REASON_RCPT_VW

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product] Default Value: 1
3	EX_NO_RCPT_REASON	Character(10)	VARCHAR2(10) NOT NULL	No Receipt Reason Prompt Table: REASON_RCPT_VW
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50