APPS.INV_CYC_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 4644: FROM MTL_ONHAND_QUANTITIES_DETAIL

4640: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4641: , NVL ( SUM ( secondary_transaction_quantity ), 0 ) -- nsinghi bug#6052831
4642: INTO l_primary_sys_qty
4643: , l_secondary_sys_qty -- nsinghi bug#6052831
4644: FROM MTL_ONHAND_QUANTITIES_DETAIL
4645: WHERE inventory_item_id = l_item_id
4646: AND organization_id = l_org_id
4647: AND NVL ( containerized_flag, 2 ) = 2
4648: AND subinventory_code = l_sub

Line 4691: FROM MTL_ONHAND_QUANTITIES_DETAIL

4687: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
4688: , NVL ( SUM ( secondary_transaction_quantity ), 0 ) -- nsinghi bug#6052831
4689: INTO l_primary_sys_qty
4690: , l_secondary_sys_qty -- nsinghi bug#6052831
4691: FROM MTL_ONHAND_QUANTITIES_DETAIL
4692: WHERE inventory_item_id = l_item_id
4693: AND organization_id = l_org_id
4694: AND NVL ( containerized_flag, 2 ) = 2
4695: AND subinventory_code = l_sub

Line 7975: FROM MTL_ONHAND_QUANTITIES_DETAIL

7971: END;
7972: ELSE
7973: SELECT DISTINCT NVL ( cost_group_id, -999 )
7974: INTO l_cost_group_id
7975: FROM MTL_ONHAND_QUANTITIES_DETAIL
7976: WHERE inventory_item_id = p_inventory_item_id
7977: AND NVL ( revision, '@@@@@' ) =
7978: NVL ( p_revision, '@@@@@' )
7979: AND NVL ( lot_number, '@@@@@' ) =

Line 9097: FROM MTL_ONHAND_QUANTITIES_DETAIL

9093: END IF;
9094:
9095: SELECT NVL ( SUM ( primary_transaction_quantity ), 0 )
9096: INTO x_system_quantity
9097: FROM MTL_ONHAND_QUANTITIES_DETAIL
9098: WHERE inventory_item_id = p_inventory_item_id
9099: AND organization_id = p_organization_id
9100: AND NVL ( containerized_flag, 2 ) = 2
9101: AND subinventory_code = p_subinventory