APPS.WIP_PICKING_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 99: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

95: bind variables, use table joins. Also added rownum in the subquery */
96:
97: CURSOR c_repLines IS
98: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
99: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
100: where wro.wip_entity_id = p_wip_entity_id
101: and wro.repetitive_schedule_id = p_repetitive_schedule_id
102: and mtrl.txn_source_id = wro.wip_entity_id
103: and mtrl.reference_id = wro.repetitive_schedule_id

Line 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. */

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 */

Line 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

Line 141: from mtl_txn_request_lines mtrl, wip_entities we

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

Line 260: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

256: l_dummy VARCHAR2(1);
257:
258: CURSOR c_repLines IS
259: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
260: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
261: where mtrl.txn_source_id = p_wip_entity_id
262: and mtrl.reference_id = p_repetitive_schedule_id
263: and wro.wip_entity_id = p_wip_entity_id
264: and wro.repetitive_schedule_id = p_repetitive_schedule_id

Line 280: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

276: for update of wro.quantity_allocated, quantity_backordered nowait;
277:
278: CURSOR c_discLines IS
279: select line_id, (nvl(quantity_detailed,0) - nvl(quantity_delivered,0)) open_quantity, wro.rowid
280: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
281: where mtrl.txn_source_id = p_wip_entity_id
282: and wro.wip_entity_id = p_wip_entity_id
283: and wro.operation_seq_num = p_operation_seq_num
284: and mtrl.txn_source_line_id = wro.operation_seq_num

Line 423: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

419: l_reductionQty NUMBER;
420:
421: CURSOR c_repLines(v_wip_entity_id NUMBER, v_repetitive_schedule_id NUMBER, v_operation_seq_num NUMBER, v_inventory_item_id NUMBER) IS
422: select line_id, nvl(mtrl.required_quantity,(nvl(quantity_detailed,0) - nvl(quantity_delivered,0))) open_quantity, wro.rowid
423: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
424: where mtrl.txn_source_id = v_wip_entity_id
425: and mtrl.reference_id = v_repetitive_schedule_id
426: and wro.wip_entity_id = v_wip_entity_id
427: and wro.repetitive_schedule_id = v_repetitive_schedule_id

Line 445: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

441: for update of wro.quantity_allocated, quantity_backordered nowait;
442:
443: CURSOR c_discLines(v_wip_entity_id NUMBER, v_operation_seq_num NUMBER, v_inventory_item_id NUMBER) IS
444: select line_id, nvl(mtrl.required_quantity,(nvl(quantity_detailed,0) - nvl(quantity_delivered,0))) open_quantity, wro.rowid
445: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
446: where mtrl.txn_source_id = v_wip_entity_id
447: and wro.wip_entity_id = v_wip_entity_id
448: and wro.operation_seq_num = v_operation_seq_num
449: and mtrl.txn_source_line_id = wro.operation_seq_num

Line 571: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

567: x_return_status OUT NOCOPY VARCHAR2,
568: x_msg_data OUT NOCOPY VARCHAR2) IS
569: CURSOR c_repLines IS
570: select line_id
571: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
572: where mtrl.txn_source_id = p_wip_entity_id
573: and mtrl.txn_source_line_id = p_repetitive_schedule_id
574: and wro.wip_entity_id = p_wip_entity_id
575: and wro.repetitive_schedule_id = p_repetitive_schedule_id

Line 590: from mtl_txn_request_lines mtrl, wip_requirement_operations wro

586: for update of wro.quantity_allocated, wro.quantity_backordered nowait; --make sure no orders are transacted in the meantime
587:
588: CURSOR c_discLines IS
589: select line_id
590: from mtl_txn_request_lines mtrl, wip_requirement_operations wro
591: where mtrl.txn_source_id = p_wip_entity_id
592: and wro.wip_entity_id = p_wip_entity_id
593: and wro.operation_seq_num = 1
594: and mtrl.txn_source_line_id = wro.operation_seq_num