eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BILL_REC_PUB dependencies on OKC_ASSENTS

Line 4071: AND (exists ( SELECT 1 from okc_assents a

4067: AND lines.date_cancelled is null --LLC BUG FIX 4742661
4068: And lines.date_terminated is null
4069: And lines.cle_id is null
4070: And hdr.sts_code <> 'QA_HOLD'
4071: AND (exists ( SELECT 1 from okc_assents a
4072: where Hdr.scs_code = a.scs_code
4073: and lines.sts_code = a.sts_code
4074: and lines.sts_code <> 'HOLD'
4075: and a.opn_code = 'INVOICE'

Line 4096: AND (exists ( SELECT 1 from okc_assents a

4092: okc_k_lines_b lines
4093: WHERE lines.id = p_line_id
4094: AND hdr.id = lines.dnz_chr_id
4095: AND hdr.sts_code <> 'QA_HOLD'
4096: AND (exists ( SELECT 1 from okc_assents a
4097: where Hdr.scs_code = a.scs_code
4098: and lines.sts_code = a.sts_code
4099: and lines.sts_code <> 'HOLD'
4100: and a.opn_code = 'INVOICE'

Line 8175: AND (exists ( SELECT 1 from okc_assents a

8171: AND line2.id = line1.cle_id
8172: AND rline.cle_id = line2.id
8173: AND hdr.id = line1.dnz_chr_id
8174: AND hdr.sts_code <> 'QA_HOLD'
8175: AND (exists ( SELECT 1 from okc_assents a
8176: where Hdr.scs_code = a.scs_code
8177: and line1.sts_code = a.sts_code
8178: and line1.sts_code <> 'HOLD'
8179: and a.opn_code = 'INVOICE'