DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_IB_PVT dependencies on OKL_TXL_ITM_INSTS

Line 181: FROM OKL_TXL_ITM_INSTS iti

177: CREATION_DATE,
178: LAST_UPDATED_BY,
179: LAST_UPDATE_DATE,
180: LAST_UPDATE_LOGIN
181: FROM OKL_TXL_ITM_INSTS iti
182: WHERE iti.kle_id = p_kle_id
183: and iti.tal_type = p_trx_type
184: and exists (select '1' from OKL_TRX_ASSETS
185: where OKL_TRX_ASSETS.TAS_TYPE = p_trx_type

Line 2450: okl_txl_itm_insts iti,

2446: From okc_k_items cim_ib,
2447: okc_k_lines_b cleb_ib,
2448: okc_line_styles_b lseb_ib,
2449: okc_statuses_b stsb,
2450: okl_txl_itm_insts iti,
2451: okl_trx_assets trx,
2452: okl_trx_types_tl ttyt
2453: where iti.kle_id = cleb_ib.id
2454: and iti.tas_id = trx.id

Line 3061: FROM okl_txl_itm_insts iti,

3057:
3058: CURSOR srl_num_new_csr(p_rbk_fin_ast_cle_id IN NUMBER,
3059: p_rbk_ib_cle_id IN NUMBER) IS
3060: SELECT serial_number
3061: FROM okl_txl_itm_insts iti,
3062: okl_trx_assets tas
3063: WHERE iti.dnz_cle_id = P_rbk_fin_ast_cle_id
3064: AND iti.kle_id = p_rbk_ib_cle_id
3065: AND iti.tal_type = G_TRX_LINE_TYPE_REBOOK