DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKC_K_REL_OBJS

Line 1270: OKC_K_REL_OBJS_V rel,

1266: ord.ORDER_NUMBER OrderNumber,
1267: hdr.START_DATE ContStartDate,
1268: hdr.END_DATE ContEndDate
1269: FROM
1270: OKC_K_REL_OBJS_V rel,
1271: OKX_ORDER_HEADERS_V ord,
1272: OKC_STATUSES_V sts,
1273: OKC_SUBCLASSES_V cat,
1274: OKC_K_VERS_NUMBERS_V ver,

Line 3756: AND not exists (select 1 from okc_k_rel_objs rel

3752: AND sub_line.lse_id in (8,7,9,10,11,13,25,35)
3753: AND okcItms.cle_id = sub_line.id
3754: AND mtl.uom_code = okcItms.uom_code
3755: AND mtl.language = USERENV('LANG')
3756: AND not exists (select 1 from okc_k_rel_objs rel
3757: WHERE rel.cle_id = sub_line.id );
3758:
3759: CURSOR covered_products_sub_cur(p_covered_prod_id VARCHAR2)
3760: IS