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 534: from aso_quote_line_details

530: AND a.cust_account_id = l_cust_id;
531:
532: cursor c_root_model_line_id is
533: select quote_line_id
534: from aso_quote_line_details
535: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
536: from aso_quote_line_details
537: where quote_line_id = p_qte_line_id)
538: and ref_type_code = 'CONFIG'

Line 536: from aso_quote_line_details

532: cursor c_root_model_line_id is
533: select quote_line_id
534: from aso_quote_line_details
535: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
536: from aso_quote_line_details
537: where quote_line_id = p_qte_line_id)
538: and ref_type_code = 'CONFIG'
539: and ref_line_id is null;
540:

Line 853: from aso_quote_line_details

849: l_ship_site_id NUMBER;
850:
851: cursor c_root_model_line_id is
852: select quote_line_id
853: from aso_quote_line_details
854: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
855: from aso_quote_line_details
856: where quote_line_id = p_qte_line_id)
857: and ref_type_code = 'CONFIG'

Line 855: from aso_quote_line_details

851: cursor c_root_model_line_id is
852: select quote_line_id
853: from aso_quote_line_details
854: where (config_header_id, config_revision_num) = (select config_header_id,config_revision_num
855: from aso_quote_line_details
856: where quote_line_id = p_qte_line_id)
857: and ref_type_code = 'CONFIG'
858: and ref_line_id is null;
859: