APPS.RLM_VALIDATEDEMAND_SV dependencies on OE_ORDER_HEADERS_ALL

Line 987: FROM oe_order_headers_all

983: BEGIN
984: --
985: SELECT order_number
986: INTO v_ord_num
987: FROM oe_order_headers_all
988: WHERE header_id = x_order_header_id;
989: --
990: RETURN v_ord_num;
991: --

Line 1050: FROM oe_order_headers_all

1046: END IF;
1047: --
1048: SELECT open_flag, order_number
1049: INTO v_OpenFlag, v_OrderNumber
1050: FROM oe_order_headers_all
1051: WHERE header_id = x_lines_rec.Order_header_id;
1052: --
1053: IF (l_debug <> -1) THEN
1054: rlm_core_sv.dlog(C_DEBUG,'v_OpenFlag',v_OpenFlag);

Line 1084: FROM oe_order_headers_all

1080: IF x_setup_terms_rec.header_id IS NOT NULL THEN
1081: --{
1082: SELECT order_number, open_flag
1083: INTO v_Ordernumber, v_OpenFlag
1084: FROM oe_order_headers_all
1085: WHERE header_id = x_setup_terms_rec.header_id;
1086: --
1087: IF (l_debug <> -1) THEN
1088: rlm_core_sv.dlog('From setup terms');

Line 9767: FROM oe_order_headers_all

9763: BEGIN
9764: SELECT DECODE(order_date_type_code, 'ARRIVAL', 'DELIVER', 'SHIP'),
9765: order_number
9766: INTO v_order_date_type_code, v_order_number
9767: FROM oe_order_headers_all
9768: WHERE header_id = x_line.order_header_id;
9769: EXCEPTION
9770: WHEN NO_DATA_FOUND THEN
9771: RAISE;