DBA Data[Home] [Help]

APPS.RLM_RD_SV dependencies on OE_ORDER_HEADERS

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',