APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 168: from aso_quote_lines l, aso_quote_line_details dl

164: ,l.uom_code
165: ,dl.quote_line_detail_id
166: ,dl.service_duration
167: ,dl.service_period
168: from aso_quote_lines l, aso_quote_line_details dl
169: where l.quote_header_id = p_quote_header_id
170: and l.item_type_code = 'SRV'
171: and dl.service_ref_line_id = p_service_ref_line_id
172: and dl.quote_line_id = l.quote_line_id;

Line 1948: ASO_QUOTE_LINE_DETAILS aqld

1944: is
1945: select aqld.service_ref_line_id refLine, aql2.inventory_item_id invId
1946: from ASO_QUOTE_LINES aql,
1947: ASO_QUOTE_LINES aql2,
1948: ASO_QUOTE_LINE_DETAILS aqld
1949: where aql.item_type_code = 'SVA' and
1950: aql.quote_line_id = aqld.service_ref_line_id and
1951: aql.quote_header_id = l_quote_header_id and
1952: aqld.quote_line_id = aql2.quote_line_id

Line 1964: From aso_quote_lines ql, aso_quote_line_details qld

1960: organization_id = l_organization_id;
1961:
1962: Cursor c_find_service(c_service_ref_line_id number) is
1963: Select ql.quote_line_id
1964: From aso_quote_lines ql, aso_quote_line_details qld
1965: where ql.quote_line_id = qld.quote_line_id
1966: And qld.service_ref_line_id = c_service_ref_line_id;
1967:
1968: rec_service c_getServiceInvId%rowtype;

Line 7551: aso_quote_line_details AQLD

7547: aql.quantity,
7548: aqld.config_header_id,
7549: aqld.config_revision_num
7550: from aso_quote_lines_all aql,
7551: aso_quote_line_details AQLD
7552: where aqld.quote_line_id = aql.quote_line_id and
7553: aqld.ref_line_id is null and
7554: aql.quote_header_id = :1';
7555:

Line 7957: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD

7953: l_quote_Line_Dtl_Tbl ASO_Quote_Pub.Qte_Line_dtl_Tbl_Type := ASO_Quote_Pub.G_MISS_QTE_LINE_DTL_TBL;
7954:
7955: CURSOR c_get_svc_lines(p_quote_header_id NUMBER) IS
7956: SELECT AQL.quote_line_id,ALD.service_ref_line_id,AQL.inventory_item_id
7957: FROM aso_quote_lines_all AQL, aso_quote_line_details ALD
7958: WHERE AQL.quote_header_id = p_quote_header_id and AQL.quote_line_id=ALD.quote_line_id
7959: and AQL.item_type_code='SRV'
7960: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
7961: