DBA Data[Home] [Help]

APPS.RLM_RD_SV dependencies on OE_ORDER_HEADERS

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