APPS.RLM_RD_SV dependencies on RLM_BLANKET_RSO

Line 13771: rlm_blanket_rso rso

13767: ril.intrmd_ship_to_id, --Bugfix 5911991
13768: ril.intmed_ship_to_org_id --Bugfix 5911991
13769: FROM rlm_interface_headers rih,
13770: rlm_interface_lines_all ril,
13771: rlm_blanket_rso rso
13772: WHERE rih.header_id = x_Sched_rec.header_id
13773: AND rih.org_id = ril.org_id
13774: AND ril.header_id = rih.header_id
13775: AND ril.ship_from_org_id = x_Group_rec.ship_from_org_id

Line 15006: FROM RLM_BLANKET_RSO

15002: v_rso_start_date DATE;
15003: --
15004: CURSOR c_getMaxRSO IS
15005: SELECT rso_hdr_id, effective_start_date
15006: FROM RLM_BLANKET_RSO
15007: WHERE blanket_number = v_BlkGroup_rec.setup_terms_rec.blanket_number
15008: AND customer_item_id =
15009: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',
15010: v_BlkGroup_rec.customer_item_id, k_NNULL)

Line 15013: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

15009: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',
15010: v_BlkGroup_rec.customer_item_id, k_NNULL)
15011: AND effective_start_date =
15012: (SELECT max(rlm.effective_start_date)
15013: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
15014: WHERE rlm.blanket_number = v_BlkGroup_rec.setup_terms_rec.blanket_number
15015: AND rlm.rso_hdr_id = oe.header_id
15016: AND rlm.customer_item_id =
15017: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',