APPS.ONT_ITM_PKG dependencies on OE_ORDER_HEADERS

Line 840: FROM oe_order_headers_all

836: -- Bug 7261101
837: BEGIN
838: SELECT sold_to_site_use_id
839: INTO l_sold_to_site_use_id
840: FROM oe_order_headers_all
841: WHERE header_id = p_line_rec.header_id;
842:
843: IF l_sold_to_site_use_id IS NULL THEN
844: l_sold_to_site_use_id := p_line_rec.sold_to_org_id; -- Bug 9130718

Line 869: FROM oe_order_headers_all

865:
866: BEGIN --bug 5140692
867: SELECT sold_to_contact_id
868: INTO l_sold_to_contact_id
869: FROM oe_order_headers_all
870: WHERE header_id = p_line_rec.header_id;
871: EXCEPTION
872: WHEN OTHERS THEN
873: l_sold_to_contact_id := NULL;

Line 1021: FROM oe_order_headers_v

1017: conversion_rate,ordered_date, terms
1018: INTO l_order_number,l_order_type,l_cust_po_number,
1019: l_transactional_curr_code,l_conversion_type_code,
1020: l_conversion_rate,l_ordered_date,l_payment_term_name
1021: FROM oe_order_headers_v
1022: WHERE header_id = p_line_rec.header_id; */
1023:
1024: -- Fixed for SQLperf, SQL Repository ID 14882287
1025: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,

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

1025: SELECT h.order_number, ot.name, h.cust_po_number, h.transactional_curr_code,
1026: h.conversion_type_code, h.conversion_rate, h.ordered_date, term.name
1027: INTO l_order_number, l_order_type, l_cust_po_number, l_transactional_curr_code,
1028: l_conversion_type_code, l_conversion_rate, l_ordered_date, l_payment_term_name
1029: FROM oe_order_headers h, oe_transaction_types_tl ot, ra_terms_tl term
1030: WHERE h.header_id = p_line_rec.header_id
1031: AND h.order_type_id = ot.transaction_type_id
1032: AND ot.language = userenv('LANG')
1033: AND h.payment_term_id = term.term_id(+)