DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 5408: from mtl_system_items msi

5404: --cursor to get asset category
5405: cursor l_msi_csr(p_inv_item_id in number,
5406: p_inv_org_id in number) is
5407: select msi.asset_category_id
5408: from mtl_system_items msi
5409: where msi.organization_id = p_inv_org_id
5410: and msi.inventory_item_id = p_inv_item_id;
5411:
5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;

Line 5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;

5408: from mtl_system_items msi
5409: where msi.organization_id = p_inv_org_id
5410: and msi.inventory_item_id = p_inv_item_id;
5411:
5412: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5413: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5414: l_klev_rec okl_contract_pub.klev_rec_type;
5415: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5416: lx_klev_rec okl_contract_pub.klev_rec_type;