4085: mrp_sr_source_org src,
4086: mrp_sr_assignments assg,
4087: bom_cto_order_lines_gt bcol,
4088: mtl_system_items msi,
4089: ap_supplier_sites_all vend
4090:
4091: where
4092: bcol.ato_line_id = bcol.line_id
4093: and nvl(bcol.wip_supply_type,-1) <> 6
4150: mrp_sr_source_org src,
4151: mrp_sr_assignments assg,
4152: bom_cto_order_lines_gt bcol,
4153: mtl_system_items msi,
4154: ap_supplier_sites_all vend
4155:
4156: where
4157: bcol.config_item_id is not null
4158: and bcol.top_model_line_id is not null