IN_INT_CUST_VW

(SQL View)
 Index Back

View of Internal Customer Usg

06/25/04 pwf change reference from SCHED_LINE_NO to SCHED_LINE_NBR

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.START_DT , A.LOCATION , A.BUSINESS_UNIT_GL , A.DEPTID , B.DESCR , SUM(A.SHIP_QTY) , A.END_DT , A.LAST_UPDATE_DTTM FROM PS_IN_ITM_SHIP_DTL A , PS_LOCATION_TBL B , PS_SET_CNTRL_REC C WHERE ((A.CUST_ID = ' ') OR (A.CUST_ID <> ' ' AND EXISTS ( SELECT 'X' FROM PS_TRANSACTION_INV D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID AND A.SOURCE_BUS_UNIT = D.SOURCE_BUS_UNIT AND A.ORDER_NO = D.ORDER_NO AND A.ORDER_INT_LINE_NO = D.ORDER_INT_LINE_NO AND A.SCHED_LINE_NBR = D.SCHED_LINE_NBR AND D.DESTIN_BU <> ' ' AND D.TRANSACTION_GROUP = '035'))) AND A.LOCATION = B.LOCATION AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'FS_26' AND C.RECNAME = 'LOCATION_TBL' AND B.SETID = C.SETID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_LOCATION_TBL B1 WHERE B1.SETID = B.SETID AND B1.LOCATION = B.LOCATION AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' GROUP BY A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.START_DT , A.LOCATION , A.BUSINESS_UNIT_GL , A.DEPTID , B.DESCR , A.END_DT , A.LAST_UPDATE_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 START_DT Date(10) DATE Start Date
5 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 SHIP_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Usage Quantity
10 END_DT Date(10) DATE End Date
11 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.