EN_STGECOBOM_VW (SQL View)	Index Back
Staged BOM errors by ECO 2/20/03 RML Agile Integration - staging BOM errors by ECO (stored in text254 field in en_trn_hdr_tmp). NOTE: orig_dt_timestamp for BOM transactions in eo_eip_ctl is unique. This means all the transactions in the same run does not have the same timestamp like Item. The join to en_trn_cmp_tmp is to filter out all mass maintenance transactions

EN_STGECOBOM_VW

(SQL View)

Staged BOM errors by ECO

2/20/03 RML Agile Integration - staging BOM errors by ECO (stored in text254 field in en_trn_hdr_tmp). NOTE: orig_dt_timestamp for BOM transactions in eo_eip_ctl is unique. This means all the transactions in the same run does not have the same timestamp like Item. The join to en_trn_cmp_tmp is to filter out all mass maintenance transactions

SELECT DISTINCT b.TEXT254 , a.ORIG_DT_TIMESTAMP , a.EIP_DTA_STATUS , a.PUBID FROM PS_EO_EIP_CTL a , PS_EN_TRN_HDR_TMP b , PS_EN_TRN_CMP_TMP c WHERE (a.MSGNAME = 'ITEM_SYNC' OR a.MSGNAME = 'BOM_SYNC') AND a.EIP_REFERENCE LIKE 'PDX%' AND a.EIP_CTL_ID = b.EIP_CTL_ID AND b.TEXT254 <> ' ' AND a.EIP_DTA_STATUS <> '2' AND b.EIP_CTL_ID = c.EIP_CTL_ID AND c.MASS_MAINT_CODE = ' ' AND a.ORIG_DT_TIMESTAMP = ( SELECT MIN(x.ORIG_DT_TIMESTAMP) FROM PS_EO_EIP_CTL x , PS_EN_TRN_HDR_TMP y WHERE x.PUBID = a.PUBID AND x.EIP_CTL_ID = y.EIP_CTL_ID AND y.TEXT254 = b.TEXT254)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

2 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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 PUBID Signed Number(11,0) DECIMAL(10) NOT NULL Publication Identifier

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
2	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
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	PUBID	Signed Number(11,0)	DECIMAL(10) NOT NULL	Publication Identifier