DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 5367: from mtl_system_items msi

5363: --cursor to get asset category
5364: cursor l_msi_csr(p_inv_item_id in number,
5365: p_inv_org_id in number) is
5366: select msi.asset_category_id
5367: from mtl_system_items msi
5368: where msi.organization_id = p_inv_org_id
5369: and msi.inventory_item_id = p_inv_item_id;
5370:
5371: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;

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

5367: from mtl_system_items msi
5368: where msi.organization_id = p_inv_org_id
5369: and msi.inventory_item_id = p_inv_item_id;
5370:
5371: l_asset_category_id mtl_system_items.asset_category_id%TYPE default NULL;
5372: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5373: l_klev_rec okl_contract_pub.klev_rec_type;
5374: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5375: lx_klev_rec okl_contract_pub.klev_rec_type;