View Name:offr_prod_view
View Number:5993
Group:Morder
Description:Presents the products belonging to a certain offer (Screen ID 122023) Used in offering_pricing.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidchild_offr_prod(offr_prod)objidOffering product internal record number 3 (UNIQUE)
min_numberchild_offr_prod(offr_prod)min_numberMinimum number of product / option that must be taken up in the offering. Default=1 
max_numberchild_offr_prod(offr_prod)max_numberMaximum number of product / option that must be taken up in the offering. Default=1 
descriptionchild_offr_prod(offr_prod)descriptionOffering product description 
parent_objidparent_offr_prod(offr_prod)objidOffering product internal record number 
part_num_objidpart_numobjidPart_num internal record number 
part_numberpart_numpart_numberPart number/name 
dom_at_bus_orgpart_numis_dom_at_bus_orgPart_num internal record number 
price_qty_objidprice_qtyobjidPrice_qty internal record number 
mod_levelchild_mod_level(mod_level)mod_levelName of part revision 
child_mod_level_objidchild_mod_level(mod_level)objidChild mod_level internal record number 
offering_grp_objidoffering_grpobjidOffering group internal record number 
offer_grp_role_objidoffr_grp_roleobjidOffering group role internal record number 
offering_objidofferingobjidOffering internal record number 
is_mandatorychild_offr_prod(offr_prod)is_mandatoryWhether product is mandatory in the group;1=Yes, 0=No;default=0 
offer_grp_roleoffr_grp_rolerole_nameOffering group role 
is_commonoffering_grpis_commonIndicates that the offering group can be shared between offering 

Joins:

Join FromJoin To
(offr_grp_role).offr_grp_role2offering(offering).offering2offr_grp_role
(offr_grp_role).offr_grp_role2offering_grp(offering_grp).offr_grp2offr_grp_role
child_offr_prod(offr_prod).offr_prod2offering_grp(offering_grp).offering_grp2offr_prod
child_offr_prod(offr_prod).option2offr_prodOUTER parent_offr_prod(offr_prod).product2offr_prod
child_offr_prod(offr_prod).offr_prod2price_qty(price_qty).price_qty2offr_prod
(price_qty).priced_part2mod_levelchild_mod_level(mod_level).priced_part2price_qty
child_mod_level(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
offr_prod_view