APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_TXN_REQUEST_LINES

Line 205: AND EXISTS (SELECT 1 FROM mtl_txn_request_lines

201: FROM mtl_reservations
202: WHERE lpn_id=p_lpn_id
203: AND organization_id=p_org_id
204: AND external_source_code='XDOCK'
205: AND EXISTS (SELECT 1 FROM mtl_txn_request_lines
206: WHERE lpn_id=p_lpn_id
207: AND organization_id=p_org_id
208: AND line_status=7
209: AND ROWNUM=1

Line 300: | 2. mtl_txn_request_lines |

296: | Plsql table to hold the errored out lpn_ids and line_ids. |
297: | |
298: | Tables Used: |
299: | 1. mtl_txn_request_headers |
300: | 2. mtl_txn_request_lines |
301: +===========================================================================*/
302: --
303: PROCEDURE pre_generate(
304: x_return_status OUT NOCOPY VARCHAR2,

Line 379: mtl_txn_request_lines mol

375:
376: CURSOR mol_cursor IS
377: SELECT mol.line_id, mol.line_number
378: FROM mtl_txn_request_headers moh,
379: mtl_txn_request_lines mol
380: WHERE mol.header_id = moh.header_id
381: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
382: AND mol.organization_id = p_organization_id
383: AND mol.lpn_id is not null

Line 400: mtl_txn_request_lines mol,

396: mol.line_id,
397: mol.txn_source_id --- for bug 7190056
398: FROM
399: mtl_txn_request_headers moh,
400: mtl_txn_request_lines mol,
401: wms_license_plate_numbers lpn
402: WHERE mol.header_id = moh.header_id
403: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
404: AND mol.organization_id = p_organization_id

Line 433: mtl_txn_request_lines mol

429: mol.backorder_delivery_detail_id, -- added for ATF_J
430: mol.crossdock_type -- added for ATF_J
431: FROM
432: mtl_material_transactions_temp mmtt,
433: mtl_txn_request_lines mol
434: WHERE mmtt.move_order_line_id = l_line_id
435: AND mol.line_id = l_line_id;
436:
437:

Line 530: FROM mtl_txn_request_lines

526: SELECT 1
527: INTO l_process_flag_count
528: FROM DUAL WHERE exists
529: (SELECT 1
530: FROM mtl_txn_request_lines
531: WHERE lpn_id = p_lpn_id
532: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */
533: AND Nvl(wms_process_flag, 1) = 2);
534: EXCEPTION

Line 716: UPDATE mtl_txn_request_lines

712: END IF;
713:
714: END IF;
715:
716: UPDATE mtl_txn_request_lines
717: SET
718: last_update_date = Sysdate,
719: quantity_detailed = (SELECT SUM(transaction_quantity)
720: FROM mtl_material_transactions_temp

Line 763: FROM mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

759:
760: /*Bug 8373292 If Inspection is done only then print label*/
761: SELECT inspection_status
762: INTO l_insp_status
763: FROM mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
764: WHERE mtrl.line_id=mmtt.move_order_line_id
765: AND mmtt.transaction_temp_id=l_temp_id;
766:
767: IF (l_debug = 1) THEN

Line 963: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1

959:
960: IF p_lpn_id IS NOT NULL THEN
961:
962: BEGIN
963: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
964: INTO l_discrepancy
965: FROM
966: (SELECT wlpn.lpn_id
967: FROM wms_license_plate_numbers wlpn

Line 970: mtl_txn_request_lines mtrl -- Bug 14372071

966: (SELECT wlpn.lpn_id
967: FROM wms_license_plate_numbers wlpn
968: START WITH wlpn.lpn_id = p_lpn_id
969: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn,
970: mtl_txn_request_lines mtrl -- Bug 14372071
971: WHERE mtrl.lpn_id = wlpn.lpn_id
972: AND mtrl.line_status = 7
973: AND (mtrl.quantity-Nvl(mtrl.quantity_delivered,0)) <> Nvl(mtrl.quantity_detailed,0)
974: AND mtrl.organization_id = p_organization_id;

Line 1297: UPDATE mtl_txn_request_lines

1293: WHEN NO_DATA_FOUND THEN NULL;
1294: END;
1295:
1296: BEGIN
1297: UPDATE mtl_txn_request_lines
1298: SET quantity_detailed = Nvl(quantity_delivered, 0),secondary_quantity_detailed = Nvl(secondary_quantity_delivered,0) --10332833
1299: WHERE lpn_id = p_lpn_id
1300: AND line_id = Nvl(p_move_order_line_id, line_id) -- added for ATF_J2
1301: AND organization_id = p_org_id;