[Home] [Help]
114: and rownum = 1)
115:
116: for update of wro.quantity_allocated, quantity_backordered nowait;
117:
118: /* 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. */
119:
120: CURSOR c_discLines IS
121: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
122: from mtl_txn_request_lines mtrl, wip_requirement_operations wro, wip_entities we /* bug 4211266 */
118: /* 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. */
119:
120: CURSOR c_discLines IS
121: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
122: from mtl_txn_request_lines mtrl, wip_requirement_operations wro, wip_entities we /* bug 4211266 */
123: where we.wip_entity_id = p_wip_entity_id
124: and wro.organization_id = we.organization_id
125: and wro.wip_entity_id = we.wip_entity_id
126: and mtrl.organization_id = wro.organization_id
139: /* End of Bugfix 4743190 */
140:
141: CURSOR c_flowLines IS
142: select line_id
143: from mtl_txn_request_lines mtrl, wip_entities we
144: where mtrl.TRANSACTION_TYPE_ID = INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR -- 51
145: and mtrl.TRANSACTION_SOURCE_TYPE_ID = INV_Globals.G_SOURCETYPE_INVENTORY --13
146: and mtrl.txn_source_id = we.wip_entity_id
147: and mtrl.organization_id = we.organization_id
1540: the messages user-friendly */
1541: begin
1542: select we.wip_entity_name, msi.concatenated_segments
1543: into l_jobname, l_item
1544: from wip_entities we, mtl_system_items_vl msi
1545: where we.wip_entity_id = x_MOLineErrTbl(i).txn_source_id
1546: and msi.inventory_item_id = x_MOLineErrTbl(i).inventory_item_id
1547: and msi.organization_id = x_MOLineErrTbl(i).organization_id;
1548: exception
2204: select we.wip_entity_id,
2205: we.wip_entity_name,
2206: wdj.project_id,
2207: wdj.task_id
2208: from wip_entities we,
2209: wip_discrete_jobs wdj,
2210: wip_parameters wp
2211: where we.wip_entity_id = wdj.wip_entity_id
2212: and we.organization_id = wdj.organization_id
2237: select distinct we.wip_entity_id,
2238: we.wip_entity_name,
2239: wdj.project_id,
2240: wdj.task_id
2241: from wip_entities we,
2242: wip_discrete_jobs wdj,
2243: wip_requirement_operations wro,
2244: wip_parameters wp,
2245: wip_operations wo
2279: we.wip_entity_name,
2280: wdj.project_id,
2281: wdj.task_id,
2282: min(wro.date_required) min_date_required
2283: from wip_entities we,
2284: wip_discrete_jobs wdj,
2285: wip_parameters wp,
2286: wip_requirement_operations wro,
2287: wip_operations wo
2321: CURSOR c_rep is
2322: select distinct we.wip_entity_id,
2323: (wl.line_code || ':' || msik.concatenated_segments || ':' || wrs.first_unit_start_date ) title,
2324: wrs.repetitive_schedule_id
2325: from wip_entities we,
2326: mtl_system_items_kfv msik,
2327: wip_repetitive_schedules wrs,
2328: wip_repetitive_items wri,
2329: wip_requirement_operations wro,
2484: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/
2485: select meaning
2486: into l_outBuffer
2487: from mfg_lookups
2488: where lookup_type = 'WIP_ENTITIES'
2489: and lookup_code = p_job_type ;
2490:
2491: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
2492: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);