APPS.RLM_EXTINTERFACE_SV dependencies on RLM_BLANKET_RSO

Line 2188: FROM rlm_blanket_rso

2184: IF x_Group_rec.blanket_number IS NOT NULL THEN
2185:
2186: SELECT effective_start_date, effective_end_date
2187: INTO l_effective_start_date, l_effective_end_date
2188: FROM rlm_blanket_rso
2189: WHERE blanket_number = x_Group_rec.blanket_number
2190: AND rso_hdr_id = x_Group_rec.order_header_id;
2191:
2192: IF TO_DATE(x_optional_match_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < trunc(l_effective_start_date) THEN

Line 2199: ' (SELECT rbr.rso_hdr_id FROM rlm_blanket_rso rbr,oe_order_headers oh WHERE rbr.blanket_number = '||x_Group_rec.blanket_number||

2195: rlm_core_sv.dlog(k_DEBUG,'Reconciling against all the Blanket Release orders');
2196: END IF;
2197:
2198: v_where_clause := ' WHERE o.header_id IN'||
2199: ' (SELECT rbr.rso_hdr_id FROM rlm_blanket_rso rbr,oe_order_headers oh WHERE rbr.blanket_number = '||x_Group_rec.blanket_number||
2200: ' AND oh.header_id = rbr.rso_hdr_id AND oh.open_flag = '||'''Y'''||')';
2201:
2202: ELSE
2203: v_where_clause := ' WHERE o.header_id = :order_header_id' ;