DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2053: FROM mtl_system_items_b_kfv

2049: WHERE fund_id = p_prod_used_by;
2050:
2051: CURSOR c_inv_id_exists (p_inventory_id IN NUMBER, p_org_id IN NUMBER) IS
2052: SELECT 1
2053: FROM mtl_system_items_b_kfv
2054: WHERE organization_id = p_org_id
2055: AND inventory_item_id = p_inventory_id;
2056:
2057: CURSOR c_inv_name_exists (p_inventory_name IN VARCHAR2, p_org_id IN NUMBER) IS

Line 2059: FROM mtl_system_items_b_kfv

2055: AND inventory_item_id = p_inventory_id;
2056:
2057: CURSOR c_inv_name_exists (p_inventory_name IN VARCHAR2, p_org_id IN NUMBER) IS
2058: SELECT inventory_item_id
2059: FROM mtl_system_items_b_kfv
2060: WHERE organization_id = p_org_id
2061: AND concatenated_segments = p_inventory_name;
2062:
2063: CURSOR c_cat_id_exists (p_category_id IN NUMBER) IS