APPS.ASO_SHIPMENT_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 150: SELECT invoice_to_party_site_id FROM ASO_quote_headers_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
150: SELECT invoice_to_party_site_id FROM ASO_quote_headers_All
151: WHERE quote_header_id = p_qte_header_id;
152:
153: l_inv_site_id NUMBER;
154:

Line 251: SELECT invoice_to_party_site_id FROM ASO_quote_headers_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
251: SELECT invoice_to_party_site_id FROM ASO_quote_headers_All
252: WHERE quote_header_id = p_qte_header_id;
253:
254: l_inv_site_id NUMBER;
255: l_ship_site_id NUMBER;

Line 259: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL

255: l_ship_site_id NUMBER;
256: l_bill_site_use_id NUMBER;
257:
258: CURSOR c_cust_id IS
259: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL
260: WHERE quote_header_id = p_qte_header_id;
261:
262: CURSOR C_site_use(l_cust_id NUMBER, l_inv_site_id NUMBER) IS
263: SELECT site_use_id

Line 275: SELECT INVOICE_TO_CUST_ACCOUNT_ID FROM ASO_QUOTE_HEADERS_ALL

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
276: WHERE quote_header_id = p_qte_header_id ;
277:
278: l_cust_id NUMBER;
279: p_shipment_id NUMBER := NULL;

Line 490: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL

486: l_ship_site_id NUMBER;
487: l_ship_cust_acct_id NUMBER;
488: l_ship_site_use_id NUMBER;
489: CURSOR c_cust_id IS
490: SELECT cust_account_id FROM ASO_QUOTE_HEADERS_ALL
491: WHERE quote_header_id = p_qte_header_id;
492:
493: CURSOR c_ship_cust_id IS
494: SELECT SHIP_TO_CUST_ACCOUNT_ID FROM ASO_SHIPMENTS