DBA Data[Home] [Help]

APPS.OKS_BILLING_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 5395: OKC_K_PARTY_ROLES_B okp

5391: ,rul.price_uom
5392: ,nvl(rul.summary_trx_yn,'N') summary_yn
5393: ,rline.settlement_interval
5394: FROM
5395: OKC_K_PARTY_ROLES_B okp
5396: ,OKC_K_LINES_B line
5397: ,OKS_K_LINES_B rline
5398: ,OKC_K_HEADERS_B Hdr
5399: ,OKS_K_HEADERS_B rul

Line 6778: (select 1 from OKC_K_PARTY_ROLES_B okp

6774: AND Hdr.Template_yn = 'N'
6775: AND Hdr.Authoring_Org_Id = nvl(l_org_id, hdr.authoring_org_id)
6776: AND Hdr.Scs_code = nvl(p_category, hdr.scs_code)
6777: AND exists
6778: (select 1 from OKC_K_PARTY_ROLES_B okp
6779: where okp.dnz_chr_id = hdr.id
6780: and okp.rle_code in ('CUSTOMER','SUBSCRIBER')
6781: and okp.object1_id1 = nvl(P_customer_id, okp.object1_id1) )
6782: AND exists