BU_ITM_INV_VW8 (SQL View)	Index Back
Item Business Unit Prompt View BU item promt view that will bring back all Items with status of Active or Discontinue 04/16/04 MEG CN#IN890 Data Model Changes - Replaced DEMAND_INV with IN_DEMAND. Check in_fulfill_state instead of cancel_flag.

BU_ITM_INV_VW8

(SQL View)

Item Business Unit Prompt View

BU item promt view that will bring back all Items with status of Active or Discontinue 04/16/04 MEG CN#IN890 Data Model Changes - Replaced DEMAND_INV with IN_DEMAND. Check in_fulfill_state instead of cancel_flag.

SELECT DISTINCT A.BUSINESS_UNIT , A.INV_ITEM_ID FROM PS_BU_ITEMS_INV A , PS_IN_DEMAND D WHERE A.INVENTORY_ITEM = 'Y' AND A.ITM_STATUS_CURRENT IN ('1','3') AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.INV_ITEM_ID = D.INV_ITEM_ID AND D.IN_FULFILL_STATE = '30' AND D.HOLD_FLAG = 'N' AND D.FULFILL_FLAG = 'Y' AND D.CONFIRMED_FLAG = 'N' AND D.PICK_BATCH_ID = 0

# 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
Prompt Table: SP_BUIN_NONVW

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