USAGE_DE_INV_VW

(SQL View)
 Index Back

Usage Data Entry - Prompt

Consumer Usage Entry - Search Prompt

SELECT A.BUSINESS_UNIT , B.LOCATION FROM PS_BUS_UNIT_TBL_IN A , PS_LOCATION_TBL B WHERE A.BU_STATUS = '1' AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'LOCATION_TBL')

# 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 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT