APPS.ASO_SHIPMENT_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 145: SELECT invoice_to_party_site_id FROM ASO_quote_lines_All

141: p_qte_line_id NUMBER
142: ) RETURN NUMBER
143: IS
144: CURSOR c_inv_site1 IS
145: SELECT invoice_to_party_site_id FROM ASO_quote_lines_All
146: WHERE quote_line_id = p_qte_line_id
147: AND quote_header_id = p_qte_header_id;
148:
149: CURSOR c_inv_site2 IS

Line 166: from aso_quote_lines_all

162: and ref_line_id is null;
163:
164: cursor c_item_type_code is
165: select item_type_code
166: from aso_quote_lines_all
167: where quote_line_id = p_qte_line_id;
168:
169: l_model_quote_line_id NUMBER;
170: l_item_type_code VARCHAR2(30);

Line 246: SELECT invoice_to_party_site_id FROM ASO_quote_lines_All

242: ) RETURN NUMBER
243: IS
244:
245: CURSOR c_inv_site1 IS
246: SELECT invoice_to_party_site_id FROM ASO_quote_lines_All
247: WHERE quote_line_id = p_qte_line_id
248: AND quote_header_id = p_qte_header_id;
249:
250: CURSOR c_inv_site2 IS

Line 271: SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_LINES_ALL

267: AND a.party_site_id = l_inv_site_id
268: AND a.cust_account_id = l_cust_id;
269:
270: CURSOR c_inv_cust_id IS
271: SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_LINES_ALL
272: WHERE quote_header_id = p_qte_header_id and quote_line_id =p_qte_line_id ;
273:
274: CURSOR c_inv_cust_id1 IS
275: SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_HEADERS_ALL

Line 283: from aso_quote_lines_all

279: p_shipment_id NUMBER := NULL;
280:
281: cursor c_item_type_code is
282: select item_type_code
283: from aso_quote_lines_all
284: where quote_line_id = p_qte_line_id;
285:
286: cursor c_root_model_line_id is
287: select quote_line_id

Line 543: from aso_quote_lines_all

539: and ref_line_id is null;
540:
541: cursor c_item_type_code is
542: select item_type_code
543: from aso_quote_lines_all
544: where quote_line_id = p_qte_line_id;
545:
546: cursor c_shipment_id (p_line_id NUMBER) is
547: select shipment_id

Line 862: from aso_quote_lines_all

858: and ref_line_id is null;
859:
860: cursor c_item_type_code is
861: select item_type_code
862: from aso_quote_lines_all
863: where quote_line_id = p_qte_line_id;
864:
865: cursor c_shipment_id (p_line_id NUMBER) is
866: select shipment_id