APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 37: ASO_QUOTE_LINES_ALL a

33:
34: Cursor c_mdl_item_details_csr(p_quote_line_id Number) is
35: Select a.quote_header_id, a.uom_code, a.quantity, a.inventory_item_id, a.organization_id
36: from
37: ASO_QUOTE_LINES_ALL a
38: where a.quote_line_id = p_quote_line_id;
39:
40: /***************************************************************************************
41: Cursor to find complete configuration and valid configuration info from CZ_CONFIG_HDRS

Line 416: from aso_quote_lines_all a

412: ****************************************************************/
413:
414: Cursor c_mdl_item_details_csr(p_quote_line_id Number) is
415: Select a.quantity, a.uom_code
416: from aso_quote_lines_all a
417: where a.quote_line_id = p_quote_line_id;
418:
419: /****************************************************************
420: Cursor to find last update date for quote

Line 839: Select b.quote_line_id from aso_quote_line_details a,aso_quote_lines_all b

835: Cursor to find all items in a quote that can be deactivated
836: ********************************************************************/
837:
838: Cursor c_deactivate_all_item_csr(p_quote_header_id Number) is
839: Select b.quote_line_id from aso_quote_line_details a,aso_quote_lines_all b
840: where b.quote_header_id = p_quote_header_id
841: and a.quote_line_id = b.quote_line_id
842: and a.config_delta = 0
843: and not exists(Select null from aso_quote_line_details c

Line 879: ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b

875: Cursor c_top_mdl_details_csr(p_config_header_id Number,p_config_revision_num Number,p_config_item_id Number) is
876: Select a.quote_line_id,a.quantity, a.uom_code,
877: b.complete_configuration_flag, b.valid_configuration_flag
878: from
879: ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b
880: where a.quote_line_id = b.quote_line_id
881: and b.config_header_id = p_config_header_id
882: and b.config_revision_num = p_config_revision_num
883: and b.config_item_id = p_config_item_id;

Line 887: from aso_quote_lines_all

883: and b.config_item_id = p_config_item_id;
884:
885: Cursor c_check_for_macd( p_qte_line_id number) is
886: select config_model_type
887: from aso_quote_lines_all
888: where quote_line_id = p_qte_line_id;
889:
890: Cursor c_last_update_date_csr(p_qte_header_id Number) is
891: SELECT last_update_date,object_version_number