DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 2173: FROM mtl_txn_request_lines mtrl

2169: -- the tolerance limits
2170: BEGIN
2171: SELECT 'Y'
2172: INTO WMS_RULE_PVT.g_over_allocation
2173: FROM mtl_txn_request_lines mtrl
2174: WHERE mtrl.txn_source_line_id = l_trx_source_line_id
2175: AND mtrl.LINE_ID <> p_transaction_temp_id
2176: AND mtrl.quantity_detailed IS NOT NULL
2177: AND mtrl.inventory_item_id = l_inventory_item_id