PL_SBWC_VW

(SQL View)
 Index Back

Sub Contract Work Center View

Added this view for LSE

SELECT DISTINCT WC.BUSINESS_UNIT , WC.WORK_CENTER_CODE , WC.DESCR FROM PS_EN_RTG_OPS OPS , PS_EN_WORK_CENTER WC WHERE OPS.BUSINESS_UNIT = WC.BUSINESS_UNIT AND OPS.WORK_CENTER_CODE = WC.WORK_CENTER_CODE AND OPS.RTG_TYPE = 'PR' AND OPS.RTG_STATE = 'PR' AND OPS.SUBCONTRACTED = 'Y'

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

2 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

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