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_POOL_AUTH_TRX_PVT dependencies on OKC_K_LINES_B

Line 194: ,okc_k_lines_b cleb

190: ,cleb.cle_id asset_id
191: ,cleb.currency_code
192: FROM okl_k_lines kle
193: ,okc_k_lines_tl clet
194: ,okc_k_lines_b cleb
195: ,okc_statuses_b stsb
196: ,okc_line_styles_b lseb
197: ,okc_k_party_roles_b cplb
198: WHERE kle.id = cleb.id

Line 210: CURSOR c_get_asset_csr (cp_asset_id okc_k_lines_b.id%TYPE)IS

206: AND cplb.cle_id = cleb.id
207: AND cplb.rle_code = 'OKL_VENDOR'
208: AND cplb.dnz_chr_id = cp_chr_id;
209:
210: CURSOR c_get_asset_csr (cp_asset_id okc_k_lines_b.id%TYPE)IS
211: SELECT clev_asst.name asset_number
212: FROM okc_k_lines_v clev_asst
213: WHERE clev_asst.id = cp_asset_id;
214: lv_asset_number okc_k_lines_v.name%TYPE;

Line 327: ,p_asset_id IN okc_k_lines_b.id%TYPE

323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER
325: ,x_msg_data OUT NOCOPY VARCHAR2
326: ,p_chr_id IN okc_k_headers_b.id%TYPE
327: ,p_asset_id IN okc_k_lines_b.id%TYPE
328: ,p_subsidy_id IN okl_subsidies_b.id%TYPE
329: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
330: ,p_trx_amount IN okl_k_lines.amount%TYPE
331: ) IS

Line 563: okc_k_lines_b cleb_sub,

559: subb.id subsidy_id
560: FROM okl_subsidies_b subb,
561: okl_k_lines kle_sub,
562: okc_k_lines_tl clet_sub,
563: okc_k_lines_b cleb_sub,
564: okc_line_styles_b lseb_sub,
565: okc_k_lines_tl clet_asst,
566: okc_k_lines_b cleb_asst,
567: okc_line_styles_b lseb_asst

Line 566: okc_k_lines_b cleb_asst,

562: okc_k_lines_tl clet_sub,
563: okc_k_lines_b cleb_sub,
564: okc_line_styles_b lseb_sub,
565: okc_k_lines_tl clet_asst,
566: okc_k_lines_b cleb_asst,
567: okc_line_styles_b lseb_asst
568: WHERE subb.id = kle_sub.subsidy_id
569: AND kle_sub.id = cleb_sub.id
570: AND clet_sub.id = cleb_sub.id

Line 816: ,okc_k_lines_b cleb

812: ,cleb.cle_id asset_id
813: ,cleb.currency_code
814: FROM okl_k_lines kle
815: ,okc_k_lines_tl clet
816: ,okc_k_lines_b cleb
817: ,okc_statuses_b stsb
818: ,okc_line_styles_b lseb
819: ,okc_k_party_roles_b cplb
820: WHERE kle.id = cleb.id

Line 851: ,okc_k_lines_b cleb

847: ,cleb.cle_id asset_id
848: ,cleb.currency_code
849: FROM okl_k_lines kle
850: ,okc_k_lines_tl clet
851: ,okc_k_lines_b cleb
852: ,okc_statuses_b stsb
853: ,okc_line_styles_b lseb
854: ,okc_k_party_roles_b cplb
855: WHERE kle.id = cleb.id

Line 882: FROM okc_k_lines_b cleb

878: ,kle.SUBSIDY_OVERRIDE_AMOUNT
879: ,cleb.cle_id asset_id
880: ,cleb.currency_code
881: ,kle.subsidy_id subsidy
882: FROM okc_k_lines_b cleb
883: ,okc_line_styles_b lseb
884: ,okc_k_party_roles_b cplb
885: ,okl_k_lines kle
886: WHERE cleb.dnz_chr_id = p_orig_chr_id

