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 9691: FROM oe_order_headers_all

9687: BEGIN
9688: SELECT DECODE(order_date_type_code, 'ARRIVAL', 'DELIVER', 'SHIP'),
9689: order_number
9690: INTO v_order_date_type_code, v_order_number
9691: FROM oe_order_headers_all
9692: WHERE header_id = x_line.order_header_id;
9693: EXCEPTION
9694: WHEN NO_DATA_FOUND THEN
9695: RAISE;