PV_CHNG_SRCH_VW

(SQL View)

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.REQ_ID FROM PS_PO_LINE_DISTRIB A , PS_PO_HDR B WHERE A.DST_ACCT_TYPE = 'DST' AND A.PO_ID <> ' ' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND (B.PO_STATUS = 'D' OR (B.PO_STATUS = 'A' AND B.CHNG_ORD_BATCH > 0)) AND B.IN_PROCESS_FLG = 'N' AND B.HOLD_STATUS = 'N'

# 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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition 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	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID