APPS.RLM_EXTINTERFACE_SV dependencies on RLM_BLANKET_RSO

Line 2364: FROM rlm_blanket_rso

2360: IF x_Group_rec.blanket_number IS NOT NULL THEN
2361:
2362: SELECT effective_start_date, effective_end_date
2363: INTO l_effective_start_date, l_effective_end_date
2364: FROM rlm_blanket_rso
2365: WHERE blanket_number = x_Group_rec.blanket_number
2366: AND rso_hdr_id = x_Group_rec.order_header_id;
2367:
2368: IF TO_DATE(x_optional_match_rec.industry_attribute2,'RRRR/MM/DD HH24:MI:SS') < trunc(l_effective_start_date) THEN

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

2371: rlm_core_sv.dlog(k_DEBUG,'Reconciling against all the Blanket Release orders');
2372: END IF;
2373:
2374: v_where_clause := ' WHERE o.header_id IN'||
2375: ' (SELECT rbr.rso_hdr_id FROM rlm_blanket_rso rbr,oe_order_headers oh WHERE rbr.blanket_number = '||x_Group_rec.blanket_number||
2376: ' AND oh.header_id = rbr.rso_hdr_id AND oh.open_flag = '||'''Y'''||')';
2377:
2378: ELSE
2379: v_where_clause := ' WHERE o.header_id = :order_header_id' ;