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_QA_DATA_INTEGRITY dependencies on OKC_CONTEXT

Line 3773: AND ohs.org_id = okc_context.get_okc_org_id

3769: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3770: okc_k_headers_all_b rl
3771: WHERE ohs.hold_entity_code = 'C'
3772: AND ohs.released_flag = 'N'
3773: AND ohs.org_id = okc_context.get_okc_org_id
3774: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
3775: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
3776: AND CS.SITE_USE_CODE = 'BILL_TO'
3777: AND PS.PARTY_ID = prt.party_id

Line 3805: AND ohs.org_id = okc_context.get_okc_org_id

3801: HZ_CUST_SITE_USES_ALL CS,
3802: okc_k_headers_all_b rl
3803: WHERE ohs.hold_entity_code = 'C'
3804: AND ohs.released_flag = 'N'
3805: AND ohs.org_id = okc_context.get_okc_org_id
3806: AND ohs.hold_id = ohd.hold_id
3807: AND ohd.type_code IN ('CREDIT', 'EPAYMENT', 'COMPLIANCE', 'GSA')
3808: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
3809: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID

Line 3837: AND ohs.org_id = okc_context.get_okc_org_id

3833: HZ_CUST_SITE_USES_ALL CS,
3834: okc_k_headers_all_b rl
3835: WHERE ohs.hold_entity_code = 'B'
3836: AND ohs.released_flag = 'N'
3837: AND ohs.org_id = okc_context.get_okc_org_id
3838: AND ohs.hold_id = ohd.hold_id
3839: AND ohd.type_code IN ('CREDIT', 'EPAYMENT', 'COMPLIANCE', 'GSA')
3840: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID
3841: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID