APPS.OKS_BILLING_PUB dependencies on OKC_STATUSES_B

Line 6304: from okc_statuses_b osb

6300: ) as1,
6301: okc_k_headers_b hdr,
6302: (
6303: Select distinct code
6304: from okc_statuses_b osb
6305: where osb.ste_code <> 'HOLD'
6306: ) sts
6307: WHERE Hdr.id = line.dnz_chr_id
6308: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6359: from okc_statuses_b osb

6355: okc_k_headers_all_b hdr,
6356: mo_glob_org_access_tmp oa,
6357: (
6358: Select distinct code
6359: from okc_statuses_b osb
6360: where osb.ste_code <> 'HOLD'
6361: ) sts
6362: WHERE Hdr.id = line.dnz_chr_id
6363: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6401: from okc_statuses_b osb

6397: ) as1,
6398: okc_k_headers_b hdr,
6399: (
6400: Select distinct code
6401: from okc_statuses_b osb
6402: where osb.ste_code <> 'HOLD'
6403: ) sts
6404: WHERE Hdr.id = line.dnz_chr_id
6405: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6441: from okc_statuses_b osb

6437: ) as1,
6438: okc_k_headers_b hdr,
6439: (
6440: Select distinct code
6441: from okc_statuses_b osb
6442: where osb.ste_code <> 'HOLD'
6443: ) sts
6444: WHERE Hdr.id = line.dnz_chr_id
6445: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6489: from okc_statuses_b osb

6485: ) as1,
6486: okc_k_headers_b hdr,
6487: (
6488: Select distinct code
6489: from okc_statuses_b osb
6490: where osb.ste_code <> 'HOLD'
6491: ) sts
6492: WHERE Hdr.id = line.dnz_chr_id
6493: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6530: from okc_statuses_b osb

6526: ) as1,
6527: okc_k_headers_b hdr,
6528: (
6529: Select distinct code
6530: from okc_statuses_b osb
6531: where osb.ste_code <> 'HOLD'
6532: ) sts
6533: WHERE Hdr.id = line.dnz_chr_id
6534: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6575: AND exists (Select 1 from okc_statuses_b osb

6571: AND line.id IN (Select lvl.parent_cle_id
6572: from oks_level_elements lvl
6573: where lvl.date_completed is null
6574: and lvl.date_to_interface < trunc(p_date) + 1 )
6575: AND exists (Select 1 from okc_statuses_b osb
6576: where osb.ste_code <> 'HOLD'
6577: and osb.code = Hdr.sts_code )
6578: AND exists ( SELECT 1 from okc_assents a
6579: where line.sts_code = a.sts_code

Line 6621: from okc_statuses_b osb

6617: ) as1,
6618: okc_k_headers_b hdr,
6619: (
6620: Select /*+ FULL (osb) no_merge */ distinct code
6621: from okc_statuses_b osb
6622: where osb.ste_code <> 'HOLD'
6623: ) sts,
6624: (
6625: Select /*+ FULL (grp) no_merge */ distinct included_chr_id

Line 6669: from okc_statuses_b osb

6665: ) as1,
6666: okc_k_headers_b hdr,
6667: (
6668: Select /*+ FULL (osb) no_merge */ distinct code
6669: from okc_statuses_b osb
6670: where osb.ste_code <> 'HOLD'
6671: ) sts,
6672: (
6673: Select /*+ FULL (grp) no_merge */ distinct included_chr_id

Line 6719: AND exists (Select 1 from okc_statuses_b osb

6715: from oks_level_elements lvl
6716: where lvl.date_completed is null
6717: and (lvl.date_to_interface > TRUNC(l_date_interface_start) -1 AND
6718: lvl.date_to_interface < trunc(p_date) +1))
6719: AND exists (Select 1 from okc_statuses_b osb
6720: where osb.ste_code <> 'HOLD'
6721: and osb.code = Hdr.sts_code )
6722: AND exists ( SELECT 1 from okc_assents a
6723: where line.sts_code = a.sts_code

Line 6750: AND exists (Select 1 from okc_statuses_b osb

6746: AND line.id IN (Select lvl.parent_cle_id
6747: from oks_level_elements lvl
6748: where lvl.date_completed is null
6749: and lvl.date_to_interface < trunc(p_date) +1)
6750: AND exists (Select 1 from okc_statuses_b osb
6751: where osb.ste_code <> 'HOLD'
6752: and osb.code = Hdr.sts_code )
6753: AND exists ( SELECT 1 from okc_assents a
6754: where line.sts_code = a.sts_code

Line 6790: AND exists (Select 1 from okc_statuses_b osb

6786: AND line.id IN (Select lvl.parent_cle_id
6787: from oks_level_elements lvl
6788: where lvl.date_completed is null
6789: and lvl.date_to_interface < trunc(p_date) +1 ) /*13105205*/
6790: AND exists (Select 1 from okc_statuses_b osb
6791: where osb.ste_code <> 'HOLD'
6792: and osb.code = Hdr.sts_code )
6793: AND exists ( SELECT 1 from okc_assents a
6794: where line.sts_code = a.sts_code