APPS.ASO_CFG_INT dependencies on ASO_QUOTE_LINES_ALL

Line 786: ASO_QUOTE_LINES_ALL qte

782: cfg.name,
783: qte.line_type_source_flag
784: FROM ASO_QUOTE_LINE_DETAILS dtl,
785: CZ_CONFIG_DETAILS_V cfg ,
786: ASO_QUOTE_LINES_ALL qte
787: WHERE dtl.config_header_id = l_config_hdr_id
788: AND cfg.config_rev_nbr = l_config_rev_nbr
789: AND dtl.config_header_id = cfg.config_hdr_id
790: AND dtl.config_revision_num = cfg.config_rev_nbr

Line 838: FROM aso_quote_lines_all

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,
837: config_model_type
838: FROM aso_quote_lines_all
839: WHERE quote_line_id = p_config_rec.quote_line_id;
840:
841: CURSOR c_messages is
842: SELECT constraint_type, message

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 1912: from aso_quote_lines_all qtl,

1908: where quote_line_id = p_quote_line_id;
1909:
1910: Cursor c_pricelist_id ( p_config_item_id NUMBER, p_config_header_id NUMBER ) is
1911: Select qtl.price_list_id, qtl.quote_line_id
1912: from aso_quote_lines_all qtl,
1913: aso_quote_line_details qtl_dtl
1914: where qtl.quote_line_id = qtl_dtl.quote_line_id
1915: and qtl_dtl.config_item_id = p_config_item_id
1916: and qtl_dtl.config_header_id = p_config_header_id

Line 2589: from aso_quote_lines_all

2585: quantity,
2586: uom_code,
2587: price_list_id,
2588: charge_periodicity_code
2589: from aso_quote_lines_all
2590: where quote_header_id = p_qte_header_id
2591: and quote_line_id not in ( select a.quote_line_id
2592: from aso_quote_line_details a
2593: where (a.config_header_id, a.config_revision_num)

Line 2663: select organization_id from aso_quote_lines_all

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
2664: where quote_line_id = p_quote_line_id;
2665:
2666: TYPE param_name_type IS TABLE OF VARCHAR2(25)
2667: INDEX BY BINARY_INTEGER;

Line 3333: Get_config_details : To save options along with the model line in ASO_QUOTE_LINES_ALL

3329: CZ configurator along with a pl/sql table which has options
3330: that are updated and deleted from the model.
3331: Parse_output_xml : parses the CZ output xml message to see if the configuration
3332: is valid and complete.
3333: Get_config_details : To save options along with the model line in ASO_QUOTE_LINES_ALL
3334: , ASO_QUOTE_LINE_DETAILS and ASO_LINE_RELATIONSHIPS
3335: -----------------------------------------------------------------------*/
3336:
3337: PROCEDURE Validate_Configuration