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 525: from aso_quote_lines_all

521: and ref_line_id is null;
522:
523: cursor c_item_type_code is
524: select item_type_code
525: from aso_quote_lines_all
526: where quote_line_id = p_qte_line_id;
527:
528: cursor c_shipment_id (p_line_id NUMBER) is
529: select shipment_id

Line 813: from aso_quote_lines_all

809: and ref_line_id is null;
810:
811: cursor c_item_type_code is
812: select item_type_code
813: from aso_quote_lines_all
814: where quote_line_id = p_qte_line_id;
815:
816: cursor c_shipment_id (p_line_id NUMBER) is
817: select shipment_id