APPS.ASO_QUOTE_TMPL_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 103: FROM ASO_QUOTE_LINE_DETAILS A

99: WHERE inventory_item_id = l_inventory_item_id;
100:
101: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
102: SELECT A.quote_line_id
103: FROM ASO_QUOTE_LINE_DETAILS A
104: 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 );
105:
106: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
107: SELECT quote_line_id

Line 104: 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 );

100:
101: CURSOR c_config_lines (l_quote_line_id NUMBER) IS
102: SELECT A.quote_line_id
103: FROM ASO_QUOTE_LINE_DETAILS A
104: 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 );
105:
106: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
107: SELECT quote_line_id
108: FROM ASO_QUOTE_LINE_DETAILS

Line 108: FROM ASO_QUOTE_LINE_DETAILS

104: 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 );
105:
106: CURSOR c_service_lines (l_quote_line_id NUMBER) IS
107: SELECT quote_line_id
108: FROM ASO_QUOTE_LINE_DETAILS
109: WHERE service_ref_line_id = l_quote_line_id;
110:
111: CURSOR c_service_items (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS
112: SELECT service_item_flag