ATP_S_PRD4_VW (SQL View)	Index Back
ATP Supply -- Production Vw 2 View used to fetch production information for ATP calculation purposes.

ATP_S_PRD4_VW

(SQL View)

ATP Supply -- Production Vw 2

View used to fetch production information for ATP calculation purposes.

SELECT b.business_unit , b.mg_output_item , 'PRD2' , 'S' , 'SF' , b.production_id , a.op_end_dt , b.mg_output_schd_qty - b.completed_qty , c.ma_prdn_id_flg , b.mg_output_type , c.prod_status , b.peg_status FROM PS_SF_OP_LIST a , ps_sf_output_list b , ps_sf_prdnid_headr c WHERE c.prod_status < '40' AND b.business_unit = c.business_unit AND b.production_id = c.production_id AND b.mg_output_type <> 'WB' AND b.config_code = ' ' AND b.op_sequence > 0 AND a.business_unit = b.business_unit AND a.production_id = b.production_id AND a.op_sequence = b.op_sequence

# 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 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

7 SCHED_DATE Date(10) DATE Schedule Date

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

9 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

10 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste

11 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled

12 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	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
7	SCHED_DATE	Date(10)	DATE	Schedule Date
8	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
9	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
10	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
11	PROD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Production Status 10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled
12	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged