APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on MTL_TXN_REQUEST_HEADERS

Line 263: | 1. mtl_txn_request_headers |

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

Line 340: FROM mtl_txn_request_headers moh,

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

Line 361: mtl_txn_request_headers moh,

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