DBA Data[Home] [Help]

APPS.BIM_OPPORTUNITIES_PKG dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 10: ASO_QUOTE_RELATED_OBJECTS ASO1,

6: BEGIN
7:
8: SELECT COUNT(distinct ASO2.OBJECT_ID) INTO LN_ORDERS_GENERATED
9: FROM
10: ASO_QUOTE_RELATED_OBJECTS ASO1,
11: ASO_QUOTE_RELATED_OBJECTS ASO2
12: WHERE
13: ASO1.OBJECT_TYPE_CODE = 'OPPORTUNITY' AND
14: ASO1.OBJECT_ID = p_opportunity_id AND

Line 11: ASO_QUOTE_RELATED_OBJECTS ASO2

7:
8: SELECT COUNT(distinct ASO2.OBJECT_ID) INTO LN_ORDERS_GENERATED
9: FROM
10: ASO_QUOTE_RELATED_OBJECTS ASO1,
11: ASO_QUOTE_RELATED_OBJECTS ASO2
12: WHERE
13: ASO1.OBJECT_TYPE_CODE = 'OPPORTUNITY' AND
14: ASO1.OBJECT_ID = p_opportunity_id AND
15: ASO1.RELATIONSHIP_TYPE_CODE = 'OPP_QUOTE' AND