PL_ITEM_EXPT_VW

(SQL View)
Index Back

PLanning Items Exception View

05/23/02 EGS (CN#PL900-1): Added.

SELECT DISTINCT BUSINESS_UNIT , INV_ITEM_ID FROM PS_PL_PR_MESS_SPL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 INV_ITEM_ID_WRK Character(18) VARCHAR2(18) NOT NULL Work Item ID