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 2495: from aso_quote_headers_all a, aso_quote_statuses_vl b

2491:
2492: Cursor c_cart_columns (quote_hdr_id number) is
2493: select resource_id, status_code, publish_flag, quote_expiration_date,
2494: max_version_flag , order_id, quote_name
2495: from aso_quote_headers_all a, aso_quote_statuses_vl b
2496: where quote_header_id = quote_hdr_id
2497: and a.quote_status_id = b.quote_status_id;
2498:
2499: Cursor c_cart_from_number(quote_num number, quote_ver number) is

Line 2501: from aso_quote_headers_all a

2497: and a.quote_status_id = b.quote_status_id;
2498:
2499: Cursor c_cart_from_number(quote_num number, quote_ver number) is
2500: select quote_header_id
2501: from aso_quote_headers_all a
2502: where quote_number = quote_num
2503: and quote_version = quote_ver;
2504:
2505: Cursor c_retrieval_number (c_retrieval_number NUMBER) is

Line 2951: from aso_quote_headers_all

2947: is
2948:
2949: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
2950: select quote_header_id, last_update_date
2951: from aso_quote_headers_all
2952: where quote_header_id = (select max(quote_header_id)
2953: from aso_quote_headers_all
2954: where upper(quote_source_code) = 'ISTORE ACCOUNT'
2955: and party_id = p_partyid

Line 2953: from aso_quote_headers_all

2949: CURSOR C_get_quote_id(p_partyid number,p_cust_accountid number ) is
2950: select quote_header_id, last_update_date
2951: from aso_quote_headers_all
2952: where quote_header_id = (select max(quote_header_id)
2953: from aso_quote_headers_all
2954: where upper(quote_source_code) = 'ISTORE ACCOUNT'
2955: and party_id = p_partyid
2956: and cust_account_id = p_cust_accountid
2957: and quote_name = 'IBEACTIVECART'

Line 4064: from aso_quote_headers a ,

4060: b.status_code,
4061: a.party_id,
4062: a.cust_account_id,
4063: a.quote_source_code
4064: from aso_quote_headers a ,
4065: aso_quote_statuses_b b
4066: where a.quote_status_id = b.quote_status_id
4067: and a.quote_header_id = p_quote_header_id;
4068:

Line 4316: from aso_quote_headers_all

4312: and quote_header_id = p_quote_header_id;
4313:
4314: CURSOR c_getQuoteInfo IS
4315: SELECT quote_header_id
4316: from aso_quote_headers_all
4317: where quote_header_id = p_quote_header_id
4318: AND (party_id = l_party_id OR (party_id = p_party_id AND cust_account_id = p_cust_account_id));
4319:
4320: -- 9/23/02: we're using the next cursor

Line 4345: FROM aso_quote_headers a,

4341: a.last_update_date,
4342: a.last_updated_by,
4343: a.party_id,
4344: a.resource_id
4345: FROM aso_quote_headers a,
4346: aso_quote_statuses_vl b
4347: WHERE quote_header_id = c_quote_hdr_id
4348: and a.quote_status_id = b.quote_status_id;
4349:

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

4352: rec_sharee_info c_getShareeInfo%rowtype;
4353:
4354: -- 9/11/02: we want to check if this cart is a guest cart
4355: CURSOR c_getActiveCartTypeInfo IS
4356: select quote_source_code from aso_quote_headers_all where quote_header_id = p_quote_header_id;
4357: rec_ActiveCartType_info c_getActiveCartTypeInfo%rowtype;
4358:
4359: BEGIN
4360:

Line 4714: from aso_quote_headers_all a, hz_parties p

4710: where quote_sharee_number = c_retrieval_num ;
4711:
4712: cursor c_get_sold_to(c_quote_header_id NUMBER) is
4713: select cust_account_id, party_type
4714: from aso_quote_headers_all a, hz_parties p
4715: where a.party_id = p.party_id
4716: and quote_header_id = c_quote_header_id;
4717:
4718: cursor c_get_party_type(c_party_id NUMBER) is

Line 5343: from aso_quote_headers_all a, aso_quote_statuses_vl b

5339: FUNCTION get_aso_quote_status (p_quote_header_id NUMBER) RETURN VARCHAR2 is
5340:
5341: CURSOR c_quote_status_code (quote_hdr_id number) is
5342: select status_code
5343: from aso_quote_headers_all a, aso_quote_statuses_vl b
5344: where quote_header_id = quote_hdr_id
5345: and a.quote_status_id = b.quote_status_id;
5346:
5347: rec_quote_status_code c_quote_status_code%rowtype;