APPS.BIM_LEADS_PKG dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 13: ASO_QUOTE_RELATED_OBJECTS ASO1,

9: FROM
10: (
11: SELECT ASO2.OBJECT_ID
12: FROM
13: ASO_QUOTE_RELATED_OBJECTS ASO1,
14: ASO_QUOTE_RELATED_OBJECTS ASO2
15: WHERE
16: ASO1.OBJECT_TYPE_CODE = 'LEAD' AND
17: ASO1.OBJECT_ID = p_lead_id AND

Line 14: ASO_QUOTE_RELATED_OBJECTS ASO2

10: (
11: SELECT ASO2.OBJECT_ID
12: FROM
13: ASO_QUOTE_RELATED_OBJECTS ASO1,
14: ASO_QUOTE_RELATED_OBJECTS ASO2
15: WHERE
16: ASO1.OBJECT_TYPE_CODE = 'LEAD' AND
17: ASO1.OBJECT_ID = p_lead_id AND
18: ASO1.RELATIONSHIP_TYPE_CODE = 'LEAD_QUOTE' AND

Line 26: ASO_QUOTE_RELATED_OBJECTS ASO1,

22: UNION
23: SELECT ASO2.OBJECT_ID
24: FROM
25: AS_SALES_LEAD_OPPORTUNITY ASLO,
26: ASO_QUOTE_RELATED_OBJECTS ASO1,
27: ASO_QUOTE_RELATED_OBJECTS ASO2
28: WHERE
29: ASLO.SALES_LEAD_ID = p_lead_id AND
30: ASLO.OPPORTUNITY_ID = ASO1.OBJECT_ID AND

Line 27: ASO_QUOTE_RELATED_OBJECTS ASO2

23: SELECT ASO2.OBJECT_ID
24: FROM
25: AS_SALES_LEAD_OPPORTUNITY ASLO,
26: ASO_QUOTE_RELATED_OBJECTS ASO1,
27: ASO_QUOTE_RELATED_OBJECTS ASO2
28: WHERE
29: ASLO.SALES_LEAD_ID = p_lead_id AND
30: ASLO.OPPORTUNITY_ID = ASO1.OBJECT_ID AND
31: ASO1.OBJECT_TYPE_CODE = 'OPPORTUNITY' AND