APPS.ASO_CFG_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 832: FROM ASO_QUOTE_HEADERS_ALL

828: AND config_revision_num = l_config_rev_nbr;
829:
830: CURSOR c_quote(c_qte_header_id NUMBER) IS
831: SELECT last_update_date, quote_type
832: FROM ASO_QUOTE_HEADERS_ALL
833: WHERE quote_header_id = c_qte_header_id;
834:
835: CURSOR Order_Type_C IS
836: SELECT order_line_type_id, line_category_code, price_list_id, line_number,ship_model_complete_flag,

Line 1901: from aso_quote_lines_all a, aso_quote_headers_all b

1897: and item_key_type = 1;
1898:
1899: Cursor c_quote_hdr_id ( p_quote_line_id NUMBER ) is
1900: select a.quote_header_id, a.price_list_id, b.org_id
1901: from aso_quote_lines_all a, aso_quote_headers_all b
1902: where a.quote_header_id = b.quote_header_id
1903: and a.quote_line_id = p_quote_line_id;
1904:
1905: Cursor c_config_header_id ( p_quote_line_id NUMBER ) is

Line 2659: select org_id from aso_quote_headers_all

2655: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
2656: IS
2657:
2658: Cursor C_org_id (p_quote_header_id NUMBER) is
2659: select org_id from aso_quote_headers_all
2660: where quote_header_id = p_quote_header_id;
2661:
2662: Cursor c_inv_org_id (p_quote_line_id NUMBER) is
2663: select organization_id from aso_quote_lines_all