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_MISC_PVT dependencies on ASO_QUOTE_HEADERS

Line 22: from aso_quote_headers_all

18: p_party_id IN NUMBER,
19: p_cust_account_id IN NUMBER) return varchar2 is
20: CURSOR c_get_quote_details(c_quote_header_id NUMBER) is
21: select quote_expiration_date
22: from aso_quote_headers_all
23: where quote_header_id = c_quote_header_id;
24:
25: CURSOR c_find_active_cart(c_quote_header_id NUMBER,
26: c_party_id NUMBER,

Line 229: FROM aso_quote_headers

225: l_order_id NUMBER;
226: BEGIN
227:
228: SELECT quote_header_id, order_id INTO l_quote_header_id, l_order_id
229: FROM aso_quote_headers
230: WHERE quote_header_id = p_quote_header_id;
231:
232: IF (l_order_id IS NULL) THEN
233: RETURN 'NOT_ORDERED';

Line 269: SELECT last_update_date FROM ASO_QUOTE_HEADERS

265: ) RETURN DATE
266: IS
267:
268: CURSOR c_getLastUpdateDate(c_qte_header_id NUMBER) IS
269: SELECT last_update_date FROM ASO_QUOTE_HEADERS
270: WHERE quote_header_id = c_qte_header_id;
271: l_last_update_date date := FND_API.G_MISS_DATE;
272: BEGIN
273:

Line 1809: FROM aso_quote_headers

1805: ,EXCHANGE_RATE_DATE
1806: ,CONTRACT_ID
1807: ,SALES_CHANNEL_CODE
1808: ,ORDER_ID
1809: FROM aso_quote_headers
1810: WHERE quote_header_id = p_quote_header_id;
1811:
1812: l_qte_header_rec ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
1813:

Line 2136: FROM aso_quote_headers

2132: l_cust_account_id number := FND_API.G_MISS_NUM;
2133:
2134: CURSOR getuserinfo(p_quote_header_id NUMBER) IS
2135: SELECT party_id, cust_account_id
2136: FROM aso_quote_headers
2137: WHERE quote_header_id = p_quote_header_id;
2138:
2139: BEGIN
2140: SAVEPOINT getQuoteOwner_pvt;

Line 2242: FROM aso_quote_headers

2238:
2239: l_sql1 VARCHAR2(200) :=
2240: 'SELECT quote_header_id,
2241: last_update_date
2242: FROM aso_quote_headers
2243: WHERE quote_number = :1
2244: AND quote_version = :2 ';
2245:
2246: l_sql2 VARCHAR2(100) := 'AND quote_password = :3';

Line 2266: FROM aso_quote_headers

2262: IF l_quote_version IS NULL
2263: OR l_quote_version = FND_API.G_MISS_NUM THEN
2264: SELECT MAX(quote_version)
2265: INTO l_quote_version
2266: FROM aso_quote_headers
2267: WHERE quote_number = p_quote_number;
2268: END IF;
2269:
2270: IF p_quote_password IS NULL

Line 2613: from aso_quote_headers_all a, aso_quote_statuses_vl b

2609:
2610: Cursor c_cart_columns (quote_hdr_id number) is
2611: select resource_id, status_code, publish_flag, quote_expiration_date,
2612: max_version_flag , order_id, quote_name
2613: from aso_quote_headers_all a, aso_quote_statuses_vl b
2614: where quote_header_id = quote_hdr_id
2615: and a.quote_status_id = b.quote_status_id;
2616:
2617: Cursor c_cart_from_number(quote_num number, quote_ver number) is

Line 2619: from aso_quote_headers_all a

2615: and a.quote_status_id = b.quote_status_id;
2616:
2617: Cursor c_cart_from_number(quote_num number, quote_ver number) is
2618: select quote_header_id
2619: from aso_quote_headers_all a
2620: where quote_number = quote_num
2621: and quote_version = quote_ver;
2622:
2623: Cursor c_retrieval_number (c_retrieval_number NUMBER) is

Line 3069: from aso_quote_headers_all

