DBA Data[Home] [Help]

APPS.INV_QTY_MANAGEMENT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 34

	 SELECT primary_uom_code
	   INTO p_primary_uom_code
	   FROM mtl_system_items
	  WHERE organization_id = p_organization_id
	    AND inventory_item_id = p_inventory_item_id;
Line: 49

	 SELECT uom_code
	   INTO p_txn_uom_code
	   FROM mtl_item_uoms_view
	   WHERE organization_id = p_organization_id
	   AND inventory_item_id = p_inventory_item_id
	   AND unit_of_measure = p_txn_unit_of_measure;