View Name:offr_search_prod_view
View Number:6065
Group:Morder
Description:Lists the products along with their prices. Used in product_list_single_select.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
mod_level_objidchild_mod_level(mod_level)objidChild mod_level internal record number 
part_nopart_numpart_numberPart number/name 
descriptionpart_numdescriptionProduct description 
mod_levelchild_mod_level(mod_level)mod_levelName of part revision 
familypart_numfamilyMarketing product family, of the part. This is a user-defined popup with default name FAMILY and level name lev1 
linepart_numlineMarketing product line, within family, of the part. This is a user-defined popup with default name FAMILY and level name lev2 
part_typepart_numpart_typePart number/name 
domainpart_numdomainName of the domain for the part num. See object prt_domain 
activepart_numactiveActive/inactive/obsolete 
mod_activechild_mod_level(mod_level)activeActive/inactive/obsolete 
part_num_objidpart_numobjidPart internal record number 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
objidprice_qtyobjidPrice_qty internal record number 3 (UNIQUE)
p_qty_typeprice_qtyp_qty_typeType of price_qty; 0=is a standalone part, 1=is a parent or child part 
par_mod_level_objidparent_mod_level(mod_level)objidParent mod_level internal record number 

Joins:

Join FromJoin To
child_mod_level(mod_level).part_info2part_num(part_num).part_num2mod_level
(price_qty).priced_part2mod_levelchild_mod_level(mod_level).priced_part2price_qty
(price_qty).context_part2mod_levelparent_mod_level(mod_level).context_part2price_qty
My Recent Objects
offr_search_prod_view