[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: |
1348: l_stmt_num := 9;
1349:
1350: select dj.wip_entity_id, we.wip_entity_name
1351: into l_wip_entity_id, l_job_name
1352: from wip_discrete_jobs dj, wip_entities we,
1353: oe_order_lines_all oel
1354: where dj.wip_entity_id = we.wip_entity_id
1355: and dj.source_line_id = l_line_id
1356: and dj.source_code = 'WICDOL'
1353: oe_order_lines_all oel
1354: where dj.wip_entity_id = we.wip_entity_id
1355: and dj.source_line_id = l_line_id
1356: and dj.source_code = 'WICDOL'
1357: --bugfix 2885568 to remove full table scan on wip_discrete_jobs
1358: --use unique index of wip_enitity _id and organization_id
1359: and oel.line_id = l_line_id
1360: and dj.primary_item_id = oel.inventory_item_id --for using index wdj_N1
1361: and oel.ship_from_org_id = dj.organization_id ;--for using index wdj_u1
1683: oe_debug_pub.add('reserve_wo_to_so: ' || 'Message Text = '||l_msg_txt,1);
1684: END IF;
1685:
1686: l_stmt_num := 100;
1687: update wip_discrete_jobs
1688: set status_type = 7 -- CANCELLED
1689: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1690:
1691: l_stmt_num := 110;
1766: oe_debug_pub.add('reserve_wo_to_so: ' || 'Msg Txt from delete reservation: ' || l_msg_txt,1);
1767: END IF;
1768:
1769: l_stmt_num := 130;
1770: update wip_discrete_jobs
1771: set status_type = 7 -- CANCEL
1772: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1773:
1774: l_stmt_num := 140;