APPS.ASO_CFG_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 744: FROM ASO_QUOTE_HEADERS_ALL

740: AND config_revision_num = l_config_rev_nbr;
741:
742: CURSOR c_quote(c_qte_header_id NUMBER) IS
743: SELECT last_update_date, quote_type
744: FROM ASO_QUOTE_HEADERS_ALL
745: WHERE quote_header_id = c_qte_header_id;
746:
747: CURSOR Order_Type_C IS
748: SELECT order_line_type_id, line_category_code, price_list_id, line_number,ship_model_complete_flag,

Line 1728: from aso_quote_lines_all a, aso_quote_headers_all b

1724: and item_key_type = 1;
1725:
1726: Cursor c_quote_hdr_id ( p_quote_line_id NUMBER ) is
1727: select a.quote_header_id, a.price_list_id, b.org_id
1728: from aso_quote_lines_all a, aso_quote_headers_all b
1729: where a.quote_header_id = b.quote_header_id
1730: and a.quote_line_id = p_quote_line_id;
1731:
1732: Cursor c_config_header_id ( p_quote_line_id NUMBER ) is

Line 2404: select org_id from aso_quote_headers_all

2400: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
2401: IS
2402:
2403: Cursor C_org_id (p_quote_header_id NUMBER) is
2404: select org_id from aso_quote_headers_all
2405: where quote_header_id = p_quote_header_id;
2406:
2407: Cursor c_inv_org_id (p_quote_line_id NUMBER) is
2408: select organization_id from aso_quote_lines_all