ATP_D_COMP1_VW

(SQL View)
 Index Back

ATP Dependent Demand View 1

This view gathers dependent demand information for regular production orders with no matching operation sequence.

SELECT a.business_unit , a.component_id , 'COMP1' , 'D' , 'SF' , a.production_id , b.new_start_date , a.op_sequence , b.ma_prdn_id_flg , a.issue_method , a.curr_sched_qty , a.pend_consume_qty , a.pend_loss_qty , a.issue_qty , a.yield_qty , a.pick_qty , a.yield , b.prod_status , b.inv_item_id , b.production_type ,'40' FROM ps_sf_comp_list a , ps_sf_prdnid_headr b WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id AND b.prod_status IN ('15','20','30') AND a.config_code = ' ' AND b.ORIG_PRDN_QTY = b.ORIG_PRDN_END_QTY AND b.cum_yield = 100 AND (a.op_sequence = 0 OR NOT EXISTS ( SELECT 'x' FROM PS_SF_OP_LIST c WHERE c.business_unit = a.business_unit AND c.production_id = a.production_id AND a.business_unit = b.business_unit AND a.production_id = b.production_id AND c.business_unit = b.business_unit AND c.production_id = b.production_id AND c.op_sequence = a.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 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
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 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
11 CURR_SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED
12 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
13 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
14 ISSUE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
15 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
16 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.
17 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield
18 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
19 SOURCE_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Source Item
20 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
21 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged