APPS.ONT_ITM_PKG dependencies on OE_ORDER_HEADERS

Line 687: FROM oe_order_headers_all

683: -- Bug 7261101
684: BEGIN
685: SELECT sold_to_site_use_id
686: INTO l_sold_to_site_use_id
687: FROM oe_order_headers_all
688: WHERE header_id = p_line_rec.header_id;
689: EXCEPTION
690: WHEN OTHERS THEN
691: l_sold_to_site_use_id := NULL;

Line 706: FROM oe_order_headers_all

702:
703: BEGIN --bug 5140692
704: SELECT sold_to_contact_id
705: INTO l_sold_to_contact_id
706: FROM oe_order_headers_all
707: WHERE header_id = p_line_rec.header_id;
708: EXCEPTION
709: WHEN OTHERS THEN
710: l_sold_to_contact_id := NULL;

Line 841: FROM oe_order_headers_v

837: conversion_rate,ordered_date, terms
838: INTO l_order_number,l_order_type,l_cust_po_number,
839: l_transactional_curr_code,l_conversion_type_code,
840: l_conversion_rate,l_ordered_date,l_payment_term_name
841: FROM oe_order_headers_v
842: WHERE header_id = p_line_rec.header_id; */
843:
844: -- Fixed for SQLperf, SQL Repository ID 14882287
845: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,

Line 849: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term

845: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,
846: h.conversion_type_code, h.conversion_rate, h.ordered_date, term.name
847: INTO l_order_number, l_order_type, l_cust_po_number, l_transactional_curr_code,
848: l_conversion_type_code, l_conversion_rate, l_ordered_date, l_payment_term_name
849: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term
850: WHERE h.header_id = p_line_rec.header_id
851: AND h.order_type_id = ot.transaction_type_id
852: AND ot.language = userenv('LANG')
853: AND h.payment_term_id = term.term_id(+)