DBA Data[Home] [Help]

APPS.CSP_MINMAX_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 2091: FROM mtl_txn_request_headers mtrh,

2087: -- Move order type 3 is pick wave, source type 2 is sales order
2088: --
2089: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2090: INTO l_pick_released_qty
2091: FROM mtl_txn_request_headers mtrh,
2092: mtl_txn_request_lines mtrl
2093: WHERE mtrh.move_order_type = 3
2094: AND mtrh.header_id = mtrl.header_id
2095: AND mtrl.organization_id = p_org_id