DBA Data[Home] [Help]

APPS.INV_MINMAX_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 2394: FROM mtl_txn_request_headers mtrh,

2390: -- Move order type 3 is pick wave, source type 2 is sales order
2391: -- Bug 3181367 added transaction_source_type_id 8 too.
2392: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2393: INTO l_pick_released_qty
2394: FROM mtl_txn_request_headers mtrh,
2395: mtl_txn_request_lines mtrl
2396: WHERE mtrh.move_order_type = 3
2397: AND mtrh.header_id = mtrl.header_id
2398: AND mtrl.organization_id = p_org_id