APPS.RLM_RD_SV dependencies on RLM_BLANKET_RSO

Line 13965: rlm_blanket_rso rso

13961: ril.intrmd_ship_to_id, --Bugfix 5911991
13962: ril.intmed_ship_to_org_id --Bugfix 5911991
13963: FROM rlm_interface_headers rih,
13964: rlm_interface_lines_all ril,
13965: rlm_blanket_rso rso
13966: WHERE rih.header_id = x_Sched_rec.header_id
13967: AND rih.org_id = ril.org_id
13968: AND ril.header_id = rih.header_id
13969: AND ril.ship_from_org_id = x_Group_rec.ship_from_org_id

Line 15200: FROM RLM_BLANKET_RSO

15196: v_rso_start_date DATE;
15197: --
15198: CURSOR c_getMaxRSO IS
15199: SELECT rso_hdr_id, effective_start_date
15200: FROM RLM_BLANKET_RSO
15201: WHERE blanket_number = v_BlkGroup_rec.setup_terms_rec.blanket_number
15202: AND customer_item_id =
15203: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',
15204: v_BlkGroup_rec.customer_item_id, k_NNULL)

Line 15207: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

15203: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',
15204: v_BlkGroup_rec.customer_item_id, k_NNULL)
15205: AND effective_start_date =
15206: (SELECT max(rlm.effective_start_date)
15207: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
15208: WHERE rlm.blanket_number = v_BlkGroup_rec.setup_terms_rec.blanket_number
15209: AND rlm.rso_hdr_id = oe.header_id
15210: AND rlm.customer_item_id =
15211: DECODE(v_BlkGroup_rec.setup_terms_rec.release_rule, 'PI',