| View Name: | part_in_offr_view |
| View Number: | 5994 |
| Group: | Morder |
| Description: | Used for retrieving the part belonging to an offer (Used in Screen 122034). Used in offering_product.jsp page |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | offering | objid | Offering internal record number | 3 (UNIQUE) |
| id | offering | id | Offering ID;populated from the numbering scheme | |
| title | offering | title | Name of an offering | |
| status | offering | status | Offering status. Populated through a user defined popup list | |
| effective_date | offering | effective_dt | Effective date of offering | |
| expiry_date | offering | expiry_dt | Offering expiry date | |
| owner | user | login_name | User that owns the offering | |
| mod_level_objid | mod_level | objid | Mod_level internal record number | |
| version | offering | version | Offering Version |
| Join From | Join 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 |
| (offr_prod).offr_prod2offering_grp | (offering_grp).offering_grp2offr_prod |
| (offr_prod).offr_prod2price_qty | (price_qty).price_qty2offr_prod |
| (price_qty).priced_part2mod_level | (mod_level).priced_part2price_qty |
| part_in_offr_view | |||