APPS.ASO_PRICING_INT dependencies on ASO_SHIPMENTS

Line 76: FROM aso_quote_headers_all qh, aso_shipments qs

72: l_ship_to_cust_account_id NUMBER;
73:
74: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
75: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
76: FROM aso_quote_headers_all qh, aso_shipments qs
77: WHERE qh.quote_header_id = qs.quote_header_id
78: AND qh.quote_header_id = l_quote_header_id
79: AND qs.quote_line_id is NULL;
80:

Line 130: aso_shipments qs,

126:
127: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
128: SELECT qh.cust_account_id, qs.ship_to_party_site_id,qs.ship_to_cust_account_id
129: FROM aso_quote_headers_all qh,
130: aso_shipments qs,
131: aso_quote_lines_all ql
132: WHERE qh.quote_header_id = qs.quote_header_id
133: AND ql.quote_header_id = qh.quote_header_id
134: AND ql.quote_line_id = l_quote_line_id

Line 294: FROM aso_shipments qs

290: RETURN NUMBER
291: IS
292: CURSOR C_get_quote_info (l_quote_header_id NUMBER) IS
293: SELECT qs.ship_to_party_site_id
294: FROM aso_shipments qs
295: WHERE qs.quote_header_id = l_quote_header_id
296: AND qs.quote_line_id IS NULL;
297:
298: x_ship_party_site_id NUMBER := NULL;

Line 319: FROM aso_shipments qs

315: RETURN NUMBER
316: IS
317: CURSOR C_get_quote_info (l_quote_line_id NUMBER) IS
318: SELECT qs.ship_to_party_site_id
319: FROM aso_shipments qs
320: WHERE qs.quote_line_id = l_quote_line_id;
321:
322: x_ship_party_site_id NUMBER;
323:

Line 1653: Cursor get_req_date is SELECT request_date from aso_shipments

1649: p_qte_header_id number
1650: ) RETURN DATE
1651: IS
1652:
1653: Cursor get_req_date is SELECT request_date from aso_shipments
1654: WHERE
1655: quote_header_id = p_qte_header_id and quote_line_id is NULL;
1656: l_request_date DATE;
1657: x_request_date DATE;

Line 1672: Cursor get_req_date is SELECT request_date from aso_shipments

1668: p_qte_line_id number
1669: ) RETURN DATE
1670: IS
1671:
1672: Cursor get_req_date is SELECT request_date from aso_shipments
1673: WHERE quote_line_id = p_qte_line_id ;
1674: l_request_date DATE;
1675: x_request_date DATE;
1676: BEGIN

Line 1694: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

1690: p_qte_header_id number
1691: ) RETURN DATE
1692: IS
1693:
1694: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
1695: WHERE
1696: quote_header_id = p_qte_header_id and quote_line_id is NULL;
1697: l_freight_terms_code VARCHAR2(30);
1698: BEGIN

Line 1710: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

1706: p_qte_line_id number
1707: ) RETURN VARCHAR2
1708: IS
1709:
1710: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
1711: WHERE
1712: quote_line_id = p_qte_line_id;
1713: l_freight_terms_code VARCHAR2(30);
1714: BEGIN