View Name:product_packages_view
View Number:5806
Group:Morder
Description:Used by form Bill of Materials(617), Depot Repair, De-bundle(8422); BOM Info. Used by product_package.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_mod_child(mod_level)objidPart_mod_child internal record number  3 (UNIQUE)
part_nopart_numpart_numberPart number/name 
descriptionpart_numdescriptionPart description  
mod_levelpart_mod_child(mod_level)mod_levelRevision number  
qtypart_qtyquantityQuantity of the part revision called for at a position in a BOM's hierarchy 
is_sharedpart_qtyis_sharedIndicates that BOM part can be shared across installed parts.1=shared, 0=not shared; default=0 
part_typepart_numpart_typeAssigns a part type (separate from a domain). This is from a user-defined popup with default name PART_TYPE 
domainpart_numdomainName of the domain for the part num. See object prt_domain 
activepart_numactiveActive/inactive/obsolete 
part_num_objidpart_numobjidPart_num internal record number  
parent_objidpart_mod_parent(mod_level)objidParent mod_level internal record number  
qty_objidpart_qtyobjidPart_qty internal record number  
is_main_resourcepart_qtyis_main_resourceIndicates that this part for the BOM is the main part. Used in resources to indicate main resource for BOM..1=main resource, 0=not a main resource; default=0 
familypart_numfamilyMarketing product family the part belongs to 
dom_is_servicepart_numdom_is_serviceIndicates if the part is a service part 

Joins:

Join FromJoin To
(part_qty).part_qty2part_infopart_mod_parent(mod_level).part_info2part_qty
(part_qty).part_qty2part_inclpart_mod_child(mod_level).part_incl2part_qty
part_mod_child(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
product_packages_view