APPS.OKS_BILLING_PUB dependencies on OKC_ASSENTS

Line 6297: from okc_assents a

6293: ) lvl,
6294: okc_k_lines_b line,
6295: (
6296: Select distinct scs_code,sts_code
6297: from okc_assents a
6298: where a.opn_code = 'INVOICE'
6299: and a.allowed_yn = 'Y'
6300: ) as1,
6301: okc_k_headers_b hdr,

Line 6351: from okc_assents a

6347: ) lvl,
6348: okc_k_lines_b line,
6349: (
6350: Select distinct scs_code,sts_code
6351: from okc_assents a
6352: where a.opn_code = 'INVOICE'
6353: and a.allowed_yn = 'Y'
6354: ) as1,
6355: okc_k_headers_all_b hdr,

Line 6394: from okc_assents a

6390: ) lvl,
6391: okc_k_lines_b line,
6392: (
6393: Select distinct scs_code,sts_code
6394: from okc_assents a
6395: where a.opn_code = 'INVOICE'
6396: and a.allowed_yn = 'Y'
6397: ) as1,
6398: okc_k_headers_b hdr,

Line 6434: from okc_assents a

6430: ) lvl,
6431: okc_k_lines_b line,
6432: (
6433: Select distinct scs_code,sts_code
6434: from okc_assents a
6435: where a.opn_code = 'INVOICE'
6436: and a.allowed_yn = 'Y'
6437: ) as1,
6438: okc_k_headers_b hdr,

Line 6482: from okc_assents a

6478: ) lvl,
6479: okc_k_lines_b line,
6480: (
6481: Select distinct scs_code,sts_code
6482: from okc_assents a
6483: where a.opn_code = 'INVOICE'
6484: and a.allowed_yn = 'Y'
6485: ) as1,
6486: okc_k_headers_b hdr,

Line 6523: from okc_assents a

6519: ) lvl,*/ /*commented for bug 13932146 */
6520: okc_k_lines_b line,
6521: (
6522: Select distinct scs_code,sts_code
6523: from okc_assents a
6524: where a.opn_code = 'INVOICE'
6525: and a.allowed_yn = 'Y'
6526: ) as1,
6527: okc_k_headers_b hdr,

Line 6578: AND exists ( SELECT 1 from okc_assents a

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
6580: and a.scs_code = Hdr.scs_code
6581: and a.opn_code = 'INVOICE'
6582: and a.allowed_yn = 'Y' )

Line 6614: from okc_assents a

6610: ) lvl,
6611: okc_k_lines_b line,
6612: (
6613: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
6614: from okc_assents a
6615: where a.opn_code = 'INVOICE'
6616: and a.allowed_yn = 'Y'
6617: ) as1,
6618: okc_k_headers_b hdr,

Line 6662: from okc_assents a

6658: ) lvl,
6659: okc_k_lines_b line,
6660: (
6661: Select /*+ FULL (a) no_merge */ distinct scs_code,sts_code
6662: from okc_assents a
6663: where a.opn_code = 'INVOICE'
6664: and a.allowed_yn = 'Y'
6665: ) as1,
6666: okc_k_headers_b hdr,

Line 6722: AND exists ( SELECT 1 from okc_assents a

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
6724: and a.scs_code = Hdr.scs_code
6725: and a.opn_code = 'INVOICE'
6726: and a.allowed_yn = 'Y' )

Line 6753: AND exists ( SELECT 1 from okc_assents a

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
6755: and a.scs_code = Hdr.scs_code
6756: and a.opn_code = 'INVOICE'
6757: and a.allowed_yn = 'Y' )

Line 6793: AND exists ( SELECT 1 from okc_assents a

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
6795: and a.scs_code = Hdr.scs_code
6796: and a.opn_code = 'INVOICE'
6797: and a.allowed_yn = 'Y' )