eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 3661: CURSOR get_default_category(cp_inv_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

3657: AND rownum = 1;
3658:
3659: -- Bug# 9478943 - Added - Start
3660: -- Get the default category setup for an inventory item
3661: CURSOR get_default_category(cp_inv_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
3662: , cp_inv_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE) IS
3663: SELECT mtl.asset_category_id
3664: FROM mtl_system_items_b mtl,
3665: okx_asst_catgrs_v cat

Line 3662: , cp_inv_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE) IS

3658:
3659: -- Bug# 9478943 - Added - Start
3660: -- Get the default category setup for an inventory item
3661: CURSOR get_default_category(cp_inv_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
3662: , cp_inv_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE) IS
3663: SELECT mtl.asset_category_id
3664: FROM mtl_system_items_b mtl,
3665: okx_asst_catgrs_v cat
3666: WHERE inventory_item_id = cp_inv_item_id

Line 3664: FROM mtl_system_items_b mtl,

3660: -- Get the default category setup for an inventory item
3661: CURSOR get_default_category(cp_inv_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
3662: , cp_inv_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE) IS
3663: SELECT mtl.asset_category_id
3664: FROM mtl_system_items_b mtl,
3665: okx_asst_catgrs_v cat
3666: WHERE inventory_item_id = cp_inv_item_id
3667: AND organization_id = cp_inv_org_id
3668: AND cat.id1 = mtl.asset_category_id;