eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 119: ASO_QUOTE_LINE_DETAILS a

115: Begin
116: Select a. config_header_id , a.config_revision_num
117: into l_hdr_id , l_rev_nbr
118: from
119: ASO_QUOTE_LINE_DETAILS a
120: where a.quote_line_id = p_quote_line_id;
121:
122: Exception
123: WHEN NO_DATA_FOUND then

Line 831: from aso_quote_line_details a

827: ********************************************************************/
828:
829: Cursor c_deactivate_item_csr(p_quote_line_id Number) is
830: Select a.config_header_id, a.config_revision_num, a.config_item_id,a.config_delta
831: from aso_quote_line_details a
832: where a.quote_line_id =p_quote_line_id;
833:
834: /*******************************************************************
835: Cursor to find all items in a quote that can be deactivated

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 843: and not exists(Select null from aso_quote_line_details c

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
844: where c.quote_line_id = a.ref_line_id
845: and c.config_delta = 0
846: );
847:

Line 854: ASO_QUOTE_LINE_DETAILS b

850: *****************************************************************************/
851: Cursor c_chk_qte_line_mdl_csr(p_quote_line_id Number) is
852: Select b.config_header_id,b.config_revision_num
853: from
854: ASO_QUOTE_LINE_DETAILS b
855: where b.quote_line_id = P_quote_line_id
856: and b.ref_type_code ='CONFIG'
857: and b.ref_line_id is null;
858:

Line 866: ASO_QUOTE_LINE_DETAILS b

862:
863: Cursor c_top_mdl_csr(p_config_header_id Number,p_config_revision_num Number) is
864: Select b.config_item_id
865: from
866: ASO_QUOTE_LINE_DETAILS b
867: where b.config_header_id = p_config_header_id
868: and b.config_revision_num = p_config_revision_num
869: and b.ref_type_code ='CONFIG'
870: and b.ref_line_id is null;

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;