APPS.OKL_SPLIT_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4189: FROM mtl_system_items mtl,

4185: CURSOR chk_srl_csr (fin_ast_id IN NUMBER) IS
4186: SELECT mtl.serial_number_control_code,
4187: mtl.inventory_item_id,
4188: mtl.organization_id
4189: FROM mtl_system_items mtl,
4190: okc_k_items model_cim,
4191: okc_k_lines_b model_cle,
4192: okc_line_styles_b model_lse
4193: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)

Line 4249: FROM mtl_system_items mtl,

4245: --cursor to find serialized
4246: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
4247: p_chr_id IN NUMBER) IS
4248: SELECT mtl.serial_number_control_code
4249: FROM mtl_system_items mtl,
4250: okc_k_headers_b chrb
4251: WHERE mtl.inventory_item_id = p_inv_item_id
4252: AND mtl.organization_id = chrb.inv_organization_id
4253: --BUG# 3489089

Line 4260: FROM mtl_system_items mtl,

4256: --cursor2 to find serialized
4257: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
4258: p_cle_id IN NUMBER) IS
4259: SELECT mtl.serial_number_control_code
4260: FROM mtl_system_items mtl,
4261: okc_k_headers_b chrb,
4262: okc_k_lines_b cleb
4263: WHERE mtl.inventory_item_id = p_inv_item_id
4264: AND mtl.organization_id = chrb.inv_organization_id

Line 4268: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

4264: AND mtl.organization_id = chrb.inv_organization_id
4265: AND chrb.id = cleb.dnz_chr_id
4266: AND cleb.id = p_cle_id;
4267:
4268: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
4269:
4270: l_exception_halt EXCEPTION;
4271:
4272: BEGIN

Line 8623: FROM mtl_system_items msi

8619: --cursor to get asset category
8620: CURSOR l_msi_csr(p_inv_item_id IN NUMBER,
8621: p_inv_org_id IN NUMBER) IS
8622: SELECT msi.asset_category_id
8623: FROM mtl_system_items msi
8624: WHERE msi.organization_id = p_inv_org_id
8625: AND msi.inventory_item_id = p_inv_item_id;
8626:
8627: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;

Line 8627: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;

8623: FROM mtl_system_items msi
8624: WHERE msi.organization_id = p_inv_org_id
8625: AND msi.inventory_item_id = p_inv_item_id;
8626:
8627: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8628: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8629: l_klev_rec okl_contract_pub.klev_rec_type;
8630: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8631: lx_klev_rec okl_contract_pub.klev_rec_type;

Line 16227: FROM mtl_system_items mtl,

16223: --cursor to fetch serial number control code
16224: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16225: P_fin_ast_id IN NUMBER) IS
16226: SELECT mtl.serial_number_control_code
16227: FROM mtl_system_items mtl,
16228: okc_k_headers_b CHR,
16229: okc_k_lines_b cle
16230: WHERE mtl.inventory_item_id = PInvItmId
16231: AND mtl.organization_id = CHR.INV_ORGANIZATION_ID

Line 16236: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

16232: AND CHR.id = cle.chr_id
16233: AND cle.id = P_fin_ast_id;
16234:
16235:
16236: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
16237:
16238: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
16239:
16240: --Bug# 5946411: ER