APPS.INV_SHORTCHECKEXEC_PUB SQL Statements

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

Line: 59

	SELECT 'X'
	FROM   mtl_system_items
	WHERE  inventory_item_id = p_inventory_item_id
	AND    organization_id   = p_organization_id;

Line: 195

	SELECT 'X'
	FROM   mtl_system_items
	WHERE  inventory_item_id = p_inventory_item_id
	AND    organization_id   = p_organization_id;

Line: 201

	SELECT 'X'
        FROM   mtl_transaction_types
	WHERE  transaction_type_id = p_transaction_type_id;