View Name:cont_subs_for_sim
View Number:6030
Group:Morder
Description:Used to get all the subscription(site_part) that belong to the contact. Used in subscriptions_list.jsp page
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_cont_subs_for_sim
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
rol_objidcon_sp_roleobjidCon_sp_role internal record number 3 (UNIQUE)
sp_objidsite_partobjidSite_part internal record number 
statussite_partpart_statusSite Configuration installed part status. This is a user-defined popup with default name PART_STATUS 
instance_namesite_partinstance_nameDefault is the concatination of part name, part number, and part revision. May be customized 
contact_objidcontactobjidContact internal record number 
first_namecontactfirst_nameContact's first name 
last_namecontactlast_nameContact's last name 
role_namecon_sp_rolerole_nameName of the role 
level_to_partsite_partlevel_to_partRelative installation hierarchy level to a part 
serial_nosite_partserial_noInstalled part serial number 
account_objidbus_orgobjidAccount belonged to the order 

Joins:

Join FromJoin To
(con_sp_role).con_sp_role2site_part(site_part).site_part2con_sp_role
(con_sp_role).con_sp_role2contact(contact).contact2con_sp_role
(site_part).site_part2site(site).customer2site_part
(bus_site_role).bus_site_role2site(site).site2bus_site_role
(bus_site_role).bus_site_role2bus_org(bus_org).bus_org2bus_site_role
My Recent Objects
cont_subs_for_sim      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user