APPS.RLM_BLANKET_SV dependencies on OE_ORDER_HEADERS

Line 131: -- * A valid RSO Header ID, corresponding to a record in oe_order_headers

127: rlm_core_sv.dlog(C_DEBUG, 'v_minstart_date', v_minstart_date);
128: END IF;
129: --
130: -- Bug 4901148 : QueryRSO() returns one of the following values
131: -- * A valid RSO Header ID, corresponding to a record in oe_order_headers
132: -- * -1 if the RSO Header is closed
133: -- * -99 if it found an orphan RSO in rlm_blanket_rso table.
134: -- * NULL if no RSO encompasses the request date of the line.
135: --

Line 281: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

277: --
278: CURSOR rlm_rso_pi IS
279: SELECT max(decode(oe.open_flag, 'Y', rso_hdr_id, 'N', -1, -99)),
280: effective_start_date, effective_end_date
281: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
282: WHERE customer_id = p_customer_id AND
283: rlm.blanket_number = x_Group_rec.setup_terms_rec.blanket_number AND
284: customer_item_id = p_cust_item_id AND
285: rlm.rso_hdr_id = oe.header_id(+)

Line 292: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

288: --
289: CURSOR rlm_rso_ai IS
290: SELECT max(decode(oe.open_flag, 'Y', rso_hdr_id, 'N', -1, -99)),
291: effective_start_date, effective_end_date
292: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
293: WHERE customer_id = p_customer_id AND
294: rlm.blanket_number = x_Group_rec.setup_terms_rec.blanket_number AND
295: rlm.customer_item_id = k_NNULL AND
296: rlm.rso_hdr_id = oe.header_id(+)