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.OKL_CREDIT_PUB dependencies on OKC_GOVERNANCES_V

Line 5988: okc_Governances_v g

5984: CURSOR c_credit (p_contract_id NUMBER)
5985: IS
5986: select a.ID
5987: from OKC_K_HEADERS_B a,
5988: okc_Governances_v g
5989: where a.id = g.chr_id_referred
5990: and a.sts_code = 'ACTIVE'
5991: and g.dnz_chr_id = p_contract_id
5992: and a.scs_code = 'CREDITLINE_CONTRACT'

Line 5999: okc_Governances_v g

5995: CURSOR c_MLA_credit (p_contract_id NUMBER)
5996: IS
5997: select a.ID
5998: from OKC_K_HEADERS_B a,
5999: okc_Governances_v g
6000: where a.id = g.chr_id_referred
6001: and a.sts_code = 'ACTIVE'
6002: and a.scs_code = 'CREDITLINE_CONTRACT'
6003: and g.dnz_chr_id = (select a1.ID -- MLA chrid

Line 6005: okc_Governances_v g1

6001: and a.sts_code = 'ACTIVE'
6002: and a.scs_code = 'CREDITLINE_CONTRACT'
6003: and g.dnz_chr_id = (select a1.ID -- MLA chrid
6004: from OKC_K_HEADERS_B a1,
6005: okc_Governances_v g1
6006: where a1.id = g1.chr_id_referred
6007: and g1.dnz_chr_id = p_contract_id
6008: and a1.scs_code = 'MASTER_LEASE')
6009: ;