DBA Data[Home] [Help]

APPS.AHL_STATUS_ORDER_RULES_PVT SQL Statements

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

Line: 61

   	SELECT
   		SOR.NEXT_STATUS_CODE,
   		FND.MEANING

   	FROM
   		AHL_STATUS_ORDER_RULES SOR, FND_LOOKUP_VALUES_VL FND
   	WHERE
   		SOR.CURRENT_STATUS_CODE = c_current_status_code AND
   		SOR.SYSTEM_STATUS_TYPE = c_system_status_type AND
   		FND.LOOKUP_TYPE(+) = c_system_status_type AND
   		FND.LOOKUP_CODE(+) = SOR.NEXT_STATUS_CODE;