ATP_S_IUT3A_VW (SQL View)	Index Back
ATP Supply -- IUT View 3 View used to gather interunit transfer information in SHIP_INF_INV (this is supply for the destination business unit). Only interunit transfers that have no quantity received yet (at the destination business unit) are returned.

ATP_S_IUT3A_VW

(SQL View)

ATP Supply -- IUT View 3

View used to gather interunit transfer information in SHIP_INF_INV (this is supply for the destination business unit). Only interunit transfers that have no quantity received yet (at the destination business unit) are returned.

SELECT s.destin_bu , s.inv_item_id , 'IUT3' , 'S' , s.demand_source , s.order_no , s.order_int_line_no , s.ship_cust_name1 , %DatePart(s.sched_dttm) , s.sched_arrv_dttm , s.last_qty_ship_base , s.qty_pick_base , 'N' FROM PS_IN_DEMAND s WHERE s.interunit_flg = 'Y' AND s.in_fulfill_state = '50' AND NOT(s.IN_PROCESS_DATE IS NULL) AND s.interunit_stat <> 'C' AND s.interunit_stat <> 'R' AND (s.interunit_stat <> 'I' OR NOT EXISTS( SELECT 'x' FROM ps_inv_recv_ln t WHERE t.interunit_id = s.interunit_id AND t.interunit_line = s.interunit_line AND t.business_unit_in = s.destin_bu AND t.source_bus_unit = s.business_unit AND t.inv_item_id = s.inv_item_id))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MST_ITM_PRPT_VW

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 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

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

9 SCHED_DATE Date(10) DATE Schedule Date

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

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

12 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.

13 SHIPPED_FLAG Character(1) VARCHAR2(1) NOT NULL Shipped
B=Both
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MST_ITM_PRPT_VW
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	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
8	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
9	SCHED_DATE	Date(10)	DATE	Schedule Date
10	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
11	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
12	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.
13	SHIPPED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Shipped B=Both N=No Y=Yes