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.OKE_CONTRACT_PARTY_PUB dependencies on OKC_SUBCLASS_ROLES

Line 175: FROM OKC_SUBCLASS_ROLES SRE

171: WHERE V.DNZ_CHR_ID = p_cplv_rec.dnz_chr_id AND V.CHR_ID IS NOT NULL
172: AND okl.id= p_cplv_rec.cle_id
173: AND EXISTS (
174: SELECT NULL
175: FROM OKC_SUBCLASS_ROLES SRE
176: , OKC_LINE_STYLE_ROLES LSR
177: WHERE LSR.LSE_ID = okl.lse_id
178: AND SRE.ID = LSR.SRE_ID
179: AND SRE.SCS_CODE = 'PROJECT'

Line 196: , OKC_SUBCLASS_ROLES SRE

192:
193: CURSOR get_jtot_object_code_header(p_buy_sell VARCHAR2,p_scs_code IN varchar2) is
194: SELECT JTOT_OBJECT_CODE
195: FROM OKC_ROLE_SOURCES RSC
196: , OKC_SUBCLASS_ROLES SRE
197: WHERE
198: RSC.RLE_CODE = p_cplv_rec.rle_code
199: AND SRE.RLE_CODE = RSC.RLE_CODE
200: AND SRE.SCS_CODE = p_scs_code