CP_BU_ITEMS_VW (SQL View)	Index Back
CP Production View View of CP Production - BU_ITEMS_INV, MASTER_ITEM_TBL, INV_ITEMS, CM_ITEM_SFLG_VW

CP_BU_ITEMS_VW

(SQL View)

CP Production View

View of CP Production - BU_ITEMS_INV, MASTER_ITEM_TBL, INV_ITEMS, CM_ITEM_SFLG_VW

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , D.EFFDT , A.PHANTOM_ITEM_FLAG , B.CFG_CODE_OPT , B.PRDN_CFG_FLAG FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_INV_ITEMS D , PS_CM_ITEM_SFLG_VW E WHERE A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.INV_ITEM_ID = D.INV_ITEM_ID AND A.INV_ITEM_ID = E.INV_ITEM_ID AND A.ITM_STATUS_CURRENT = '1' AND E.CM_MFG_ITEM_FLG = 0 AND B.INVENTORY_ITEM = 'Y' AND A.STAGED_DATE_FLAG = 'N' AND B.SETID = D.SETID AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.RECNAME = 'MASTER_ITEM_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 PHANTOM_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Phantom Item

5 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes

6 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	PHANTOM_ITEM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Phantom Item
5	CFG_CODE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Configuration Code Generation B=Both N=No Y=Yes
6	PRDN_CFG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Production Configuration