ATP_S_IUT7_VW (SQL View)	Index Back
ATP Supply -- IUT View 7 View used to gather information for interunit transfers that have been received at the destination business unit but not yet putaway (this is supply for the destination business unit).

ATP_S_IUT7_VW

(SQL View)

ATP Supply -- IUT View 7

View used to gather information for interunit transfers that have been received at the destination business unit but not yet putaway (this is supply for the destination business unit).

SELECT d.business_unit , d.inv_item_id , 'IUT5' , 'S' , SUM(d.qty) , d.unit_of_measure , u.conversion_rate , u.qty_precision , u.round_rule FROM ps_inv_item_uom u , ps_set_cntrl_rec sc , PS_STAGED_INF_INV d WHERE d.receipt_type = 'IUT' AND sc.setcntrlvalue = d.business_unit AND sc.recname = 'INV_ITEM_UOM' AND u.setid = sc.setid AND u.inv_item_id = d.inv_item_id AND u.unit_of_measure = d.unit_of_measure GROUP BY d.business_unit, d.inv_item_id, d.unit_of_measure, u.conversion_rate, u.qty_precision, u.round_rule

# 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 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

7 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

8 QTY_PRECISION Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal
W=Whole Nbr

9 ROUND_RULE Character(1) VARCHAR2(1) NOT NULL Rounding Rule
D=Round Down
N=Natural Round
U=Round Up

#	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	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
6	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
7	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
8	QTY_PRECISION	Character(1)	VARCHAR2(1) NOT NULL	Quantity Precision D=Decimal W=Whole Nbr
9	ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	Rounding Rule D=Round Down N=Natural Round U=Round Up