DBA Data[Home] [Help]

APPS.ASO_TAX_INT dependencies on ASO_SHIPMENTS

Line 217: from aso_shipments

213: X_Msg_Data OUT NOCOPY VARCHAR2)
214: IS
215: Cursor C_shipment(l_quote_header_id NUMBER) IS
216: select quote_line_id, shipment_id
217: from aso_shipments
218: where quote_header_id = l_quote_header_id;
219:
220:
221: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Tax';

Line 2271: from aso_shipments

2267: and site_use.SITE_USE_ID=l_site_use_id;
2268:
2269: Cursor c_ship_to_cust_account_id is
2270: select ship_to_cust_account_id
2271: from aso_shipments
2272: where quote_header_id = l_qte_header_rec.quote_header_id
2273: and quote_line_id is null;
2274:
2275: Cursor c_location_id is

Line 3077: Zx_detail_tax_lines_gt a,aso_shipments b

3073: a.TAX_DETERMINE_DATE,a.TAX_AMT,a.EXEMPT_CERTIFICATE_NUMBER,a.EXEMPT_REASON_CODE,
3074: a.TAX_AMT_INCLUDED_FLAG,a.OBJECT_VERSION_NUMBER,a.TAX_RATE_ID,
3075: nvl(l_HDR_TAX_EXEMPT_FLAG,'S') --Added by anrajan on 05/10/2005
3076: FROM
3077: Zx_detail_tax_lines_gt a,aso_shipments b
3078: WHERE
3079: a.TRX_ID=b.QUOTE_HEADER_ID
3080: AND
3081: a.APPLICATION_ID=697