DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 332: oe_order_headers_all oh

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

Line 2580: FROM oe_order_headers_all

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