APPS.IBE_QUOTE_MISC_PVT dependencies on ASO_QUOTE_STATUSES_VL

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

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

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;

Line 5490: l_quote_status_code aso_quote_statuses_vl.status_code%type;

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;
5490: l_quote_status_code aso_quote_statuses_vl.status_code%type;
5491:
5492:
5493: BEGIN
5494: