View Name:grp_in_offr_view
View Number:5995
Group:Morder
Description:Used for retrieving the offering that a specific offering group belongs to
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidofferingobjidOffering internal record number 3 (UNIQUE)
idofferingidOffering ID;populated from the numbering scheme 
titleofferingtitleName of an offering 
statusofferingstatusOffering status. Populated through a user defined popup list 
effective_dateofferingeffective_dtEffective date of offering 
expiry_dateofferingexpiry_dtOffering expiry date 
owneruserlogin_nameUser that owns the offering 
versionofferingversionOffering Version 
offering_grp_objidoffering_grpobjidOffering Group objid 
offering_grp_role_objidoffr_grp_roleobjidOffering Group Role objid 

Joins:

Join FromJoin To
(offering).offering2user(user).user2offering
(offr_grp_role).offr_grp_role2offering(offering).offering2offr_grp_role
(offr_grp_role).offr_grp_role2offering_grp(offering_grp).offr_grp2offr_grp_role
My Recent Objects
grp_in_offr_view