APPS.OKS_BILLING_PUB dependencies on OKC_ASSENTS

Line 3125: from okc_assents a

3121: ) lvl,
3122: okc_k_lines_b line,
3123: (
3124: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3125: from okc_assents a
3126: where a.opn_code = 'INVOICE'
3127: and a.allowed_yn = 'Y'
3128: ) as1,
3129: okc_k_headers_b hdr,

Line 3168: from okc_assents a

3164: ) lvl,
3165: okc_k_lines_b line,
3166: (
3167: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3168: from okc_assents a
3169: where a.opn_code = 'INVOICE'
3170: and a.allowed_yn = 'Y'
3171: ) as1,
3172: okc_k_headers_b hdr,

Line 3211: AND exists ( SELECT 1 from okc_assents a

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
3213: and a.scs_code = Hdr.scs_code
3214: and a.opn_code = 'INVOICE'
3215: and a.allowed_yn = 'Y' )

Line 3241: from okc_assents a

3237: ) lvl,
3238: okc_k_lines_b line,
3239: (
3240: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
3241: from okc_assents a
3242: where a.opn_code = 'INVOICE'
3243: and a.allowed_yn = 'Y'
3244: ) as1,
3245: okc_k_headers_b hdr,

Line 3300: AND exists ( SELECT 1 from okc_assents a

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
3302: and a.scs_code = Hdr.scs_code
3303: and a.opn_code = 'INVOICE'
3304: and a.allowed_yn = 'Y' )