DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKC_LINE_STYLES_B

Line 196: ,okc_line_styles_b lseb

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
199: AND clet.id = cleb.id
200: AND clet.language = userenv('LANG')

Line 564: okc_line_styles_b lseb_sub,

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
568: WHERE subb.id = kle_sub.subsidy_id

Line 567: okc_line_styles_b lseb_asst

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
571: AND clet_sub.language = userenv('LANG')

Line 818: ,okc_line_styles_b lseb

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
821: AND clet.id = cleb.id
822: AND clet.language = userenv('LANG')

Line 853: ,okc_line_styles_b lseb

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
856: AND clet.id = cleb.id
857: AND clet.language = userenv('LANG')

Line 883: ,okc_line_styles_b lseb

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
887: AND lseb.id = cleb.lse_id

Line 930: ,okc_line_styles_b lseb

926: ,okc_statuses_b asst_sts
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