APPS.WMS_STRATEGY_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 2366: FROM mtl_txn_request_lines mtrl

2362: BEGIN
2363: IF NVL(wms_engine_pvt.g_fulfillment_base,'P') = 'S' THEN
2364: SELECT 'Y'
2365: INTO WMS_RULE_PVT.g_over_allocation
2366: FROM mtl_txn_request_lines mtrl
2367: WHERE mtrl.txn_source_line_id = l_trx_source_line_id
2368: AND mtrl.transaction_source_type_id IN (2,8)
2369: AND mtrl.LINE_ID <> p_transaction_temp_id
2370: AND mtrl.secondary_quantity_detailed IS NOT NULL

Line 2385: FROM mtl_txn_request_lines mtrl

2381: AND mmtt.transaction_action_id = 28);
2382: ELSE
2383: SELECT 'Y'
2384: INTO WMS_RULE_PVT.g_over_allocation
2385: FROM mtl_txn_request_lines mtrl
2386: WHERE mtrl.txn_source_line_id = l_trx_source_line_id
2387: AND mtrl.transaction_source_type_id IN (2,8)
2388: AND mtrl.LINE_ID <> p_transaction_temp_id
2389: AND mtrl.quantity_detailed IS NOT NULL