PL_VLTN_PLTR_VW (SQL View)	Index Back
Supply Violations Table to track violations in supply

PL_VLTN_PLTR_VW

(SQL View)

Supply Violations

Table to track violations in supply

SELECT SOURCE_BUS_UNIT , DESTIN_BU , SPL_ORDER_NBR , SPL_VIOLATIONS_CNT FROM PS_SPL_VIOLATIONS WHERE PL_MRP_ORDER_TYPE = '060'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

2 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

3 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

4 SPL_VIOLATIONS_CNT Number(7,0) INTEGER NOT NULL Violations Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
2	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
3	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
4	SPL_VIOLATIONS_CNT	Number(7,0)	INTEGER NOT NULL	Violations Count