DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on OE_ORDER_HEADERS_ALL

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;