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 3223: FROM okl_txd_assets_v tdas,

3219: -- split assets, split assets components
3220: CURSOR l_okl_poc_splits_csr(p_dnz_chr_id IN NUMBER,p_kle_id IN NUMBER)
3221: IS
3222: SELECT '1'
3223: FROM okl_txd_assets_v tdas,
3224: okl_txl_assets_b tal,
3225: okc_k_lines_b cle
3226: WHERE cle.id = tal.kle_id
3227: AND tal.id = tdas.tal_id

Line 4177: FROM okl_txd_assets_v tdas,

4173: AND trxb.khr_id = poc.khr_id
4174: )
4175: AND EXISTS -- split assets, split assets components
4176: (SELECT '1'
4177: FROM okl_txd_assets_v tdas,
4178: okl_txl_assets_b talb,
4179: okc_k_lines_b cleb
4180: WHERE cleb.id = talb.kle_id
4181: AND talb.ID = tdas.TAL_ID

Line 4362: FROM okl_txd_assets_v tdas,

4358: AND trxb.khr_id = poc.khr_id
4359: )
4360: AND EXISTS -- split assets, split assets components
4361: (SELECT '1'
4362: FROM okl_txd_assets_v tdas,
4363: okl_txl_assets_b talb,
4364: okc_k_lines_b cleb
4365: WHERE cleb.id = talb.kle_id
4366: AND talb.ID = tdas.TAL_ID