WHERE_USED_VW

(SQL View)

SELECT B.SCAN_PASS_NBR , A.WHEREUSEDPARTYPE ,A.WHEREUSEDCHILDTYPE ,A.WHEREUSEDCHILD , A.WHEREUSEDPARENT FROM PS_WHERE_USED A , PS_CC_SCAN_LIST B , PS_CC_SCAN_LIST C WHERE B.SCAN_LIST_ID = 2 AND B.WHEREUSEDPARTYPE = A.WHEREUSEDPARTYPE AND B.WHEREUSEDPARENT = A.WHEREUSEDPARENT AND C.SCAN_LIST_ID = 2 AND C.WHEREUSEDPARTYPE = A.WHEREUSEDCHILDTYPE AND C.WHEREUSEDPARENT = A.WHEREUSEDCHILD AND B.SCAN_PASS_NBR = C.SCAN_PASS_NBR - 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCAN_PASS_NBR Number(7,0) INTEGER NOT NULL Scan Pass Number indicates when the object was added to the scan list. Which pass added it. e.g. first pass, second pass, etc. zero is valid and indicates that it was in the initial scan list.

2 WHEREUSEDPARTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Parent Type

3 WHEREUSEDCHILDTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Child Type

4 WHEREUSEDCHILD Character(100) VARCHAR2(100) NOT NULL Child

5 WHEREUSEDPARENT Character(100) VARCHAR2(100) NOT NULL Parent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCAN_PASS_NBR	Number(7,0)	INTEGER NOT NULL	Scan Pass Number indicates when the object was added to the scan list. Which pass added it. e.g. first pass, second pass, etc. zero is valid and indicates that it was in the initial scan list.
2	WHEREUSEDPARTYPE	Signed Number(6,0)	DECIMAL(5) NOT NULL	Parent Type
3	WHEREUSEDCHILDTYPE	Signed Number(6,0)	DECIMAL(5) NOT NULL	Child Type
4	WHEREUSEDCHILD	Character(100)	VARCHAR2(100) NOT NULL	Child
5	WHEREUSEDPARENT	Character(100)	VARCHAR2(100) NOT NULL	Parent