APPS.WMS_CONTAINER_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 3831: FROM mtl_txn_request_lines

3827: END IF;
3828:
3829: SELECT COUNT(1)
3830: INTO l_valid
3831: FROM mtl_txn_request_lines
3832: WHERE organization_id = l_organization_id
3833: AND lpn_id = p_lpn_id
3834: AND line_status = 7;
3835:

Line 3840: l_table_name := 'MTL_TXN_REQUEST_LINES';

3836: IF l_valid > 0 THEN
3837: IF l_debug = 1 THEN
3838: mdebug('LPN : '||p_lpn_id||' has an open move order line against it, cannot reuse');
3839: END IF;
3840: l_table_name := 'MTL_TXN_REQUEST_LINES';
3841: RAISE l_transactions_pending;
3842: END IF;
3843:
3844: SELECT COUNT(1)