APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 187: from aso_quote_lines l, aso_quote_line_details dl

183: ,l.uom_code
184: ,dl.quote_line_detail_id
185: ,dl.service_duration
186: ,dl.service_period
187: from aso_quote_lines l, aso_quote_line_details dl
188: where l.quote_header_id = p_quote_header_id
189: and l.item_type_code = 'SRV'
190: and dl.service_ref_line_id = p_service_ref_line_id
191: and dl.quote_line_id = l.quote_line_id;

Line 1967: ASO_QUOTE_LINE_DETAILS aqld

1963: is
1964: select aqld.service_ref_line_id refLine, aql2.inventory_item_id invId
1965: from ASO_QUOTE_LINES aql,
1966: ASO_QUOTE_LINES aql2,
1967: ASO_QUOTE_LINE_DETAILS aqld
1968: where aql.item_type_code = 'SVA' and
1969: aql.quote_line_id = aqld.service_ref_line_id and
1970: aql.quote_header_id = l_quote_header_id and
1971: aqld.quote_line_id = aql2.quote_line_id

Line 1983: From aso_quote_lines ql, aso_quote_line_details qld

1979: organization_id = l_organization_id;
1980:
1981: Cursor c_find_service(c_service_ref_line_id number) is
1982: Select ql.quote_line_id
1983: From aso_quote_lines ql, aso_quote_line_details qld
1984: where ql.quote_line_id = qld.quote_line_id
1985: And qld.service_ref_line_id = c_service_ref_line_id;
1986:
1987: rec_service c_getServiceInvId%rowtype;

Line 7693: aso_quote_line_details AQLD

7689: aql.quantity,
7690: aqld.config_header_id,
7691: aqld.config_revision_num
7692: from aso_quote_lines_all aql,
7693: aso_quote_line_details AQLD
7694: where aqld.quote_line_id = aql.quote_line_id and
7695: aqld.ref_line_id is null and
7696: aql.quote_header_id = :1';
7697:

Line 8099: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD

8095: l_quote_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
8096:
8097: CURSOR c_get_svc_lines(p_quote_header_id NUMBER) IS
8098: SELECT AQL.quote_line_id,ALD.service_ref_line_id,AQL.inventory_item_id
8099: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD
8100: WHERE AQL.quote_header_id = p_quote_header_id and AQL.quote_line_id=ALD.quote_line_id
8101: and AQL.item_type_code='SRV'
8102: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
8103: