BU_ITM_INV_LVW9 (SQL View)	Index Back
Item Business Unit Prompt View BU item promt view that will bring back all Items with status of Active, Hold, Discontinue, and Inactive and Consigned Flag = 'Y'

BU_ITM_INV_LVW9

(SQL View)

Item Business Unit Prompt View

BU item promt view that will bring back all Items with status of Active, Hold, Discontinue, and Inactive and Consigned Flag = 'Y'

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , E.language_cd , E.DESCR FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , ps_master_itm_lang e WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL' AND B.SETID = C.SETID AND e.setid = b.setid AND e.setid = c.setid AND A.INV_ITEM_ID = B.INV_ITEM_ID AND a.inv_item_id = e.inv_item_id

# 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_VW

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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_VW
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description