IN_WO_COMMIT_VW

(SQL View)
 Index Back

WM inventory commit default vw

View used by Inventory to derive the Work Management default values for the Inventory commit rule at the WO business unit and shop default levels

SELECT A.BUSINESS_UNIT , B.SHOP_ID , B.EFFDT , A.WO_INV_COMMIT_RULE , A.INTERNAL_STAT_COMM , B.WO_INV_COMMIT_DEF , B.WO_INV_COMMIT_RULE , B.INTERNAL_STAT_COMM FROM PS_BUS_UNIT_TBL_WM A , PS_WM_SHOP_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_WM_SHOP_HDR A1 WHERE A1.BUSINESS_UNIT = B.BUSINESS_UNIT AND A1.SHOP_ID = B.SHOP_ID AND A1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 WO_INV_COMMIT_RULE Character(1) VARCHAR2(1) NOT NULL Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Commit at Reserve
5 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
6 WO_INV_COMMIT_DEF Character(1) VARCHAR2(1) NOT NULL Bank Flag
D=Default
S=Specify
7 SHOP_COMMIT_RULE Character(1) VARCHAR2(1) NOT NULL Work Management Shop inventory commit rule
8 SHOP_INTERNAL_STAT Character(2) VARCHAR2(2) NOT NULL Work Management interanl shop status for inventory commit rule