DBA Data[Home] [Help]

APPS.WMS_CARTNZN_PUB dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 3867: into l_qoh FROM mtl_onhand_quantities_detail

3863:
3864: -- Bug 3740610 No need to call qty tree,getting on-hand qty from table
3865:
3866: SELECT NVL(SUM(primary_transaction_quantity),0)
3867: into l_qoh FROM mtl_onhand_quantities_detail
3868: WHERE organization_id = v1.organization_id
3869: AND subinventory_code = v1.subinventory_code
3870: AND locator_id = v1.locator_id
3871: AND lpn_id = v1.allocated_lpn_id;

Line 6147: into l_qoh FROM mtl_onhand_quantities_detail

6143:
6144: IF (v1.allocated_lpn_id IS NOT NULL ) THEN
6145: -- Bug 3740610 No need to call qty tree,getting on-hand qty from table
6146: SELECT NVL(SUM(primary_transaction_quantity),0)
6147: into l_qoh FROM mtl_onhand_quantities_detail
6148: WHERE organization_id = v1.organization_id
6149: AND subinventory_code = v1.subinventory_code
6150: AND locator_id = v1.locator_id
6151: AND lpn_id = v1.allocated_lpn_id;