| View Name: | order_line_view |
| View Number: | 6032 |
| Group: | Morder |
| Description: | Used to get order details. Used by order_framework.jsp page |
| 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 | child_offr_prod(offr_prod) | objid | Offr_prod internal record number | |
| description | child_offr_prod(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 | |
| parent_objid | parent_offr_prod(offr_prod) | objid | Offering product child-parent relation | |
| bus_org_offering | part_num | is_dom_at_bus_org | Related to bus_org indication | |
| quantity | order_line | quantity | Order line quantity | |
| change_qty | order_line | change_qty | The change to the existing quantity |
| Join From | Join To |
|---|---|
| (order_line).order_line2offr_prod | child_offr_prod(offr_prod).offr_prod2order_line |
| child_offr_prod(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_parent(mod_level).part_info2part_num | (part_num).part_num2mod_level |
| child_offr_prod(offr_prod).option2offr_prod | OUTER parent_offr_prod(offr_prod).product2offr_prod |
| order_line_view | |||