APPS.OKL_POOL_PVT dependencies on OKL_TXD_ASSETS_V

Line 2686: FROM okl_txd_assets_v tdas,

2682: AND trxc.tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
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

Line 2813: FROM okl_txd_assets_v tdas,

2809: AND tsu_code NOT IN ('PROCESSED', 'ERROR','CANCELED') -- condition changes 01/13/2003 cklee
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

Line 3229: FROM okl_txd_assets_v tdas,

3225: -- split assets, split assets components
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

Line 4183: FROM okl_txd_assets_v tdas,

4179: AND trxb.khr_id = poc.khr_id
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

Line 4369: FROM okl_txd_assets_v tdas,

4365: AND trxb.khr_id = poc.khr_id
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