RECV_INQ_DEL_VW (SQL View)	Index Back
Receipt Update Search Date Initials Bug Description 05/31/2021 Nash 32697120 We ensured that Delivery Inquiry page will display the closed and cancelled Receipts in the prompts.

RECV_INQ_DEL_VW

(SQL View)

Receipt Update Search

Date Initials Bug Description 05/31/2021 Nash 32697120 We ensured that Delivery Inquiry page will display the closed and cancelled Receipts in the prompts.

SELECT DISTINCT A.BUSINESS_UNIT , S.RECEIVER_ID FROM PS_RECV_HDR A , PS_RECV_LN_SHIP S WHERE A.BUSINESS_UNIT = S.BUSINESS_UNIT AND A.RECEIVER_ID = S.RECEIVER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PM_NONVW

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PM_NONVW
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number