APPS.INVPRPRO SQL Statements

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

Line: 26

	    select project_id, task_id
	    into proj_id, t_id
	    from OE_ORDER_LINES_ALL
	    where line_id = order_line_id;

Line: 31

	    select project_id, task_id
	    into proj_id, t_id
	    from SO_LINES_ALL
	    where line_id = order_line_id;

Line: 54

	'AND (EXISTS (SELECT INVENTORY_LOCATION_ID FROM MTL_ITEM_LOCATIONS WHERE INVENTORY_LOCATION_ID = A.LOCATOR_ID AND ORGANIZATION_ID = A.ORGANIZATION_ID AND PROJECT_ID IS NULL AND TASK_ID IS NULL))))';

Line: 61

	add_where_clause := '((A.LOCATOR_ID IS NOT NULL) AND (EXISTS (SELECT INVENTORY_LOCATION_ID FROM MTL_ITEM_LOCATIONS ' ||
	'WHERE INVENTORY_LOCATION_ID = A.LOCATOR_ID AND ORGANIZATION_ID = A.ORGANIZATION_ID AND PROJECT_ID = ' || TO_CHAR(proj_id) || ' AND TASK_ID IS NULL)))';

Line: 68

	add_where_clause := '((A.LOCATOR_ID IS NOT NULL) AND (EXISTS (SELECT INVENTORY_LOCATION_ID FROM MTL_ITEM_LOCATIONS ' ||
	'WHERE INVENTORY_LOCATION_ID = A.LOCATOR_ID AND ORGANIZATION_ID = A.ORGANIZATION_ID AND PROJECT_ID = ' || TO_CHAR(proj_id) || ' AND TASK_ID = '|| TO_CHAR(t_id) || ')))';