3065: is
3066:
3067: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
3068: select quote_header_id, last_update_date
3069: from aso_quote_headers_all
3070: where quote_header_id = (select max(quote_header_id)
3071: from aso_quote_headers_all
3072: where upper(quote_source_code) = 'ISTORE ACCOUNT'
3073: and party_id = p_partyid

Line 3071: from aso_quote_headers_all

3067: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
3068: select quote_header_id, last_update_date
3069: from aso_quote_headers_all
3070: where quote_header_id = (select max(quote_header_id)
3071: from aso_quote_headers_all
3072: where upper(quote_source_code) = 'ISTORE ACCOUNT'
3073: and party_id = p_partyid
3074: and cust_account_id = p_cust_accountid
3075: and quote_name = 'IBEACTIVECART'

Line 4182: from aso_quote_headers a ,

4178: b.status_code,
4179: a.party_id,
4180: a.cust_account_id,
4181: a.quote_source_code
4182: from aso_quote_headers a ,
4183: aso_quote_statuses_b b
4184: where a.quote_status_id = b.quote_status_id
4185: and a.quote_header_id = p_quote_header_id;
4186:

Line 4435: from aso_quote_headers_all

4431: and quote_header_id = p_quote_header_id;
4432:
4433: CURSOR c_getQuoteInfo IS
4434: SELECT quote_header_id
4435: from aso_quote_headers_all
4436: where quote_header_id = p_quote_header_id
4437: AND (party_id = l_party_id OR (party_id = p_party_id AND cust_account_id = p_cust_account_id));
4438:
4439: CURSOR c_getQuoteInfo2 IS -- bug 13517114, scnagara

Line 4441: from aso_quote_headers_all

4437: AND (party_id = l_party_id OR (party_id = p_party_id AND cust_account_id = p_cust_account_id));
4438:
4439: CURSOR c_getQuoteInfo2 IS -- bug 13517114, scnagara
4440: SELECT quote_header_id
4441: from aso_quote_headers_all
4442: where quote_header_id = p_quote_header_id
4443: AND party_id in (select relationship_party_id
4444: FROM IBE_CUSTOMERS_ASSIGNED_V
4445: where person_party_id = l_person_party_id);

Line 4477: FROM aso_quote_headers a,

4473: a.last_update_date,
4474: a.last_updated_by,
4475: a.party_id,
4476: a.resource_id
4477: FROM aso_quote_headers a,
4478: aso_quote_statuses_vl b
4479: WHERE quote_header_id = c_quote_hdr_id
4480: and a.quote_status_id = b.quote_status_id;
4481:

Line 4488: select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;

4484: rec_sharee_info c_getShareeInfo%rowtype;
4485:
4486: -- 9/11/02: we want to check if this cart is a guest cart
4487: CURSOR c_getActiveCartTypeInfo IS
4488: select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;
4489: rec_ActiveCartType_info c_getActiveCartTypeInfo%rowtype;
4490:
4491: BEGIN
4492:

Line 4856: from aso_quote_headers_all a, hz_parties p

4852: where quote_sharee_number = c_retrieval_num ;
4853:
4854: cursor c_get_sold_to(c_quote_header_id NUMBER) is
4855: select cust_account_id, party_type
4856: from aso_quote_headers_all a, hz_parties p
4857: where a.party_id = p.party_id
4858: and quote_header_id = c_quote_header_id;
4859:
4860: cursor c_get_party_type(c_party_id NUMBER) is

Line 5485: from aso_quote_headers_all a, aso_quote_statuses_vl b

5481: FUNCTION get_aso_quote_status (p_quote_header_id NUMBER) RETURN VARCHAR2 is
5482:
5483: CURSOR c_quote_status_code (quote_hdr_id number) is
5484: select status_code
5485: from aso_quote_headers_all a, aso_quote_statuses_vl b
5486: where quote_header_id = quote_hdr_id
5487: and a.quote_status_id = b.quote_status_id;
5488:
5489: rec_quote_status_code c_quote_status_code%rowtype;