APPS.ASO_TRADEIN_PVT dependencies on ASO_LINE_RELATIONSHIPS

Line 42: SELECT count(related_quote_line_id) FROM aso_line_relationships

38: SELECT item_type_code FROM aso_quote_lines_all
39: WHERE quote_line_id = p_qte_line_rec.quote_line_id;
40:
41: CURSOR C_Service_Available IS
42: SELECT count(related_quote_line_id) FROM aso_line_relationships
43: WHERE quote_line_id = p_qte_line_rec.quote_line_id
44: AND relationship_type_code = 'SERVICE';
45:
46: CURSOR C_workflow IS