APPS.IBE_QUOTE_MISC_PVT dependencies on ASO_QUOTE_STATUSES_VL

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 4346: aso_quote_statuses_vl b

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:
4350: rec_last_update_date c_last_update_date%rowtype;

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;

Line 5348: l_quote_status_code aso_quote_statuses_vl.status_code%type;

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;
5348: l_quote_status_code aso_quote_statuses_vl.status_code%type;
5349:
5350:
5351: BEGIN
5352: