232: FROM OKC_K_PARTY_ROLES_B rle,
233: OKC_K_HEADERS_ALL_V hdr1,
234: okc_k_items itm,
235: MTL_SYSTEM_ITEMS_B_KFV B,
236: MTL_SYSTEM_ITEMS_TL T
237: WHERE rle.jtot_object1_code='OKX_PARTY'
238: and rle.object1_id1 =to_number(p_party_id)
239: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
240: AND RLE.CLE_ID IS NULL
642: FROM OKC_K_PARTY_ROLES_B rle,
643: OKC_K_HEADERS_ALL_V hdr1,
644: okc_k_items itm,
645: MTL_SYSTEM_ITEMS_B_KFV B,
646: MTL_SYSTEM_ITEMS_TL T
647: WHERE rle.jtot_object1_code='OKX_PARTY'
648: and rle.object1_id1 =to_number(p_party_id)
649: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')
650: AND RLE.CLE_ID IS NULL