DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_TXN_REQUEST_HEADERS

Line 299: | 1. mtl_txn_request_headers |

295: | x_lpn_line_error_tbl |
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(

Line 378: FROM mtl_txn_request_headers moh,

374: comment out following definition since its not referred in the code
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

Line 399: mtl_txn_request_headers moh,

395: lpn.lpn_context, --- for bug 5175569
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