[Home] [Help]
112: |
113: |
114: |19-Nov-2003 : Kiran Konada
115: | bugfix 2885568
116: | There was a full table scan on wip_discrete_jobs
117: | unique index present on wip_enity_id and organization_id
118: | hece, joined oe_order_lines_all and got the ship_from _org_id
119: |
120: | original query
119: |
120: | original query
121: | select dj.wip_entity_id, we.wip_entity_name
122: | into l_wip_entity_id, l_job_name
123: | from wip_discrete_jobs dj, wip_entities we|
124: | where dj.wip_entity_id = we.wip_entity_id
125: | and dj.source_line_id = l_line_id
126: | and dj.source_code = 'WICDOL'
127: |
1204: l_stmt_num := 9;
1205:
1206: select dj.wip_entity_id, we.wip_entity_name
1207: into l_wip_entity_id, l_job_name
1208: from wip_discrete_jobs dj, wip_entities we,
1209: oe_order_lines_all oel
1210: where dj.wip_entity_id = we.wip_entity_id
1211: and dj.source_line_id = l_line_id
1212: and dj.source_code = 'WICDOL'
1209: oe_order_lines_all oel
1210: where dj.wip_entity_id = we.wip_entity_id
1211: and dj.source_line_id = l_line_id
1212: and dj.source_code = 'WICDOL'
1213: --bugfix 2885568 to remove full table scan on wip_discrete_jobs
1214: --use unique index of wip_enitity _id and organization_id
1215: and oel.line_id = l_line_id
1216: and dj.primary_item_id = oel.inventory_item_id --for using index wdj_N1
1217: and oel.ship_from_org_id = dj.organization_id ;--for using index wdj_u1
1537: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Text = '||l_msg_txt,1);
1538: END IF;
1539:
1540: l_stmt_num := 100;
1541: update wip_discrete_jobs
1542: set status_type = 7 -- CANCELLED
1543: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1544:
1545: l_stmt_num := 110;
1620: oe_debug_pub.add('reserve_wo_to_so: ' || 'Msg Txt from delete reservation: ' || l_msg_txt,1);
1621: END IF;
1622:
1623: l_stmt_num := 130;
1624: update wip_discrete_jobs
1625: set status_type = 7 -- CANCEL
1626: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1627:
1628: l_stmt_num := 140;