DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on CS_SYSTEMS_ALL_B

Line 258: CS_SYSTEMS_ALL_B B,

254: SELECT B.SYSTEM_ID ID1
255: FROM OKC_K_PARTY_ROLES_B rle,
256: OKC_K_HEADERS_ALL_V hdr1,
257: okc_k_items itm,
258: CS_SYSTEMS_ALL_B B,
259: CS_SYSTEMS_ALL_TL T
260: WHERE rle.jtot_object1_code='OKX_PARTY'
261: and rle.object1_id1 =to_number(p_party_id)
262: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')

Line 752: CS_SYSTEMS_ALL_B B,

748: T.DESCRIPTION DESCRIPTION
749: FROM OKC_K_PARTY_ROLES_B rle,
750: OKC_K_HEADERS_ALL_V hdr1,
751: okc_k_items itm,
752: CS_SYSTEMS_ALL_B B,
753: CS_SYSTEMS_ALL_TL T
754: WHERE rle.jtot_object1_code='OKX_PARTY'
755: and rle.object1_id1 =to_number(p_party_id)
756: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')