EN_BOM_MMC_VW

(SQL View)
 Index Back

MBOM MMC process inst view


SELECT DISTINCT A.BUSINESS_UNIT ,A.PROCESS_INSTANCE ,A.EIP_DTA_STATUS ,C.MASS_MAINT_CODE ,C.DESCR FROM PS_EN_TRNS_TMP A , PS_EN_ASSY_TRN_TMP B , PS_EN_BOM_MMC_HDR C WHERE A.PROCESS_INSTANCE <> 0 AND A.EIP_DTA_STATUS IN ('0','1','2','4','6') AND A.EN_TRANSFER_SOURCE = 'M' AND B.EIP_CTL_ID = A.EIP_CTL_ID AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.MASS_MAINT_CODE = B.MASS_MAINT_CODE AND C.ORIGIN = 'EN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold
4 MASS_MAINT_CODE Character(10) VARCHAR2(10) NOT NULL Mass Maintenance Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description