[Home] [Help]
112: and rownum = 1)
113:
114: for update of wro.quantity_allocated, quantity_backordered nowait;
115:
116: /* Bugfix 4211265: Cursor c_discLines is doing an FTS on mtrl. We will join with wip_entities to get the organization_id and join with mtrl thru wro so that index MTL_TXN_REQUEST_LINES_N1 can be used. */
117:
118: CURSOR c_discLines IS
119: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
120: from mtl_txn_request_lines mtrl, wip_requirement_operations wro, wip_entities we /* bug 4211266 */
116: /* Bugfix 4211265: Cursor c_discLines is doing an FTS on mtrl. We will join with wip_entities to get the organization_id and join with mtrl thru wro so that index MTL_TXN_REQUEST_LINES_N1 can be used. */
117:
118: CURSOR c_discLines IS
119: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
120: from mtl_txn_request_lines mtrl, wip_requirement_operations wro, wip_entities we /* bug 4211266 */
121: where we.wip_entity_id = p_wip_entity_id
122: and wro.organization_id = we.organization_id
123: and wro.wip_entity_id = we.wip_entity_id
124: and mtrl.organization_id = wro.organization_id
137: /* End of Bugfix 4743190 */
138:
139: CURSOR c_flowLines IS
140: select line_id
141: from mtl_txn_request_lines mtrl, wip_entities we
142: where mtrl.TRANSACTION_TYPE_ID = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR -- 51
143: and mtrl.TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SOURCETYPE_INVENTORY --13
144: and mtrl.txn_source_id = we.wip_entity_id
145: and mtrl.organization_id = we.organization_id
1520: the messages user-friendly */
1521: begin
1522: select we.wip_entity_name, msi.concatenated_segments
1523: into l_jobname, l_item
1524: from wip_entities we, mtl_system_items_vl msi
1525: where we.wip_entity_id = x_MOLineErrTbl(i).txn_source_id
1526: and msi.inventory_item_id = x_MOLineErrTbl(i).inventory_item_id
1527: and msi.organization_id = x_MOLineErrTbl(i).organization_id;
1528: exception
2166: select distinct we.wip_entity_id,
2167: we.wip_entity_name,
2168: wdj.project_id,
2169: wdj.task_id
2170: from wip_entities we,
2171: wip_discrete_jobs wdj,
2172: wip_requirement_operations wro,
2173: wip_parameters wp,
2174: wip_operations wo
2195: select distinct we.wip_entity_id,
2196: we.wip_entity_name,
2197: wdj.project_id,
2198: wdj.task_id
2199: from wip_entities we,
2200: wip_discrete_jobs wdj,
2201: wip_requirement_operations wro,
2202: wip_parameters wp,
2203: wip_operations wo
2230: CURSOR c_rep is
2231: select distinct we.wip_entity_id,
2232: (wl.line_code || ':' || msik.concatenated_segments || ':' || wrs.first_unit_start_date ) title,
2233: wrs.repetitive_schedule_id
2234: from wip_entities we,
2235: mtl_system_items_kfv msik,
2236: wip_repetitive_schedules wrs,
2237: wip_repetitive_items wri,
2238: wip_requirement_operations wro,
2388: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/
2389: select meaning
2390: into l_outBuffer
2391: from mfg_lookups
2392: where lookup_type = 'WIP_ENTITIES'
2393: and lookup_code = p_job_type ;
2394:
2395: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
2396: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);