View Name:pc_revisions_view
View Number:5808
Group:Morder
Description:Fake view.Used to price at revision level by form RMA Request Details(502), More RMA Info(503), Part Request Detail(507), More (Part Request) Info (509) and Pricing(511). Used by product_revisions.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_pc_revisions_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidfake_baseobjidInternal record number 3 (UNIQUE)
mod_levelfake_basetext_fieldRevision level 
activefake_basetext_fieldActive/inactive/obsolete 
part_objidfake_baseobjidPart_num internal record number  
part_numberfake_basetext_fieldPart number  
replaced_datefake_basedate_fieldIf obsolete, specifies date and time of obsolescence 
replaced_objidfake_baseobjidReplaced mod_level internal record number  
replaced_mod_levelfake_basetext_fieldReplaced revision level 
replaced_part_objidfake_baseobjidReplaced part_num internal record number  
replaced_part_numberfake_basetext_fieldReplaced part number  
replaces_objidfake_baseobjidReplaces mod_level internal record number  
replaces_mod_levelfake_basetext_fieldReplaces revision level 
replaces_part_objidfake_baseobjidReplaces part_num internal record number  
replaces_part_numberfake_basetext_fieldReplaces part number  
replaces_datefake_basedate_fieldIf obsolete, specifies date and time of obsolescence 

Joins:

Join FromJoin To
(fake_join).fake_join2fake_base(fake_base).fake_base2fake_join
My Recent Objects
pc_revisions_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user