APPS.OKL_SPLIT_ASSET_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4161: FROM mtl_system_items mtl,

4157: CURSOR chk_srl_csr (fin_ast_id IN NUMBER) IS
4158: SELECT mtl.serial_number_control_code,
4159: mtl.inventory_item_id,
4160: mtl.organization_id
4161: FROM mtl_system_items mtl,
4162: okc_k_items model_cim,
4163: okc_k_lines_b model_cle,
4164: okc_line_styles_b model_lse
4165: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)

Line 4221: FROM mtl_system_items mtl,

4217: --cursor to find serialized
4218: CURSOR srl_ctrl_csr (p_inv_item_id IN NUMBER,
4219: p_chr_id IN NUMBER) IS
4220: SELECT mtl.serial_number_control_code
4221: FROM mtl_system_items mtl,
4222: okc_k_headers_b chrb
4223: WHERE mtl.inventory_item_id = p_inv_item_id
4224: AND mtl.organization_id = chrb.inv_organization_id
4225: --BUG# 3489089

Line 4232: FROM mtl_system_items mtl,

4228: --cursor2 to find serialized
4229: CURSOR srl_ctrl_csr2 (p_inv_item_id IN NUMBER,
4230: p_cle_id IN NUMBER) IS
4231: SELECT mtl.serial_number_control_code
4232: FROM mtl_system_items mtl,
4233: okc_k_headers_b chrb,
4234: okc_k_lines_b cleb
4235: WHERE mtl.inventory_item_id = p_inv_item_id
4236: AND mtl.organization_id = chrb.inv_organization_id

Line 4240: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

4236: AND mtl.organization_id = chrb.inv_organization_id
4237: AND chrb.id = cleb.dnz_chr_id
4238: AND cleb.id = p_cle_id;
4239:
4240: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
4241:
4242: l_exception_halt EXCEPTION;
4243:
4244: BEGIN

Line 8570: FROM mtl_system_items msi

8566: --cursor to get asset category
8567: CURSOR l_msi_csr(p_inv_item_id IN NUMBER,
8568: p_inv_org_id IN NUMBER) IS
8569: SELECT msi.asset_category_id
8570: FROM mtl_system_items msi
8571: WHERE msi.organization_id = p_inv_org_id
8572: AND msi.inventory_item_id = p_inv_item_id;
8573:
8574: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;

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

8570: FROM mtl_system_items msi
8571: WHERE msi.organization_id = p_inv_org_id
8572: AND msi.inventory_item_id = p_inv_item_id;
8573:
8574: l_asset_category_id mtl_system_items.asset_category_id%TYPE DEFAULT NULL;
8575: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
8576: l_klev_rec okl_contract_pub.klev_rec_type;
8577: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
8578: lx_klev_rec okl_contract_pub.klev_rec_type;

Line 16135: FROM mtl_system_items mtl,

16131: --cursor to fetch serial number control code
16132: CURSOR srl_ctrl_csr (PInvItmId IN NUMBER,
16133: P_fin_ast_id IN NUMBER) IS
16134: SELECT mtl.serial_number_control_code
16135: FROM mtl_system_items mtl,
16136: okc_k_headers_b CHR,
16137: okc_k_lines_b cle
16138: WHERE mtl.inventory_item_id = PInvItmId
16139: AND mtl.organization_id = CHR.INV_ORGANIZATION_ID

Line 16144: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;

16140: AND CHR.id = cle.chr_id
16141: AND cle.id = P_fin_ast_id;
16142:
16143:
16144: l_srl_control_code mtl_system_items.serial_number_control_code%TYPE;
16145:
16146: l_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;
16147:
16148: --Bug# 5946411: ER