APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on CZ_RULES

Line 2929: FROM cz_rules cz,

2925: (INSTR(orig_sys_ref,':',1,5) - (INSTR(orig_sys_ref,':',1,4)+1))
2926: /*SELECT DISTINCT SUBSTR(cz.orig_sys_ref, INSTR(cz.orig_sys_ref,':',-1,2)+1,
2927: (INSTR(cz.orig_sys_ref,':',-1,1) - (INSTR(cz.orig_sys_ref,':',-1,2)+1)) */
2928: )
2929: FROM cz_rules cz,
2930: okc_xprt_rule_hdrs_all h
2931: WHERE SUBSTR(cz.orig_sys_ref,INSTR(cz.orig_sys_ref,':',-1,1)+1) = to_char(h.rule_id)
2932: AND h.request_id = FND_GLOBAL.CONC_REQUEST_ID
2933: AND cz.deleted_flag = '0'