APPS.INV_CYC_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4319: FROM MTL_ONHAND_QUANTITIES_DETAIL

4315: END IF;
4316:
4317: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4318: INTO l_primary_sys_qty
4319: FROM MTL_ONHAND_QUANTITIES_DETAIL
4320: WHERE inventory_item_id = l_item_id
4321: AND organization_id = l_org_id
4322: AND NVL ( containerized_flag, 2 ) = 2
4323: AND subinventory_code = l_sub

Line 4362: FROM MTL_ONHAND_QUANTITIES_DETAIL

4358: END IF;
4359:
4360: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4361: INTO l_primary_sys_qty
4362: FROM MTL_ONHAND_QUANTITIES_DETAIL
4363: WHERE inventory_item_id = l_item_id
4364: AND organization_id = l_org_id
4365: AND NVL ( containerized_flag, 2 ) = 2
4366: AND subinventory_code = l_sub

Line 4650: FROM MTL_ONHAND_QUANTITIES_DETAIL

4646: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4647: , NVL ( SUM ( secondary_transaction_quantity ), 0 ) -- nsinghi bug#6052831
4648: INTO l_primary_sys_qty
4649: , l_secondary_sys_qty -- nsinghi bug#6052831
4650: FROM MTL_ONHAND_QUANTITIES_DETAIL
4651: WHERE inventory_item_id = l_item_id
4652: AND organization_id = l_org_id
4653: AND NVL ( containerized_flag, 2 ) = 2
4654: AND subinventory_code = l_sub

Line 4697: FROM MTL_ONHAND_QUANTITIES_DETAIL

4693: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4694: , NVL ( SUM ( secondary_transaction_quantity ), 0 ) -- nsinghi bug#6052831
4695: INTO l_primary_sys_qty
4696: , l_secondary_sys_qty -- nsinghi bug#6052831
4697: FROM MTL_ONHAND_QUANTITIES_DETAIL
4698: WHERE inventory_item_id = l_item_id
4699: AND organization_id = l_org_id
4700: AND NVL ( containerized_flag, 2 ) = 2
4701: AND subinventory_code = l_sub

Line 7779: FROM MTL_ONHAND_QUANTITIES_DETAIL

7775: END;
7776: ELSE
7777: SELECT DISTINCT NVL ( cost_group_id, -999 )
7778: INTO l_cost_group_id
7779: FROM MTL_ONHAND_QUANTITIES_DETAIL
7780: WHERE inventory_item_id = p_inventory_item_id
7781: AND NVL ( revision, '@@@@@' ) =
7782: NVL ( p_revision, '@@@@@' )
7783: AND NVL ( lot_number, '@@@@@' ) =

Line 8872: FROM MTL_ONHAND_QUANTITIES_DETAIL

8868: END IF;
8869:
8870: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
8871: INTO x_system_quantity
8872: FROM MTL_ONHAND_QUANTITIES_DETAIL
8873: WHERE inventory_item_id = p_inventory_item_id
8874: AND organization_id = p_organization_id
8875: AND NVL ( containerized_flag, 2 ) = 2
8876: AND subinventory_code = p_subinventory