DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 2384: FROM mtl_txn_request_headers mtrh,

2380: -- Move order type 3 is pick wave, source type 2 is sales order
2381: -- Bug 3181367 added transaction_source_type_id 8 too.
2382: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2383: INTO l_pick_released_qty
2384: FROM mtl_txn_request_headers mtrh,
2385: mtl_txn_request_lines mtrl
2386: WHERE mtrh.move_order_type = 3
2387: AND mtrh.header_id = mtrl.header_id
2388: AND mtrl.organization_id = p_org_id