[Home] [Help]
155: IS
156: SELECT *
157: FROM ZX_DETAIL_TAX_LINES_GT
158: WHERE application_id = 660
159: AND entity_code = 'OE_ORDER_HEADERS'
160: AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
161: AND trx_id = p_header_id
162: AND trx_line_id = p_adj_id
163: AND trx_level_type = 'FREIGHT_CHARGE';
165: IS
166: SELECT *
167: FROM ZX_DETAIL_TAX_LINES_GT
168: WHERE application_id = 660
169: AND entity_code = 'OE_ORDER_HEADERS'
170: AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
171: AND trx_id = p_header_id
172: AND trx_line_id = p_line_id
173: AND trx_level_type = 'LINE'; --'LINE';
212: l_bill_party_id NUMBER(15);
213: l_bill_party_site_id NUMBER(15);
214: l_bill_location_id NUMBER(15);
215: l_internal_org_location_id NUMBER;
216: l_header_id oe_order_headers.header_id%type;
217: l_tax_date oe_order_lines.tax_date%type;
218: l_ordered_quantity oe_order_lines.ordered_quantity%type;
219: l_unit_selling_price oe_order_lines.unit_selling_price%type;
220: l_tax_exempt_number oe_order_lines.tax_exempt_number%type;
229: l_trx_line_number NUMBER;
230: l_user_item_description VARCHAR2(1000);
231: l_product_fisc_classification VARCHAR2(240);
232: l_ship_from_location_id NUMBER;
233: l_salesrep_id oe_order_headers.salesrep_id%type;
234: L_POO_PARTY_ID NUMBER;
235: l_POO_LOCATION_ID NUMBER;
236: l_bill_from_location_id NUMBER;
237: l_legal_entity_id NUMBER(15);
255: RETURN;
256: END IF;
257: /* initialising common variables */
258: l_return_status := FND_API.G_RET_STS_SUCCESS;
259: l_entity_code_crsr := 'OE_ORDER_HEADERS';
260: l_event_class_code_crsr := 'SALES_TRANSACTION_TAX_QUOTE';
261: l_call_tax := 'N';
262: l_tax_value := 0;
263: l_application_id := 660;
328: BEGIN
329: SELECT NVL (ot.cust_trx_type_id, 0)
330: INTO l_cust_trx_type_id
331: FROM oe_order_types_v ot,
332: oe_order_headers_all oh
333: WHERE ot.order_type_id = oh.order_type_id
334: AND oh.header_id = l_header_rec.header_id;
335: EXCEPTION
336: WHEN OTHERS THEN
1931: END LOOP;
1932:
1933: l_transaction_rec.application_id := 660;
1934: --TaxER start
1935: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1936: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1937: --TaxER end
1938: l_transaction_rec.event_type_code := 'CREATE';
1939: l_transaction_rec.trx_id := l_header_id;
2576: INTO l_org_id
2577: ,l_sold_to_customer_id
2578: ,l_invoice_to_org_id
2579: ,l_order_type_id
2580: FROM oe_order_headers_all
2581: WHERE header_id = p_header_id;
2582:
2583: IF (l_invoice_to_org_id IS NOT NULL) THEN
2584: SELECT acct_site.cust_account_id