| View Name: | tagged_part_requests |
| View Number: | 4666 |
| Group: | Dovetail |
| Description: | Tagged part requests |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| demand_dtl_objid | demand_dtl | objid | Part Request Objid | |
| part_request_id | demand_dtl | detail_number | Part Request Id | |
| tag_owner_objid | tag_owner(user) | objid | Tag Owner Objid | |
| condition | condition | condition | Condition Integer | |
| condition_title | condition | title | Condition Title | |
| part_request_owner_objid | part_request_owner(user) | objid | Part Request Owner Objid | |
| tag_objid | tag | objid | Tag Objid | 3 (UNIQUE) |
| tag | tag | title | Tag Title |
| Join From | Join To |
|---|---|
| (demand_dtl).demand_dtl2condition | (condition).condition2demand_dtl |
| (tag).tag2demand_dtl | (demand_dtl).demand_dtl2tag |
| (tag).tag2user | tag_owner(user).user2tag |
| (demand_dtl).demand_dtl_owner2user | part_request_owner(user).curr_owner2demand_dtl |
| tagged_part_requests | |||