BCT_MG_USAG_VW

(SQL View)
 Index Back

Record Comp Serial Srch Record

Search record for Record Component Serial page

SELECT A.BUSINESS_UNIT , X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PS_BUS_UNIT_TBL_MG A , PSXLATITEM X WHERE A.BU_STATUS = '1' AND X.FIELDNAME = 'TRANSACTION_CODE' AND X.FIELDVALUE BETWEEN '0802' AND '0804' 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_USG_VW

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