| View Name: | order_line_parts_v |
| View Number: | 5856 |
| Group: | Morder |
| Description: | To get ordered parts, detail. Used fulfillment_details.jsp |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | order_line | objid | Order_line internal record number | 3 (UNIQUE) |
| order_objid | contract | objid | Order internal record number | |
| order_action_objid | order_action | objid | Order_action internal record number | |
| offr_prod_objid | offr_prod | objid | Offr_prod internal record number | |
| description | offr_prod | description | Offering product description | |
| price_qty_objid | price_qty | objid | Price_qty internal record number | |
| parent_mod_level_objid | part_mod_parent(mod_level) | objid | Parent mod_level internal record number | |
| child_mod_level_objid | part_mod_child(mod_level) | objid | Child mod_level internal record number | |
| price_qty | price_qty | priced_qty | The quantity of the priced part being quoted. Default=1 | |
| part_num_objid | part_num | objid | part_num internal record number | |
| is_fulfilled | part_num | is_fulfilled | Whether the part is fulfilled | |
| change_ind | order_line | change_ind | Whether the part is fulfilled |
| Join From | Join To |
|---|---|
| (order_line).order_line2offr_prod | (offr_prod).offr_prod2order_line |
| (offr_prod).offr_prod2price_qty | (price_qty).price_qty2offr_prod |
| (price_qty).priced_part2mod_level | part_mod_child(mod_level).priced_part2price_qty |
| (price_qty).context_part2mod_level | part_mod_parent(mod_level).context_part2price_qty |
| (order_line).order_line2order_action | (order_action).order_action2order_line |
| (order_action).order_action2contract | (contract).contract2order_action |
| part_mod_child(mod_level).part_info2part_num | (part_num).part_num2mod_level |
| order_line_parts_v | |||