Line 895: FROM okc_k_lines_b cleb2

891: AND cplb.rle_code = 'OKL_VENDOR'
892: AND kle.id = cleb.id
893: --line was deleted from rebook copy :
894: AND NOT EXISTS (SELECT '1'
895: FROM okc_k_lines_b cleb2
896: WHERE cleb2.orig_system_id1 = cleb.id
897: AND cleb2.dnz_chr_id = p_rbk_chr_id)
898: --line is not a new line created during this rebook
899: AND NOT EXISTS (SELECT '1'

Line 900: FROM okc_k_lines_b cleb3

896: WHERE cleb2.orig_system_id1 = cleb.id
897: AND cleb2.dnz_chr_id = p_rbk_chr_id)
898: --line is not a new line created during this rebook
899: AND NOT EXISTS (SELECT '1'
900: FROM okc_k_lines_b cleb3
901: WHERE cleb3.id = cleb.orig_system_id1
902: AND cleb3.dnz_chr_id = p_rbk_chr_id);
903: lv_rec_del_sub_csr l_del_sub_csr%ROWTYPE;
904:

Line 925: FROM okc_k_lines_b asst_cleb

921: ,cleb.currency_code currency_code
922: ,cleb.sts_code sts_code
923: ,kle.sty_id sty_id
924: ,asst_cleb.orig_system_id1 orig_asst_cle_id
925: FROM okc_k_lines_b asst_cleb
926: ,okc_statuses_b asst_sts
927: ,okc_k_party_roles_b cplb
928: ,okc_k_lines_tl clet
929: ,okl_k_lines kle

Line 931: ,okc_k_lines_b cleb

927: ,okc_k_party_roles_b cplb
928: ,okc_k_lines_tl clet
929: ,okl_k_lines kle
930: ,okc_line_styles_b lseb
931: ,okc_k_lines_b cleb
932: WHERE asst_cleb.id = cleb.cle_id
933: AND asst_cleb.dnz_chr_id = cleb.dnz_chr_id
934: AND asst_sts.code = asst_cleb.sts_code
935: AND asst_sts.ste_code not in ('HOLD','EXPIRED','TERMINATED','CANCELLED')

Line 953: CURSOR c_get_asst_number (cp_asset_id okc_k_lines_b.id%TYPE)IS

949: l_new_sub_rec l_new_sub_csr%ROWTYPE;
950:
951: -- cursor to get the asset number for pool transaction record
952: -- added for subsidy pools enhancement
953: CURSOR c_get_asst_number (cp_asset_id okc_k_lines_b.id%TYPE)IS
954: SELECT name asset_number
955: FROM okc_k_lines_v
956: WHERE id = cp_asset_id;
957: lv_asset_number okc_k_lines_v.name%TYPE;

Line 959: CURSOR c_get_orig_asst (cp_asset_id okc_k_lines_b.id%TYPE) IS

955: FROM okc_k_lines_v
956: WHERE id = cp_asset_id;
957: lv_asset_number okc_k_lines_v.name%TYPE;
958:
959: CURSOR c_get_orig_asst (cp_asset_id okc_k_lines_b.id%TYPE) IS
960: SELECT orig_system_id1
961: FROM okc_k_lines_b
962: WHERE id = cp_asset_id;
963: cv_get_orig_asst c_get_orig_asst%ROWTYPE;

Line 961: FROM okc_k_lines_b

957: lv_asset_number okc_k_lines_v.name%TYPE;
958:
959: CURSOR c_get_orig_asst (cp_asset_id okc_k_lines_b.id%TYPE) IS
960: SELECT orig_system_id1
961: FROM okc_k_lines_b
962: WHERE id = cp_asset_id;
963: cv_get_orig_asst c_get_orig_asst%ROWTYPE;
964:
965: lv_orig_subsidy_applic VARCHAR2(10);