EG_BOM_AUDEG_VW

(SQL View)
 Index Back

ECO EBOM Time stamped audit VW

CN# EN800-3.0, Sep 21 98, Anna Added field BomCode

SELECT a.business_unit , a.inv_item_id , a.bom_type , a.eg_datetime , a.oprid FROM PS_EG_BOM_AUDIT a WHERE (copy_direction='ME' OR copy_direction = 'EE') AND a.eg_datetime = ( SELECT MAX(eg_datetime) FROM PS_EG_BOM_AUDIT WHERE business_unit = a.business_unit AND inv_item_id=a.inv_item_id AND bom_type = a.bom_type AND (copy_direction='ME' OR copy_direction = 'EE'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 BOM_TYPE Character(2) VARCHAR2(2) NOT NULL 03/26/00 RML Added a label "Type"
PR=Production
RW=Rework
4 EG_DATETIME DateTime(26) TIMESTAMP NOT NULL Copy Date / Time
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).