DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 3849: into l_qoh FROM mtl_onhand_quantities_detail

3845:
3846: -- Bug 3740610 No need to call qty tree,getting on-hand qty from table
3847:
3848: SELECT NVL(SUM(primary_transaction_quantity),0)
3849: into l_qoh FROM mtl_onhand_quantities_detail
3850: WHERE organization_id = v1.organization_id
3851: AND subinventory_code = v1.subinventory_code
3852: AND locator_id = v1.locator_id
3853: AND lpn_id = v1.allocated_lpn_id;

Line 6192: into l_qoh FROM mtl_onhand_quantities_detail

6188:
6189: IF (v1.allocated_lpn_id IS NOT NULL ) THEN
6190: -- Bug 3740610 No need to call qty tree,getting on-hand qty from table
6191: SELECT NVL(SUM(primary_transaction_quantity),0)
6192: into l_qoh FROM mtl_onhand_quantities_detail
6193: WHERE organization_id = v1.organization_id
6194: AND subinventory_code = v1.subinventory_code
6195: AND locator_id = v1.locator_id
6196: AND lpn_id = v1.allocated_lpn_id;