BCT_MG_CPL_VW

(SQL View)
 Index Back

Barcode Compl/Scrap Search

02/22/01 MDS CN#R-MGENOC-BB6GQ: Created new BCT view for deferred processing changes. 08/28/01 MEG CN#MG840: Since Message Agent is gone put in prompt table edits.

SELECT A.BUSINESS_UNIT , X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_BUS_UNIT_TBL_IN A , PSXLATITEM X WHERE A.BU_STATUS = '1' AND X.FIELDNAME = 'TRANSACTION_CODE' AND X.fieldvalue BETWEEN '0211' AND '0213' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

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

2 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code

Prompt Table: BCT_T_MG_CPL_VW

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name