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 2477: okl_txl_itm_insts iti,

2473: From okc_k_items cim_ib,
2474: okc_k_lines_b cleb_ib,
2475: okc_line_styles_b lseb_ib,
2476: okc_statuses_b stsb,
2477: okl_txl_itm_insts iti,
2478: okl_trx_assets trx,
2479: okl_trx_types_tl ttyt
2480: where iti.kle_id = cleb_ib.id
2481: and iti.tas_id = trx.id

Line 3098: FROM okl_txl_itm_insts iti,

3094:
3095: CURSOR srl_num_new_csr(p_rbk_fin_ast_cle_id IN NUMBER,
3096: p_rbk_ib_cle_id IN NUMBER) IS
3097: SELECT serial_number
3098: FROM okl_txl_itm_insts iti,
3099: okl_trx_assets tas
3100: WHERE iti.dnz_cle_id = P_rbk_fin_ast_cle_id
3101: AND iti.kle_id = p_rbk_ib_cle_id
3102: AND iti.tal_type = G_TRX_LINE_TYPE_REBOOK