DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on OKL_TXL_ASSETS_B

Line 2687: okl_txl_assets_b tal,

2683: AND trxc.khr_id = pol.dnz_chr_id)
2684: AND NOT EXISTS -- split assets, split assets components
2685: (SELECT '1'
2686: FROM okl_txd_assets_v tdas,
2687: okl_txl_assets_b tal,
2688: okc_k_lines_b cle
2689: WHERE cle.id = tal.kle_id
2690: AND tal.id = tdas.tal_id
2691: AND tal.tal_type = 'ALI'

Line 2814: okl_txl_assets_b tal,

2810: AND khr_id = pol.dnz_chr_id)
2811: AND NOT EXISTS -- split assets, split assets components
2812: (SELECT '1'
2813: FROM okl_txd_assets_v tdas,
2814: okl_txl_assets_b tal,
2815: okc_k_lines_b cle
2816: WHERE cle.id = tal.kle_id
2817: AND tal.id = tdas.tal_id
2818: AND tal.tal_type = 'ALI'

Line 3230: okl_txl_assets_b tal,

3226: CURSOR l_okl_poc_splits_csr(p_dnz_chr_id IN NUMBER,p_kle_id IN NUMBER)
3227: IS
3228: SELECT '1'
3229: FROM okl_txd_assets_v tdas,
3230: okl_txl_assets_b tal,
3231: okc_k_lines_b cle
3232: WHERE cle.id = tal.kle_id
3233: AND tal.id = tdas.tal_id
3234: AND tal.tal_type = 'ALI'

Line 4184: okl_txl_assets_b talb,

4180: )
4181: AND EXISTS -- split assets, split assets components
4182: (SELECT '1'
4183: FROM okl_txd_assets_v tdas,
4184: okl_txl_assets_b talb,
4185: okc_k_lines_b cleb
4186: WHERE cleb.id = talb.kle_id
4187: AND talb.ID = tdas.TAL_ID
4188: AND talb.TAL_TYPE = 'ALI'

Line 4370: okl_txl_assets_b talb,

4366: )
4367: AND EXISTS -- split assets, split assets components
4368: (SELECT '1'
4369: FROM okl_txd_assets_v tdas,
4370: okl_txl_assets_b talb,
4371: okc_k_lines_b cleb
4372: WHERE cleb.id = talb.kle_id
4373: AND talb.ID = tdas.TAL_ID
4374: AND talb.TAL_TYPE = 'ALI'