eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_QUOTE_SAVE_PVT dependencies on ASO_QUOTE_LINES

Line 115: from aso_quote_lines

111:
112: cursor c_getlineinfo(p_quote_header_id number, l_inventory_item_id number)
113: is
114: select quote_line_id, item_type_code ,quantity, inventory_item_id
115: from aso_quote_lines
116: where quote_header_id = p_quote_header_id
117: and inventory_item_id = l_inventory_item_id;
118:
119: BEGIN

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 853: from aso_quote_lines

849:
850: cursor c_getlineinfo(p_quote_header_id number, l_inventory_item_id number,l_uom_code varchar2)
851: is
852: select quote_line_id, item_type_code ,quantity,marketing_source_code_id
853: from aso_quote_lines
854: where quote_header_id = p_quote_header_id
855: and inventory_item_id = l_inventory_item_id and uom_code = l_uom_code;
856:
857: cursor c_checkForPRG (p_quote_header_id number)

Line 860: from aso_quote_lines

856:
857: cursor c_checkForPRG (p_quote_header_id number)
858: is
859: select pricing_line_type_indicator
860: from aso_quote_lines
861: where quote_header_id = p_quote_header_id;
862:
863: BEGIN
864: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1669: from aso_quote_lines

1665:
1666:
1667: cursor c_getlineids(p_quote_header_id number) is
1668: select quote_line_id
1669: from aso_quote_lines
1670: where quote_header_id = p_quote_header_id;
1671: BEGIN
1672: -- Standard Start of API savepoint
1673: SAVEPOINT DELETEALLLINES_pvt;

Line 1946: from ASO_QUOTE_LINES aql,

1942:
1943: cursor c_getServiceInvId (l_quote_header_id number)
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

Line 1947: ASO_QUOTE_LINES aql2,

1943: cursor c_getServiceInvId (l_quote_header_id number)
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

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 2091: FROM aso_quote_lines

2087: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2088: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2089: --Check the number of quote lines in the quote
2090: SELECT COUNT(*) INTO l_numLines
2091: FROM aso_quote_lines
2092: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id;
2093: END IF;
2094:
2095: --DBMS_OUTPUT.PUT_line('l_numLines='||l_numLines);

Line 2113: FROM aso_quote_lines

2109: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2110: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2111: --Get the number of serviceable items in the quote
2112: SELECT COUNT(*) INTO l_numLines
2113: FROM aso_quote_lines
2114: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id and
2115: item_type_code = 'SVA';
2116: END IF;
2117:

Line 2147: FROM aso_quote_lines

2143: l_numLines := 0;
2144: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2145: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2146: SELECT COUNT(inventory_item_id) INTO l_numLines
2147: FROM aso_quote_lines
2148: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id and
2149: inventory_item_id = l_Qte_Line_Tbl(i).inventory_item_id;
2150: END IF;
2151:

Line 7550: from aso_quote_lines_all aql,

7546: aql.uom_code,
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';

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:

Line 7963: SELECT quote_line_id, quantity FROM aso_quote_lines_all

7959: and AQL.item_type_code='SRV'
7960: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
7961:
7962: CURSOR c_get_sva_lines(p_quote_header_id NUMBER) IS
7963: SELECT quote_line_id, quantity FROM aso_quote_lines_all
7964: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
7965: ORDER BY quote_line_id;
7966:
7967: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS

Line 7968: SELECT quantity FROM aso_quote_lines_all

7964: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
7965: ORDER BY quote_line_id;
7966:
7967: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
7968: SELECT quantity FROM aso_quote_lines_all
7969: WHERE quote_line_id = p_quote_line_id;
7970: BEGIN
7971: -- Standard Start of API savepoint
7972: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;