DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 3753: FROM mtl_txn_request_lines

3749: END IF;
3750:
3751: SELECT COUNT(1)
3752: INTO l_valid
3753: FROM mtl_txn_request_lines
3754: WHERE organization_id = l_organization_id
3755: AND lpn_id = p_lpn_id
3756: AND line_status = 7;
3757:

Line 3762: l_table_name := 'MTL_TXN_REQUEST_LINES';

3758: IF l_valid > 0 THEN
3759: IF l_debug = 1 THEN
3760: mdebug('LPN : '||p_lpn_id||' has an open move order line against it, cannot reuse');
3761: END IF;
3762: l_table_name := 'MTL_TXN_REQUEST_LINES';
3763: RAISE l_transactions_pending;
3764: END IF;
3765:
3766: SELECT COUNT(1)