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

868:
869: cursor c_getlineinfo(p_quote_header_id number, l_inventory_item_id number,l_uom_code varchar2)
870: is
871: select quote_line_id, item_type_code ,quantity,marketing_source_code_id
872: from aso_quote_lines
873: where quote_header_id = p_quote_header_id
874: and inventory_item_id = l_inventory_item_id and uom_code = l_uom_code;
875:
876: cursor c_checkForPRG (p_quote_header_id number)

Line 879: from aso_quote_lines

875:
876: cursor c_checkForPRG (p_quote_header_id number)
877: is
878: select pricing_line_type_indicator
879: from aso_quote_lines
880: where quote_header_id = p_quote_header_id;
881:
882: BEGIN
883: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1688: from aso_quote_lines

1684:
1685:
1686: cursor c_getlineids(p_quote_header_id number) is
1687: select quote_line_id
1688: from aso_quote_lines
1689: where quote_header_id = p_quote_header_id;
1690: BEGIN
1691: -- Standard Start of API savepoint
1692: SAVEPOINT DELETEALLLINES_pvt;

Line 1965: from ASO_QUOTE_LINES aql,

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

Line 1966: ASO_QUOTE_LINES aql2,

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

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

2106: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2107: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2108: --Check the number of quote lines in the quote
2109: SELECT COUNT(*) INTO l_numLines
2110: FROM aso_quote_lines
2111: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id;
2112: END IF;
2113:
2114: --DBMS_OUTPUT.PUT_line('l_numLines='||l_numLines);

Line 2132: FROM aso_quote_lines

2128: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2129: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2130: --Get the number of serviceable items in the quote
2131: SELECT COUNT(*) INTO l_numLines
2132: FROM aso_quote_lines
2133: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id and
2134: item_type_code = 'SVA';
2135: END IF;
2136:

Line 2166: FROM aso_quote_lines

2162: l_numLines := 0;
2163: IF ((p_Qte_Header_Rec.quote_header_id is not null)
2164: and (p_Qte_Header_Rec.quote_header_id <> FND_API.G_MISS_NUM) ) THEN
2165: SELECT COUNT(inventory_item_id) INTO l_numLines
2166: FROM aso_quote_lines
2167: WHERE quote_header_id = p_Qte_Header_Rec.quote_header_id and
2168: inventory_item_id = l_Qte_Line_Tbl(i).inventory_item_id;
2169: END IF;
2170:

Line 7692: from aso_quote_lines_all aql,

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

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:

Line 8105: SELECT quote_line_id, quantity FROM aso_quote_lines_all

8101: and AQL.item_type_code='SRV'
8102: ORDER BY ALD.service_ref_line_id,AQL.inventory_item_id;
8103:
8104: CURSOR c_get_sva_lines(p_quote_header_id NUMBER) IS
8105: SELECT quote_line_id, quantity FROM aso_quote_lines_all
8106: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
8107: ORDER BY quote_line_id;
8108:
8109: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS

Line 8110: SELECT quantity FROM aso_quote_lines_all

8106: WHERE quote_header_id = p_quote_header_id and ITEM_TYPE_CODE='SVA'
8107: ORDER BY quote_line_id;
8108:
8109: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
8110: SELECT quantity FROM aso_quote_lines_all
8111: WHERE quote_line_id = p_quote_line_id;
8112: BEGIN
8113: -- Standard Start of API savepoint
8114: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;