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_SUBSIDY_PROCESS_PVT dependencies on OKC_STATUSES_B

Line 3442: okc_statuses_b stsb

3438: cursor l_asst_csr(p_chr_id in number) is
3439: select cleb.id
3440: from okc_k_lines_b cleb,
3441: okc_line_styles_b lseb,
3442: okc_statuses_b stsb
3443: where cleb.chr_id = p_chr_id
3444: and cleb.dnz_chr_id = p_chr_id
3445: and cleb.lse_id = lseb.id
3446: and lseb.lty_code = 'FREE_FORM1'

Line 3578: okc_statuses_b stsb

3574: cursor l_asst_csr(p_chr_id in number) is
3575: select cleb.id
3576: from okc_k_lines_b cleb,
3577: okc_line_styles_b lseb,
3578: okc_statuses_b stsb
3579: where cleb.chr_id = p_chr_id
3580: and cleb.dnz_chr_id = p_chr_id
3581: and cleb.lse_id = lseb.id
3582: and lseb.lty_code = 'FREE_FORM1'

Line 3710: okc_statuses_b stsb

3706: cursor l_asst_csr(p_chr_id in number) is
3707: select cleb.id
3708: from okc_k_lines_b cleb,
3709: okc_line_styles_b lseb,
3710: okc_statuses_b stsb
3711: where cleb.chr_id = p_chr_id
3712: and cleb.dnz_chr_id = p_chr_id
3713: and cleb.lse_id = lseb.id
3714: and lseb.lty_code = 'FREE_FORM1'

Line 3849: okc_statuses_b asst_sts

3845: okc_k_party_roles_b asst_vend,
3846: okc_k_lines_b model_cle,
3847: okc_line_styles_b model_lse,
3848: okc_k_lines_b asst_cle,
3849: okc_statuses_b asst_sts
3850: --subsidy vendor
3851: where sub_vend.dnz_chr_id = sub_cle.dnz_chr_id
3852: and sub_vend.object1_id1 = nvl(to_char(p_vendor_id),sub_vend.object1_id1)
3853: and sub_vend.object1_id1 = asst_vend.object1_id1 --to make sure asset and subsidy vendors are same

Line 4071: okc_statuses_b asst_sts

4067: okc_k_party_roles_b asst_vend,
4068: okc_k_lines_b model_cle,
4069: okc_line_styles_b model_lse,
4070: okc_k_lines_b asst_cle,
4071: okc_statuses_b asst_sts
4072: --subsidy vendor
4073: where sub_vend.dnz_chr_id = sub_cle.dnz_chr_id
4074: --and sub_vend.object1_id1 = to_char(nvl(p_vendor_id,sub_vend.object1_id1))
4075: and sub_vend.object1_id1 = asst_vend.object1_id1 --to make sure asset and subsidy vendors are same

Line 5281: okc_statuses_b stsb,

5277: ,kle.sty_id sty_id
5278: from okl_k_lines kle,
5279: okc_k_lines_tl clet,
5280: okc_k_lines_b cleb,
5281: okc_statuses_b stsb,
5282: okc_line_styles_b lseb,
5283: okc_k_party_roles_b cplb
5284: where kle.id = cleb.id
5285: and clet.id = cleb.id

Line 5315: okc_statuses_b stsb,

5311: ,kle.sty_id sty_id
5312: from okl_k_lines kle,
5313: okc_k_lines_tl clet,
5314: okc_k_lines_b cleb,
5315: okc_statuses_b stsb,
5316: okc_line_styles_b lseb,
5317: okc_k_party_roles_b cplb
5318: where kle.id = cleb.id
5319: and clet.id = cleb.id

Line 5417: okc_statuses_b asst_sts,

5413: asst_cleb.orig_system_id1 orig_asst_cle_id
5414:
5415: from
5416: okc_k_lines_b asst_cleb,
5417: okc_statuses_b asst_sts,
5418: okc_k_party_roles_b cplb,
5419: okc_k_lines_tl clet,
5420: okl_k_lines kle,
5421: okc_line_styles_b lseb,

Line 6282: OKC_STATUSES_B STSB,

6278: CURSOR c_rbk_subs (p_cle_id IN NUMBER
6279: , p_chr_id IN NUMBER) IS
6280: SELECT CLEB.ID
6281: FROM OKC_K_LINES_B CLEB,
6282: OKC_STATUSES_B STSB,
6283: OKC_LINE_STYLES_B LSEB
6284: WHERE CLEB.ORIG_SYSTEM_ID1 = p_cle_id
6285: AND CLEB.ORIG_SYSTEM_SOURCE_CODE ='OKC_LINE'
6286: AND CLEB.DNZ_CHR_ID = p_chr_id