APPS.ASO_QUOTE_TMPL_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 110: FROM ASO_QUOTE_LINE_DETAILS A

106: WHERE inventory_item_id = l_inventory_item_id;
107:
108: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
109: SELECT A.quote_line_id
110: FROM ASO_QUOTE_LINE_DETAILS A
111: WHERE (config_header_id, config_revision_num) = ( SELECT config_header_id, config_revision_num FROM ASO_QUOTE_LINE_DETAILS WHERE quote_line_id = l_quote_line_id );
112:
113: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
114: SELECT quote_line_id

Line 111: WHERE (config_header_id, config_revision_num) = ( SELECT config_header_id, config_revision_num FROM ASO_QUOTE_LINE_DETAILS WHERE quote_line_id = l_quote_line_id );

107:
108: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
109: SELECT A.quote_line_id
110: FROM ASO_QUOTE_LINE_DETAILS A
111: WHERE (config_header_id, config_revision_num) = ( SELECT config_header_id, config_revision_num FROM ASO_QUOTE_LINE_DETAILS WHERE quote_line_id = l_quote_line_id );
112:
113: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
114: SELECT quote_line_id
115: FROM ASO_QUOTE_LINE_DETAILS

Line 115: FROM ASO_QUOTE_LINE_DETAILS

111: WHERE (config_header_id, config_revision_num) = ( SELECT config_header_id, config_revision_num FROM ASO_QUOTE_LINE_DETAILS WHERE quote_line_id = l_quote_line_id );
112:
113: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
114: SELECT quote_line_id
115: FROM ASO_QUOTE_LINE_DETAILS
116: WHERE service_ref_line_id = l_quote_line_id;
117:
118: CURSOR c_service_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
119: SELECT service_item_flag

Line 727: from aso_quote_line_Details

723: l_segment1 VARCHAR2(240);
724:
725: cursor c_service_ref_quote (l_Quote_line_id number) is
726: select service_ref_line_id
727: from aso_quote_line_Details
728: where quote_line_id= l_Quote_line_id
729: and service_ref_type_code ='QUOTE';
730:
731: cursor c_service_ref_quote_line (l_Quote_line_id number) is