APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_TXN_REQUEST_LINES

Line 264: | 2. mtl_txn_request_lines |

260: | Plsql table to hold the errored out lpn_ids and line_ids. |
261: | |
262: | Tables Used: |
263: | 1. mtl_txn_request_headers |
264: | 2. mtl_txn_request_lines |
265: +===========================================================================*/
266: --
267: PROCEDURE pre_generate(
268: x_return_status OUT NOCOPY VARCHAR2,

Line 341: mtl_txn_request_lines mol

337:
338: CURSOR mol_cursor IS
339: SELECT mol.line_id, mol.line_number
340: FROM mtl_txn_request_headers moh,
341: mtl_txn_request_lines mol
342: WHERE mol.header_id = moh.header_id
343: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
344: AND mol.organization_id = p_organization_id
345: AND mol.lpn_id is not null

Line 362: mtl_txn_request_lines mol,

358: mol.line_id,
359: mol.txn_source_id --- for bug 7190056
360: FROM
361: mtl_txn_request_headers moh,
362: mtl_txn_request_lines mol,
363: wms_license_plate_numbers lpn
364: WHERE mol.header_id = moh.header_id
365: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
366: AND mol.organization_id = p_organization_id

Line 395: mtl_txn_request_lines mol

391: mol.backorder_delivery_detail_id, -- added for ATF_J
392: mol.crossdock_type -- added for ATF_J
393: FROM
394: mtl_material_transactions_temp mmtt,
395: mtl_txn_request_lines mol
396: WHERE mmtt.move_order_line_id = l_line_id
397: AND mol.line_id = l_line_id;
398:
399:

Line 492: FROM mtl_txn_request_lines

488: SELECT 1
489: INTO l_process_flag_count
490: FROM DUAL WHERE exists
491: (SELECT 1
492: FROM mtl_txn_request_lines
493: WHERE lpn_id = p_lpn_id
494: AND line_status <> inv_globals.g_to_status_closed /* 3867448 */
495: AND Nvl(wms_process_flag, 1) = 2);
496: EXCEPTION

Line 676: UPDATE mtl_txn_request_lines

672:
673: END IF;
674:
675:
676: UPDATE mtl_txn_request_lines
677: SET
678: last_update_date = Sysdate,
679: quantity_detailed = (SELECT SUM(transaction_quantity)
680: FROM mtl_material_transactions_temp

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

862:
863: IF p_lpn_id IS NOT NULL THEN
864:
865: BEGIN
866: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
867: INTO l_discrepancy
868: FROM mtl_txn_request_lines mtrl,
869: (SELECT wlpn.lpn_id
870: FROM wms_license_plate_numbers wlpn

Line 868: FROM mtl_txn_request_lines mtrl,

864:
865: BEGIN
866: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
867: INTO l_discrepancy
868: FROM mtl_txn_request_lines mtrl,
869: (SELECT wlpn.lpn_id
870: FROM wms_license_plate_numbers wlpn
871: START WITH wlpn.lpn_id = p_lpn_id
872: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn

Line 1202: UPDATE mtl_txn_request_lines

1198: WHEN NO_DATA_FOUND THEN NULL;
1199: END;
1200:
1201: BEGIN
1202: UPDATE mtl_txn_request_lines
1203: SET quantity_detailed = Nvl(quantity_delivered, 0)
1204: WHERE lpn_id = p_lpn_id
1205: AND line_id = Nvl(p_move_order_line_id, line_id) -- added for ATF_J2
1206: AND organization_id = p_org_id;