EN_TRN_EBOM_VW

(SQL View)
 Index Back

Mass Maint Staged BOMs Search

01/22/00 LAJ...CN#EN800 Search record for BOM Mass Maintenance Staged BOMs component. This view only picks up rows generated by Mass Maint (en_transfer_source = 'M') against EBOMS (copy_direction = 'EE').

SELECT B.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.BOM_STATE , A.BOM_TYPE , A.BOM_CODE , A.BOM_TRANSFER_STAT , B.EIP_DTA_STATUS , A.EIP_CTL_ID FROM PS_EN_TRN_HDR_TMP A , PS_EN_TRNS_TMP B WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND B.EN_TRANSFER_SOURCE = 'M' AND B.COPY_DIRECTION = 'EE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

Prompt Table: EN_TRN_EBMPI_VW

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUMGOP_NONVW

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 BOM_STATE Character(2) VARCHAR2(2) NOT NULL BOM State
EN=Engineering
PR=Manufacturing
5 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
6 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
7 BOM_TRANSFER_STAT Character(1) VARCHAR2(1) NOT NULL 02/01/00 LAJ Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction. Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status 05/18/00 LAJ Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error
O=No Change
T=Transfer
U=No Errors
W=Warning
8 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
9 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field