APPS.OKS_BILLING_PUB dependencies on OKC_STATUSES_B

Line 3132: from okc_statuses_b osb

3128: ) as1,
3129: okc_k_headers_b hdr,
3130: (
3131: Select /*+ FULL (osb) no_merge */ distinct code
3132: from okc_statuses_b osb
3133: where osb.ste_code <> 'HOLD'
3134: ) sts
3135: WHERE Hdr.id = line.dnz_chr_id
3136: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 3175: from okc_statuses_b osb

3171: ) as1,
3172: okc_k_headers_b hdr,
3173: (
3174: Select /*+ FULL (osb) no_merge */ distinct code
3175: from okc_statuses_b osb
3176: where osb.ste_code <> 'HOLD'
3177: ) sts
3178: WHERE Hdr.id = line.dnz_chr_id
3179: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 3208: AND exists (Select 1 from okc_statuses_b osb

3204: AND line.id IN (Select lvl.parent_cle_id
3205: from oks_level_elements lvl
3206: where lvl.date_completed is null
3207: and trunc(lvl.date_to_interface) <= trunc(p_date) )
3208: AND exists (Select 1 from okc_statuses_b osb
3209: where osb.ste_code <> 'HOLD'
3210: and osb.code = Hdr.sts_code )
3211: AND exists ( SELECT 1 from okc_assents a
3212: where line.sts_code = a.sts_code

Line 3248: from okc_statuses_b osb

3244: ) as1,
3245: okc_k_headers_b hdr,
3246: (
3247: Select /*+ FULL (osb) no_merge */ distinct code
3248: from okc_statuses_b osb
3249: where osb.ste_code <> 'HOLD'
3250: ) sts,
3251: (
3252: Select /*+ FULL (grp) no_merge */ distinct included_chr_id

Line 3297: AND exists (Select 1 from okc_statuses_b osb

3293: AND line.id IN (Select lvl.parent_cle_id
3294: from oks_level_elements lvl
3295: where lvl.date_completed is null
3296: and trunc(lvl.date_to_interface) <= trunc(p_date) )
3297: AND exists (Select 1 from okc_statuses_b osb
3298: where osb.ste_code <> 'HOLD'
3299: and osb.code = Hdr.sts_code )
3300: AND exists ( SELECT 1 from okc_assents a
3301: where line.sts_code = a.sts_code