APPS.BIM_OPPORTUNITIES_PKG SQL Statements

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

Line: 8

	SELECT COUNT(distinct ASO2.OBJECT_ID) INTO LN_ORDERS_GENERATED
	FROM
			ASO_QUOTE_RELATED_OBJECTS ASO1,
			ASO_QUOTE_RELATED_OBJECTS ASO2
	WHERE
			ASO1.OBJECT_TYPE_CODE = 'OPPORTUNITY' AND
			ASO1.OBJECT_ID = p_opportunity_id AND
			ASO1.RELATIONSHIP_TYPE_CODE = 'OPP_QUOTE' AND
			ASO1.QUOTE_OBJECT_ID = ASO2.QUOTE_OBJECT_ID AND
			ASO1.QUOTE_OBJECT_TYPE_CODE = ASO2.QUOTE_OBJECT_TYPE_CODE AND
			ASO2.RELATIONSHIP_TYPE_CODE = 'QUOTE_ORDER';