APPS.ASO_SHIPMENT_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 157: from aso_quote_line_details

153: l_inv_site_id NUMBER;
154:
155: cursor c_root_model_line_id is
156: select quote_line_id
157: from aso_quote_line_details
158: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
159: from aso_quote_line_details
160: where quote_line_id = p_qte_line_id)
161: and ref_type_code = 'CONFIG'

Line 159: from aso_quote_line_details

155: cursor c_root_model_line_id is
156: select quote_line_id
157: from aso_quote_line_details
158: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
159: from aso_quote_line_details
160: where quote_line_id = p_qte_line_id)
161: and ref_type_code = 'CONFIG'
162: and ref_line_id is null;
163:

Line 288: from aso_quote_line_details

284: where quote_line_id = p_qte_line_id;
285:
286: cursor c_root_model_line_id is
287: select quote_line_id
288: from aso_quote_line_details
289: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
290: from aso_quote_line_details
291: where quote_line_id = p_qte_line_id)
292: and ref_type_code = 'CONFIG'

Line 290: from aso_quote_line_details

286: cursor c_root_model_line_id is
287: select quote_line_id
288: from aso_quote_line_details
289: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
290: from aso_quote_line_details
291: where quote_line_id = p_qte_line_id)
292: and ref_type_code = 'CONFIG'
293: and ref_line_id is null;
294:

Line 516: from aso_quote_line_details

512: AND a.cust_account_id = l_cust_id;
513:
514: cursor c_root_model_line_id is
515: select quote_line_id
516: from aso_quote_line_details
517: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
518: from aso_quote_line_details
519: where quote_line_id = p_qte_line_id)
520: and ref_type_code = 'CONFIG'

Line 518: from aso_quote_line_details

514: cursor c_root_model_line_id is
515: select quote_line_id
516: from aso_quote_line_details
517: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
518: from aso_quote_line_details
519: where quote_line_id = p_qte_line_id)
520: and ref_type_code = 'CONFIG'
521: and ref_line_id is null;
522:

Line 804: from aso_quote_line_details

800: l_ship_site_id NUMBER;
801:
802: cursor c_root_model_line_id is
803: select quote_line_id
804: from aso_quote_line_details
805: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
806: from aso_quote_line_details
807: where quote_line_id = p_qte_line_id)
808: and ref_type_code = 'CONFIG'

Line 806: from aso_quote_line_details

802: cursor c_root_model_line_id is
803: select quote_line_id
804: from aso_quote_line_details
805: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
806: from aso_quote_line_details
807: where quote_line_id = p_qte_line_id)
808: and ref_type_code = 'CONFIG'
809: and ref_line_id is null;
810: