IN_PTRD_ATP_VW (SQL View)	Index Back
Planned Transfer Demand 02/01/04 EGS: Created

IN_PTRD_ATP_VW

(SQL View)

Planned Transfer Demand

02/01/04 EGS: Created

SELECT A.SOURCE_BUS_UNIT , A.INV_ITEM_ID , 'PTRD' , 'D' , 'PL' , B.DESCR , %DatePart(A.SCHED_DTTM ) , A.SCHED_ARRV_DTTM , A.QTY_REQUESTED_BASE , A.APPROVED_FLG , A.PL_PLAN_STATUS , A.PL_FREEZE_STATUS ,a.peg_status FROM PS_DEM_CHG_INF_INV A , PS_BUS_UNIT_TBL_FS B WHERE DEMAND_SOURCE = 'PL' AND PROCESSED_FLG <> 'C' AND B.BUSINESS_UNIT = A.SOURCE_BUS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 ATP_SOURCE Character(6) VARCHAR2(6) NOT NULL This field is used in the ATP and Availability calculation to determine where the particular source or demand was fetched from. It will store the up-to-6 character mnemonic used in the associated view that fetched the data. For example, if ATP_S_PO_VW was used to fetch purchase order information, this field will contain "PO". If view ATP_D_PROMIS_VW was used to fetch promised demand information, this field will contain "PROMIS".

4 AVAIL_TYPE Character(1) VARCHAR2(1) NOT NULL Availability Type
D=Demand
S=Supply

5 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

6 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

7 SCHED_DATE Date(10) DATE Schedule Date

8 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm

9 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

10 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

11 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
05=Planned
15=Firmed
90=Canceled

12 PL_FREEZE_STATUS Character(1) VARCHAR2(1) NOT NULL Planning Freeze Status

13 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	ATP_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	This field is used in the ATP and Availability calculation to determine where the particular source or demand was fetched from. It will store the up-to-6 character mnemonic used in the associated view that fetched the data. For example, if ATP_S_PO_VW was used to fetch purchase order information, this field will contain "PO". If view ATP_D_PROMIS_VW was used to fetch promised demand information, this field will contain "PROMIS".
4	AVAIL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Availability Type D=Demand S=Supply
5	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
6	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
7	SCHED_DATE	Date(10)	DATE	Schedule Date
8	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
9	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
10	APPROVED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Approved by Auditor D=Denied N=Not Approved Y=Approved
11	PL_PLAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	11/01/01 PCL (CN#PL900-1): Added 05=Planned 15=Firmed 90=Canceled
12	PL_FREEZE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Planning Freeze Status
13	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged