APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 628: l_inventory_item_name okx_system_items_v.NAME%TYPE;

624: IS
625: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
626: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
627: l_inventory_item_id okl_txd_assets_B.INVENTORY_ITEM_ID%TYPE;
628: l_inventory_item_name okx_system_items_v.NAME%TYPE;
629:
630: CURSOR c(p_tal_id NUMBER)
631: IS
632: SELECT inventory_item_id

Line 643: FROM okx_system_items_v i

639: -- don't care the org_id
640: CURSOR c_name(p_inventory_item_id NUMBER)
641: IS
642: SELECT i.name
643: FROM okx_system_items_v i
644: WHERE i.ID1 = p_inventory_item_id
645: --group by i.name
646: ;
647: