APPS.RLM_BLANKET_SV dependencies on OE_ORDER_HEADERS

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

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

Line 285: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

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

Line 296: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

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