APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 48: FROM ASO_LINE_RELATIONSHIPS a, aso_quote_lines_all b

44:
45: CURSOR c_line_relation (x_quote_header_id NUMBER) IS
46: SELECT a.LINE_RELATIONSHIP_ID, a.QUOTE_LINE_ID, a.RELATED_QUOTE_LINE_ID,
47: a.RELATIONSHIP_TYPE_CODE, a.RECIPROCAL_FLAG
48: FROM ASO_LINE_RELATIONSHIPS a, aso_quote_lines_all b
49: WHERE a.quote_line_id = b.quote_line_id
50: and b.quote_header_id = x_quote_header_id;
51:
52: CURSOR C_Qte_Status_Id (c_status_code VARCHAR2) IS

Line 528: from aso_Quote_lines_all

524: aso_debug_pub.add('Submit_Quote - l_order_status_prof: '||l_order_status_prof, 1, 'N');
525: END IF;
526: if l_order_status_prof='ENTERED' then
527: select count(*) into l_mdl_count
528: from aso_Quote_lines_all
529: where quote_header_id=p_qte_header_rec.quote_header_id
530: and item_type_code='MDL';
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('Submit_Quote - mdl.count: '||to_char(l_mdl_count), 1, 'N');