APPS.IBE_QUOTE_REL_OBJ_PVT dependencies on ASO_QUOTE_RELATED_OBJECTS

Line 39: FROM aso_quote_related_objects

35: aso_quote_headers AQH2
36: WHERE AQH1.quote_number = AQH2.quote_number
37: AND AQH2.quote_header_id = p_quote_object_id
38: AND NOT EXISTS (SELECT 1
39: FROM aso_quote_related_objects
40: WHERE quote_object_type_code = 'HEADER'
41: AND quote_object_id = AQH1.quote_header_id
42: AND relationship_type_code = p_relationship_type_code);
43: ELSE

Line 61: FROM aso_quote_related_objects

57: ELSE
58: /* For delete.
59: */
60: OPEN l_csr FOR SELECT related_object_id
61: FROM aso_quote_related_objects
62: WHERE relationship_type_code = (SELECT relationship_type_code
63: FROM aso_quote_related_objects
64: WHERE related_object_id = p_related_object_id)
65: AND quote_object_id IN (SELECT quote_header_id

Line 63: FROM aso_quote_related_objects

59: */
60: OPEN l_csr FOR SELECT related_object_id
61: FROM aso_quote_related_objects
62: WHERE relationship_type_code = (SELECT relationship_type_code
63: FROM aso_quote_related_objects
64: WHERE related_object_id = p_related_object_id)
65: AND quote_object_id IN (SELECT quote_header_id
66: FROM aso_quote_headers
67: WHERE quote_number = (SELECT quote_number

Line 70: FROM aso_quote_related_objects

66: FROM aso_quote_headers
67: WHERE quote_number = (SELECT quote_number
68: FROM aso_quote_headers
69: WHERE quote_header_id = (SELECT quote_object_id
70: FROM aso_quote_related_objects
71: WHERE related_object_id = p_related_object_id)));
72: LOOP
73: FETCH l_csr INTO l_related_obj_rec.related_object_id;
74: EXIT WHEN l_csr%NOTFOUND;

Line 146: FROM aso_quote_related_objects

142: -- API body
143: IF FND_API.To_Boolean(p_one_to_one) THEN
144: SELECT COUNT(*)
145: INTO i
146: FROM aso_quote_related_objects
147: WHERE quote_object_type_code = p_quote_object_type_code
148: AND quote_object_id = p_quote_object_id
149: AND relationship_type_code = p_relationship_type_code;
150:

Line 291: FROM aso_quote_related_objects

287: -- API body
288: BEGIN
289: SELECT related_object_id
290: INTO l_related_obj_rec.related_object_id
291: FROM aso_quote_related_objects
292: WHERE quote_object_type_code = p_quote_object_type_code
293: AND quote_object_id = p_quote_object_id
294: AND object_type_code = p_object_type_code
295: AND object_id = p_object_id