BCT_MG_PRDN_VW (SQL View)	Index Back
Rec Assembly Serl Srch Record Search record for Record Assembly Serial page

BCT_MG_PRDN_VW

(SQL View)

Rec Assembly Serl Srch Record

Search record for Record Assembly 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 '0800' AND '0801' 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_PRD_VW

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

#	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_PRD_VW
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
4	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name