IN_PRO_CP_VW (SQL View)	Index Back
Canceled Orders with Pegs 10/05/04 SR/ISC: Created

IN_PRO_CP_VW

(SQL View)

Canceled Orders with Pegs

10/05/04 SR/ISC: Created

SELECT DISTINCT PH.BUSINESS_UNIT %Concat X.PEG_KEY_SEPARATOR %Concat PH.PRODUCTION_ID , PH.MG_OUTPUT_ITEM , PSH.BUSINESS_UNIT , IP.SUP_ORDER_TYPE FROM PS_IN_PEGGING IP , PS_SF_OUTPUT_HASH PH , PS_SF_PRDNID_HEADR PSH , PS_INSTALLATION_IN X WHERE IP.SUPPLY_HASH = PH.HASH_KEY AND IP.SUP_ORDER_TYPE = '020' AND IP.PEG_STATUS = '10' AND PSH.BUSINESS_UNIT = PH.BUSINESS_UNIT AND PSH.PRODUCTION_ID = PH.PRODUCTION_ID AND PSH.PROD_STATUS = '90'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUP_ORDER_KEY Character(25) VARCHAR2(25) NOT NULL Used to store the various Order Number formats in 1 field

2 SUP_LINE_KEY Character(25) VARCHAR2(25) NOT NULL Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.

3 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

4 SUP_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Used by Pegging Maintenance/Inquiry
010=Purchase
020=Production
035=Transfer Supply
100=Requisition

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUP_ORDER_KEY	Character(25)	VARCHAR2(25) NOT NULL	Used to store the various Order Number formats in 1 field
2	SUP_LINE_KEY	Character(25)	VARCHAR2(25) NOT NULL	Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
3	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
4	SUP_ORDER_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Used by Pegging Maintenance/Inquiry 010=Purchase 020=Production 035=Transfer Supply 100=Requisition