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 1638: Cursor get_req_date is SELECT request_date from aso_shipments

1634: p_qte_header_id number
1635: ) RETURN DATE
1636: IS
1637:
1638: Cursor get_req_date is SELECT request_date from aso_shipments
1639: WHERE
1640: quote_header_id = p_qte_header_id and quote_line_id is NULL;
1641: l_request_date DATE;
1642: x_request_date DATE;

Line 1657: Cursor get_req_date is SELECT request_date from aso_shipments

1653: p_qte_line_id number
1654: ) RETURN DATE
1655: IS
1656:
1657: Cursor get_req_date is SELECT request_date from aso_shipments
1658: WHERE quote_line_id = p_qte_line_id ;
1659: l_request_date DATE;
1660: x_request_date DATE;
1661: BEGIN

Line 1679: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

1675: p_qte_header_id number
1676: ) RETURN DATE
1677: IS
1678:
1679: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
1680: WHERE
1681: quote_header_id = p_qte_header_id and quote_line_id is NULL;
1682: l_freight_terms_code VARCHAR2(30);
1683: BEGIN

Line 1695: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments

1691: p_qte_line_id number
1692: ) RETURN VARCHAR2
1693: IS
1694:
1695: Cursor get_frieght is SELECT FREIGHT_TERMS_CODE from aso_shipments
1696: WHERE
1697: quote_line_id = p_qte_line_id;
1698: l_freight_terms_code VARCHAR2(30);
1699: BEGIN